Stocks in a different currency from their parent exchange
I'm uncertain how to deal with stocks that are priced in a different currency than the parent exchange. For example, look at the ETFS PHAU, which is priced in USD but traded on the London exchange. The current price in about $124, but when Moneydance downloads the price it assumes that because it's a London exchange, the price is £124 - which represents a substantial overpricing. The History chart allows me to display the price in different currencies, but what seems to be missing is a way to designate that the downloaded prices for this stock are in USD, not GBP.
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
1 Posted by dwg on 29 Dec, 2017 09:49 AM
I have not had a need to do this myself but I think that it may require a custom entry be added to the StockExchanges.dict file.
Anyone else care to comment?
2 Posted by Ed on 29 Dec, 2017 10:00 AM
Thanks very much, I just took a look at that .dict file. I assume the possible approach would be duplicate one of the existing UK exchange entries but rename it to differentiate it from the existing exchange entries priced in £ or pence, then also change the currency ID to USD. Finally, to select that exchange as the one to use for prices for USD-priced stocks such as PHAU. Do I have that right?
Something like this?
"name" = "London Exchange (USD)"
"id" = "lg-ln-lon"
"country" = "United Kingdom"
"mtr" = "08:00 - 16:30"
"google_id" = "LON"
"pre_mtr" = ""
"price_multiplier" = "1.0"
"curr_name" = "US Dollars"
"thomson_id" = "LN"
"curr_id" = "USD"
"gmt_diff" = "0"
"yahoo_id" = ".L"
"post_mtr" = ""
"time_zone" = "Greenwich Mean Time (GMT)"
3 Posted by dwg on 29 Dec, 2017 10:04 AM
That is the sort of thing I was thinking of, although I would make things like curr_name, curr_id etc match what is in one of the US exchange entries.
4 Posted by derekkent23 on 29 Dec, 2017 12:54 PM
I am not support staff, just a user.
I have had to do the same thing to accommodate USD on the London Stock Exchange and Pounds and USD on the Irish Stock Exchange which assumes Euros.
You need to change the line "id" = "lg-ln-lon" to be unique, say "id" = "lg-ln-lon-usd"
Hope this helps.
5 Posted by derekkent23 on 29 Dec, 2017 01:09 PM
I am not support staff, just a user.
Also Ed how are you finding Alpha Vantage?
I am a UK investor and have found that Alpha Vantage provide very poor support for UK/Irish/Luxenberg domiciled funds. At my last test Alpha Vantage returned 7 of my 43 funds, sometimes with errors and until Sean sorts out the TEST feature which gives misleading information I am not inclined to send further time checking each one of the 43 to see if the hit rate has improved.
I am currently testing a stand-alone program that was originally developed to help out users of MS Money when Microsoft stopped supporting that product. The developer is in the beta stages of adapting it to work with Moneydance. At this point you can enter a list of securities symbols directly or pasted from a file or by importing a text file. Run the program, see the returned quotes, save the quote as a QIF file and import it into Moneydance. It does not return a history just the last days quoted price. Importing the file automatically update the dated and current price of each security listed. Note if a current price has already been entered then it will not be updated until a QIF file is imported on the following day, Moneydance seem to allow only one current price update per day. The developer is also working on some other feature to improve the users experience. Attached is a PDF that shows how to use this program. The stand-alone program returns accurate results on 40 of the 43 funds. It also has the advantage that you can take a look at the values returned before you import into Moneydance. You can export in either a QIF file format which can you import direct into Moneydance or a CSV file if you prefer to use the Security Price Loader.
Hope this helps.
6 Posted by dwg on 29 Dec, 2017 01:20 PM
FWIW the ID appears to be a combination of the Yahoo, Google & Thomson (Reuters) ID's for the exchange although not always in the same order, the "g" in Derek's example seems to indicate GBP and for pence they have replaced the "g" with "p"
7 Posted by derekkent23 on 29 Dec, 2017 01:41 PM
I am not support staff, just a user.
I think “id” = “…..”
is used by the program so it understands the data in that section forms one of the exchanges in the drop down. Thus, why it needs to be a unique identifier. The actual content of “…...” is meaningless, except to us humans.
Hope this helps.
8 Posted by Ed on 29 Dec, 2017 02:27 PM
Thanks to you both, I have got the revised-currency exchanges working fine.
Derek, thanks also for the standalone updater which I have also now used successfully to update current prices for various funds that Alphavantage doesn't seem to cover, all of which were accessible via this tool using the FT prices. I did need to manually adjust from pence to pounds for most of them, but your comprehensive instructions made the whole process easy.
Overall Alphavantage seems to be improving and now working OK for individual stocks, though it looks like the historical data have periodic glitches in which the price is offset, sometimes just for a single price, at other times for several days in succession. These look to me as though the data were retrieved in the wrong currency on those days, as the degree of offset is pretty consistent in the multi-day runs. Take a look at the attached history for LWDB, for example. I live in hope that these glitches will get fixed.
9 Posted by derekkent23 on 29 Dec, 2017 05:35 PM
I am not support staff, just a user.
Hi, Ed
One trick I did not mention is how to automatically convert pence into pounds. For example, the fund LU1646359619 is always quoted in pence. However, if you have always been entering this as pounds in Moneydance then add the following to the symbol /GBX/GBP to give LU1646359619 /GBX/GBP
The Price screen still shows the value in pence but the exported CSV file will be in pounds. The developer has not yet introduced this feature into the QIF exported file.
Also, not yet in the QIF file, but in the CSV file is currency conversion. Say you have a security that is returned in USD, but you have always entered it in Moneydance in pounds, do the following.
Add to the security window the request for the current exchange rate USDGBP on a separate line. Then for a symbol, say AAPL that returns USD add /USD/GBP to give AAPL/USD/GBP and the value in the CSV file will be in pounds. Again, I am hopping the developer will add this feature to the QIF file. This works for other currency conversions e.g. EURGBP
Hope this helps
10 Posted by Ed on 29 Dec, 2017 05:57 PM
Thanks again, Derek, it certainly does! However, I'm not familiar with the Security Price Loader which lets you upload a CSV file; just the Security Price Entry extension which doesn't seem to do that. Can you point me to that tool?
11 Posted by derekkent23 on 29 Dec, 2017 08:11 PM
I am not support staff, just a user.
Hi, Ed
Take a look at this link https://bitbucket.org/mikerb/moneydance-2015/wiki/Extensions
When loading an extension from Mike under EXTENSION – MANAGE EXTENSION you will get a warning message, this can be safely ignored.
Hope this helps
12 Posted by derekkent23 on 01 Jan, 2018 11:23 AM
I am not support staff, just a user.
For anyone who is interested take a look at this thread on a third-party Quote and Exchange Rate Program from hleofxquotes.
http://help.infinitekind.com/discussions/investments/3036-third-par...
Hope this helps.
System closed this discussion on 02 Apr, 2018 11:30 AM.