Stock price problems due to currency problems

emiddleton's Avatar

emiddleton

06 Dec, 2017 12:29 AM

The attached jpg shows the end of day data for today's download for US ETF VWO. With all the US ETF's or stocks that I download the case is the same..... the historical data section shows all the correct data. The current price is not correct and should be the same as the end of day data. The problem occurs is that the MD software uses the current price for all displays and calculations which means everything is off.

Any suggestions as to why these are incorrect? Base currency for my file is $CDN and these items are all in $US. The exchange rate is also downloaded and is correct at approx. 1.27.

Showing page 2 out of 2. View the first page

  1. 31 Posted by emiddleton on 13 Dec, 2017 07:56 PM

    emiddleton's Avatar

    Sean, just read something on the board that Keith mentioned to go to.

    "I believe that the issue is related to a part of the code in the extension that will not update the current price of a security with the downloaded value if it the current price has been set manually with a more recent timestamp. Because of how the Currency/Security History window works, simply displaying and closing that window might cause moneydance to think that you updated the price manually."

    Whenever I download I always get a new current price for the exchange rate regardless of whether I opened the window that day or not. As far as the US securities, they all get the last historical price updated as well but the current price for the securities changes each time as well.

    When I download after the markets are closed, the security prices for that day (in the historical part) remain the same but the current price for the security changes through the evening as the exchange rate changes on each download.

    Am I missing something here?

  2. 32 Posted by emiddleton on 14 Dec, 2017 04:48 PM

    emiddleton's Avatar

    Again I offer to send my test file to you. I've tried to attach it to a message but the system won't take it. It is quite a small file. If you can tell me how to send it and whether you want the backup file or the exported qif file that would help.

  3. 33 Posted by sth on 14 Dec, 2017 05:30 PM

    sth's Avatar

    Ed, Since the file is a "bundle" of files in a directory, you need to zip it into a single compressed file to attach it. You can right click on it in the finder and select "compress" which will make a zip file.

    As another suggestion, unless you already tried this is to try v1012 as a alpha test which tries to make the currency updates happen first.
    https://infinitekind.com/tmp/yahooqt.mxt
    Use the Extensions manager -> load extension from file

    You can revert to the standard v1009 by removing the extension and then reinstalling normally.
    -Scott

  4. 34 Posted by emiddleton on 14 Dec, 2017 07:02 PM

    emiddleton's Avatar

    Did try v1012 and it did not work. Here's a zip file that I've been testing with.

  5. 35 Posted by emiddleton on 14 Dec, 2017 07:08 PM

    emiddleton's Avatar

    If you get the file into MD, try the following:

    1. Download stock prices only. Notice that the historical price from today for VWO equals the current price for VWO, which obviously it should.
    2. Download again with both stock a exhcange rates. When you look at VWO after the download the historical price will be right but...the current price will be off.
    3. Take the last historical price for VWO and multiply it by the last historical price for exchange rate then divide by the current exchange rate. The answer will be what is being displayed on the summary page. That value is not the current price.

  6. 36 Posted by sth on 15 Dec, 2017 03:24 AM

    sth's Avatar

    I got the file and it uncompressed fine. DOn't have time tonight to mess with it.

  7. 37 Posted by emiddleton on 17 Dec, 2017 03:38 AM

    emiddleton's Avatar

    Any luck Scott? Just want to make sure that someone else is seeing this problem and that it is not something with my computer or setup. Maybe you can explain it in a different way that might help Sean out a bit more.

  8. 38 Posted by sth on 17 Dec, 2017 04:47 PM

    sth's Avatar

    Ok, it is a bit more confused than that. I am not sure about the behavior.

    When I open the file, the Q&ER is set to update both stock and exchange rates. Deleting the exchange rates and security quotes back to 12/7 and then updating just the security quotes gives me an inconsistency between last quote and current quote. BUT I have opened the history and thus locked in the date of the current quote as newer.

  9. 39 Posted by sth on 17 Dec, 2017 04:52 PM

    sth's Avatar

    If I just restore from that backup file each time it downloads quotes and exchange rates and the current value is the same as the most recent quote.

  10. 40 Posted by emiddleton on 17 Dec, 2017 10:28 PM

    emiddleton's Avatar

    Oh yeah, you'll have to wait for when the exchange rate is active which is already happening as of around 5 pm. If you download the exchange rate will change and the price of the US security will change even though the US market is not open till 9:30 am on Monday.

  11. 41 Posted by sth on 18 Dec, 2017 12:20 AM

    sth's Avatar

    I started again from the downloaded file since I had too many test files wandering around. It did an update for both and thus seems to be correct. I have turned off auto updating and and saved that test file. We will see what happens

  12. 42 Posted by emiddleton on 18 Dec, 2017 12:48 AM

    emiddleton's Avatar

    Did you check that the current price for VWO is correct? The historical price for Friday was 44.43. The current price should also be the same.

    So after a download the current and historical prices for the Exchange rate are the same? I never get that.

  13. 43 Posted by sth on 18 Dec, 2017 01:25 AM

    sth's Avatar

    As I said, they updated simultaneously. I will try tomorrow evening and update the stocks and then the currencies. But at the moment I get the following security prices:

  14. 44 Posted by emiddleton on 18 Dec, 2017 02:10 AM

    emiddleton's Avatar

    The currency rates are now adjusting and I'm getting different values again. Let me know.

  15. 45 Posted by sth on 18 Dec, 2017 02:59 AM

    sth's Avatar

    Just updated currencies only. The stock values did not change and are still 44.43 for VWO. However the currency seems odd.
    The current value is 1.28645
    and the 12/17 value is 1.287562.
    The console log also shows an update to the USD value AND to VWO but I don't see it in the security history window:

    Currency Name raw rate user rate
    xic 3.918495297805643 0.03918495297805643
    US Dollar 0.777332970577947 0.777332970577947
    vwo 1.7495677933332143 0.017495677933332145
    Canadian Dollar 1.0 1.0
    updating currency: US Dollar ()
    forex updated current: US Dollar

  16. 46 Posted by sth on 18 Dec, 2017 03:09 AM

    sth's Avatar

    If you check what is downloaded with this terminal command (mac/linux)
    curl -s "https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE&a..."

    The currency exchange rate is a continuously changing rate. For the MD history value for the currency what should be the "daily" value? The first reading for the day? The last for that day?

    The physical currency does not get a daily closing value history like securities. Or even like crypto currencies. Just a realtime value.

    { "Realtime Currency Exchange Rate": { "1. From_Currency Code": "CAD", "2. From_Currency Name": "Canadian Dollar", "3. To_Currency Code": "USD", "4. To_Currency Name": "United States Dollar", "5. Exchange Rate": "0.77735231", "6. Last Refreshed": "2017-12-18 03:08:41", "7. Time Zone": "UTC" } }

  17. 47 Posted by emiddleton on 18 Dec, 2017 02:16 PM

    emiddleton's Avatar

    STH,

    So you are seeing the same thing. Next time you update the securities you will notice a difference in the prices.

  18. 48 Posted by emiddleton on 18 Dec, 2017 02:24 PM

    emiddleton's Avatar

    What I did find that works and that maybe could be incorporated into the program is to clear the historical data from the currencies before downloading the new currencies and stock prices.

    As the historical prices are not provided by Alphavantage anyways then that would clear everything up.

  19. 49 Posted by sth on 18 Dec, 2017 04:52 PM

    sth's Avatar

    MD probably doesn't want to clear the historical data for a variety of reasons. But that is a help. I am not sure I am seeing the same things as you are.

    But after VXO posts an update today, I will download the securities only and then download the currencies only and see if that messes up the current value.

    One bug I reported was that if you change the settings to "do not update" the settings do not stick unless you ask for an update before closing the Q&ER extension window.

  20. 50 Posted by emiddleton on 18 Dec, 2017 06:35 PM

    emiddleton's Avatar

    STH,

    You can update anytime during the day VWO trades all day long. It's an ETF.

  21. 51 Posted by sth on 18 Dec, 2017 09:30 PM

    sth's Avatar

    Got it. Yes I see it! That is weird. i updated the securities only and not the exchange rates. I got an update to the old price from 44.43 to 44.89 in the security history and the current price went to 44.9288. I have no idea where the 44.9288 price came from. That is more digits than the price from AlphaVantage.

    I attached a screen shot of the history window and here is the download from AlphaVantage which is the raw data MD is working with. This is a few minutes later so the current price has changed some and it is 44.76 instead of 44.89 but since the daily

    I did not have to update the securities price to see it change.

    timestamp,open,high,low,close,volume
    2017-12-18,44.7600,45.0300,44.7500,44.8900,10117152
    2017-12-15,44.4300,44.5200,44.2150,44.4300,12428085
    2017-12-14,44.4800,44.6200,44.3100,44.3100,8231035
    2017-12-13,44.3800,44.7500,44.3200,44.5900,9287186

  22. 52 Posted by sth on 18 Dec, 2017 09:34 PM

    sth's Avatar

    If I update the the price again, it can download a new price as shown in the status bar at the bottom of the summary page, but the price on the summary page doesn't change.

    The price in the investment account and the price on the summary page still show 44.9288 and the price in the status bar shows 44.89, but the raw data now shows a new price that the extension is not updating.
    timestamp,open,high,low,close,volume
    2017-12-18,44.7600,45.0300,44.7500,44.8900,10117152
    2017-12-15,44.4300,44.5200,44.2150,44.4300,12428085
    2017-12-14,44.4800,44.6200,44.3100,44.3100,8231035

  23. 53 Posted by sth on 18 Dec, 2017 09:43 PM

    sth's Avatar

    I am attaching the Zip file if anyone else wants to test this:

  24. 54 Posted by emiddleton on 31 Dec, 2017 03:42 PM

    emiddleton's Avatar

    sth,
    Been away for the past week, still no solution that you've seen for the funky exchange rate problems?

    Ed

  25. 55 Posted by sth on 31 Dec, 2017 03:49 PM

    sth's Avatar

    I am just a user like you. All I can do is look at the preview change log:
    http://infinitekind.com/previewdl/current/changelog.txt

    I don't see any updates that might fix your currency problem.

  26. 56 Posted by emiddleton on 25 Feb, 2018 07:07 PM

    emiddleton's Avatar

    Still is happening.

  27. 57 Posted by emiddleton on 14 Mar, 2018 06:46 PM

    emiddleton's Avatar

    STH,

    Have you seen any movement in this problem? I can't be the only one with this problem!

  28. 58 Posted by derekkent23 on 14 Mar, 2018 07:08 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Did you try the latest preview build, there has been a number of bug fixes relating to currencies exchange rates. If you haven't worth a try. https://infinitekind.com/preview

    I have given up on the Q & ER extension. Only a small number of my securities were supported and on some that were I was getting inconstant data provided by Alpha Vantage.

    I am using a stand-alone program that was originally developed to help out users of MS Money when Microsoft stopped supporting that product. The program is in java, like Moneydance and thus runs on Windows, Mac and Linux computers. The developer has adapted it to work with Moneydance and is actively supporting the program. This program is very stable and the quotes very consistent with the option of two sources, not Alpha Vantage. No strange prices. It has a lot of useful features. These include, obtaining prices from many stocks and fund quoted on different exchanges, US, Canada, UK, Europe and Australia. I am a UK investor and have found that Alpha Vantage provide very poor support for UK/Irish/Luxenberg etc, domiciled funds. Alpha Vantage sometimes switches back and forward between Pence and Pounds. No such problem with the stand-alone program. The program has the ability to convert quotes from one currency to another. Convert prices in Pence to Pounds, if required, for UK stocks and funds. More features in the pipeline. Provide a means for importing all this data into Moneydance. You can also import exchange rates along with your security prices, if required.

    Take a look at his thread and download the PDF outlining how to use the program and link to download the program.
    see
    http://help.infinitekind.com/discussions/investments/3036-third-par...

    It should be used with the latest preview build of Moneydance as this fixes some exchange rate issues I was having.

    Hope this helps.

  29. System closed this discussion on 13 Jun, 2018 07:10 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

Recent Discussions

19 Aug, 2018 11:11 AM
19 Aug, 2018 10:22 AM
19 Aug, 2018 04:54 AM
19 Aug, 2018 02:03 AM
19 Aug, 2018 01:52 AM