Stock Exchange data available/downloadable but not selectable

JFG's Avatar

JFG

28 Jan, 2011 08:50 AM

Yahoo US provides accurate data for a number of my funds via the Swiss EBS (".SW") exchange. The data is searchable on Yahoo, and up-to-date data is downloadable from Yahoo (as a ".csv" file).

However, the Swiss EBS exchange is not available for selection in the Quotes and Exchange Rates extension.

For example, for the fund with ISIN LU0187079180, I searched for symbols/exchanges using:

http://finance.yahoo.com/lookup?s=LU0187079180

which lists all the exchanges and symbols for which Yahoo has data for this fund. I then found that accurate up-to-date info is available at:

http://finance.yahoo.com/q?s=1794743.SW

It will even allow me to download the information as a .csv file.

So the Quotes and Exchange Rates extension should be able to retrieve the information, however the Swiss EBS Exchange is not in the list of exchanges in the extension. And if I enter "1794743.SW" as the symbol name, the extension reports an error (I think it tries to map it to its list of exchanges and fails).

If this could be corrected, it would solve a big issue for most of the funds I hold.

Regards,
Scott.

  1. 1 Posted by Ben Spencer on 28 Jan, 2011 07:23 PM

    Ben Spencer's Avatar

    Hi Scott

    I believe the problem is not that the extension does not support the security exchange rather that by default Moneydance is not configured to include the Swiss Franc. I add the Swiss Franc to Moneydance and I was then able to download the current price for "1794743.SW"

    To add the Swiss Franc select Tools->Currencies/Exchange rates...

    Click the "Add" button.

    Set the Currency ID to: CHF

    Set the name to: Swiss Franc

    Set the value prefix to SFr

    let me know if that helps.

    Sincerely
    Ben Spencer
    Moneydance Support

  2. 2 Posted by JFG on 28 Jan, 2011 07:34 PM

    JFG's Avatar

    Thanks for your response, but I don't think that will help, since all the funds are listed in Euros and USD on the EBS, not Swiss Francs. How do I get it to use the correct currencies?

  3. 3 Posted by Ben Spencer on 28 Jan, 2011 07:57 PM

    Ben Spencer's Avatar

    I am not certain what you mean by the EBS. "1794743.SW" is traded on the SIX. I my be wrong and it is my understanding that securities on the SIX are priced in CHF.

    Ben Spencer

  4. 4 Posted by JFG on 28 Jan, 2011 08:50 PM

    JFG's Avatar

    Hi Ben,

    Click the first link I gave you, and you'll see ".SW" is listed as the "EBS" exchange.

    Click the second link, and you'll see the prices quoted in Euro's (text in grey "Quotes delayed, except where indicated otherwise. Currency in EUR.").

    I keep repeating myself on this one, but exchanges do not all quote prices in one currency. USD funds quote USD prices in various European exchanges, Euro Funds quote Euro prices. This is, time and again, what I have said is one of the problems with this extension - we need to be able to specify the currency SEPARATELY from the exchange.

    This is a EURO fund traded on a Swiss exchange, quoting EURO prices.

    Scott.

  5. 5 Posted by JFG on 28 Jan, 2011 10:02 PM

    JFG's Avatar

    Ben,

    Here's an example (one of hundreds). Go to the Luxembourg exchange and get a quote on the Franklin Templeton China Fund.

    http://www.bourse.lu/application?_flowId=ValueSummaryOpcFlow&cd...

    As you can see, the prices are quoted in USD, despite Luxembourg being a Euro country.

    Can we now please (!) be able to specify the currency used, rather than the extension just using the currency in which the exchange is located? It just makes no sense to keep ignoring paying users.

    Scott.

  6. 6 Posted by Tom Freeman on 28 Feb, 2011 05:42 PM

    Tom Freeman's Avatar

    Scott,

    The extension uses Yahoo finance downloads. If you put LU0187079180 into the Yahoo UK site you do not get a listing for the Luxembourg exchange. (see screenshot)

    The extension was built to get its information from Yahoo from its available downloads. If Yahoo does not provide the information then the extension is not going to work.

    I now this is frustrating. We are looking for a comprehensive, reliable, and available source for this information.

    Tom

  7. 7 Posted by Stephane on 29 May, 2011 04:59 PM

    Stephane's Avatar

    Hi Tom,

    I have the same problems as Scott does.
    Did you already sorted this problem out ?
    I've got a whole bunch of Mutual funds having an ISIN code for which I don't know what to do.
    Did you already found a reliable source of information ?

    Regards

    Stephane

  8. 8 Posted by Jon Hoover on 29 May, 2011 06:52 PM

    Jon Hoover's Avatar

    Stephane,
    Unfortunately we have not yet found a good source. Part of the issue is that we would probably have to pay for this sort of information (whats on yahoo is free) as a survey of our users I am wondering if you would be willing to pay extra for this information either as an increased cost in Moneydance or as a subscription?
    Sorry I could not be of more help right now, please let me know if you have any additional questions.
    Jon Hoover, Moneydance Support

  9. 9 Posted by Stephane on 29 May, 2011 08:46 PM

    Stephane's Avatar

    Hi Jon,

    In reply to your survey.
    Yes I would be willing to pay for an additional service.
    Other financial planners do also provide different "price levels" according to the provided service, so why not for Moneydance.

    Regards

    Stephane

  10. System closed this discussion on 31 Mar, 2015 03:42 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac