Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Qute Servers - retrieving Foreign Bond Prices

General questions about using Fund Manager that do not fit into any other forum.

Postby nebfinfm » Tue Nov 22, 2011 4:24 am

Problem retrieving prices of Overseas Bonds.

I have a problem using the most valuable feature of FM – the Price Retrieving. Most servers on FM quote server list works only with stocks. Retrieving foreign (non-North American) bond prices without issued CUSIP number doesn't work well, or not at all . FINRA work only with North American bonds

Yahoo appear to be the only server where foreign bonds are found (not always). Yahoo doesn't recognize ISIN number, so symbol acceptable by Yahoo must be found. Although Yahoo recognize German WKN (Security Code Number) identifier/symbol for bonds traded on German stock exchanges , BUT IT DOESN'T UPDATE THE PRICES.
Yahoo doesn't recognize other identifiers like ISIN, British SEDOL or BB number .
To get actual prices I'm using German stock exchanges (Frankfurt, Stuttgart, Berlin) and Luxembourg.

Example for the technically minded: Bond BAA SH PLC 7.125
Identifiers: ISIN= XS0555678597 * Sedol= B5LB6C0 * WKN= A1A3ET
Bond is listed on www.boerse-stuttgart.de under ISIN and on Yahoo symbol A1A3ET.F
It can be seen that Yahoo price doesn't update

Mark, would it be possible that FM retrieve prices from those exchanges? My friends like very much FM, just waiting for this problem to be solved.

Thanks Nebfin
nebfinfm
 
Posts: 95
Joined: Thu Apr 07, 2011 12:54 pm

Postby Mark » Tue Nov 22, 2011 11:06 am

Hi Nebfin,

Thanks for the nice example, and quote server suggestion. In looking up that quote on Yahoo they only offer Bid/Ask, and there is no "Last" price available, so it doesn't look like they actually have the data. Would adding support for www.boerse-stuttgart.de be sufficient to retrieve prices from all those exchanges?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11707
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby nebfinfm » Wed Nov 23, 2011 12:21 am

Hi Mark, I really appreciate your quick response!!! The foreign bonds I'm interested in are listed on German, Luxembourg, UK/London and Australian markets. They are usually listed by ISIN, WKN (Germany) and SEDOL (British) identifiers/symbols. it will be great if FM can retrieve prices from the following markets:

* German:
Frankfurt: www.frankfurtstockexchange.de
Stuttgart: www.boerse-stuttgart.de/en/
Deutsche Boerse Group: http://deutsche-boerse.com/dbag/dispatc ... ation/home

* Luxembourg:
Luxembourgh: www.bourse.lu/Accueil.jsp
Luxembourgh Bonds: www.luxnext.com/

* UK: www.londonstockexchange.com/home/homepage.htm

I guess that 90% of world bonds (UK, European, Brazil, Australia ...) are listed on above markets. Usefulness of FM will greatly improve if it can retrieve those prices.

Thanks Nebfin
nebfinfm
 
Posts: 95
Joined: Thu Apr 07, 2011 12:54 pm

Postby Mark » Wed Nov 23, 2011 9:09 am

Hi Nebfin,

Thanks for the help. Our goal would be to expand on the existing quote coverage over our existing quote servers. Do all of these quote servers offer quotes not available on our existing servers like Bloomberg? If we had to prioritize and only support some of these, which do you feel would be the most valuable?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11707
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby nebfinfm » Wed Nov 23, 2011 10:46 am

Hi Mark. I couldn't get bond prices on Bloomberg site. Maybe you can try, here is an example of bond listed in Frankfurt / Stuttgart exchange

EUR Magyar Telecom HTC 9,5 * ISIN= nXS0473176658 * WKN number= A1AQ66.F

I guess the most valuable site for BOND prices will come from rom XETRA- Deutsche Boerse Group / Stuttgart / Frankfurt exchange.

Thanks
Nebfin
nebfinfm
 
Posts: 95
Joined: Thu Apr 07, 2011 12:54 pm

Postby Mark » Wed Nov 23, 2011 10:57 am

Hi Nebfin,

Thanks for the help. We will look into these servers for possible addition into a future release.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11707
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby nebfinfm » Wed Nov 23, 2011 10:34 pm

Hi Mark, when do you expect next release FM?
Nebfin
nebfinfm
 
Posts: 95
Joined: Thu Apr 07, 2011 12:54 pm

Postby Mark » Thu Nov 24, 2011 8:54 am

Hi Nebfin,

There is no scheduled release date for FM 12, but just based on past release frequencies I would expect it sometime around mid to late 2012. FM 11 was released in April of 2011, and we average about 1.5 years between major releases. You can see the revision history here:

http://www.fundmanagersoftware.com/modlist.html
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11707
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Mark » Tue Aug 20, 2013 6:58 pm

Hi Nebfin,

We have just released quote module 444 which adds support for Boerse Stuttgart. For info on using this quote server, see:

http://www.fundmanagersoftware.com/intr ... #Stuttgart

To obtain this new quote module, make sure you are using a 12.x or later version, and select "Help / Fund Manager on the Web / Check for Updates...".
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11707
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Tue Aug 20, 2013 11:15 pm

Hi I am having the same problem with foreign bonds eg AU3CB0209229 cusip

Looked on all the servers on the prog but cannot update
I can find it on swiss quote site but prog does not recover the quotes

I would love to buy the software but as most of my portfolio is in bonds I am doubful if this can be corrected

Alan
alpappy
 
Posts: 366
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Wed Aug 21, 2013 9:41 am

Hi Alan,

What country are your bonds from? Is there some site you know of that offers the quotes you need, that maybe we could add support for?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11707
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Wed Aug 21, 2013 3:32 pm

Hi some are NZ ie need support for nzx site Yahoo AUs/NZ gives only yields not buy sell

rest I can find on swiss quote website but they do not update in the prog.

I can also find most on the XTRA site

Hope that helps

Thanks
Alan
alpappy
 
Posts: 366
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Thu Aug 22, 2013 7:30 am

Hi Alan,

What is the URL for the "XTRA" site that has these quotes? I'm not familiar with that site.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11707
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Thu Aug 22, 2013 4:31 pm

http://xetra.com/xetra/dispatch/en/kir/navigation/xetra?

Sorry typo this server finds most of my foreign issues ie AUD bonds issued in europe
alan
alpappy
 
Posts: 366
Joined: Sat Aug 17, 2013 3:59 am

Postby alpappy » Thu Aug 22, 2013 4:36 pm

AU3FN0017612

try this one on Xetra works 100% not found on your other servers

NZX would be useful for nz bonds
thanks
alan
alpappy
 
Posts: 366
Joined: Sat Aug 17, 2013 3:59 am

Next

Return to General

Who is online

Users browsing this forum: No registered users and 18 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2025 Beiley Software, Inc. All rights reserved.