Importing Historical Security Prices

dstephure's Avatar

dstephure

15 Mar, 2020 09:20 PM

As a Canadian MoneyDance for Macintosh user with US and CDN securities, I used to be able to import historical security prices by downloading a .csv file from"https://ca.finance.yahoo.com". A couple of years ago, MoneyDance users lost this functionality, presumably because of a dispute between Yahoo and Infinite Kind. Initially I thought this was the cause of the problem. However, I tried downloading the historical prices for a US stock from Nasdaq. The download of the .csv file lloks fine. Importing the data into MoneyDance appears fine. However, when you close the MoneyDance application and reopen it, the downloaded historical security prices have disappeared. So the problem is not restricted to importing (and saving) historical security price data from Yahoo Finance but also from other sources (e.g. Nasdaq). This seems to be a "bug" in the MoneyDance application. I have experienced the same problem with both the 2017.8 (1691) and the 2019.3 (1880) versions of MoneyDance. Has anyone else experienced a similar problem. More importantly, has anyone found a workaround?

  1. 1 Posted by derekkent23 on 16 Mar, 2020 08:08 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi dstephure

    Can you post one of your CSV files so others can test?

    You are probably aware there are two methods within Moneydance for obtaining security prices automatically.

    The extension “Quote and Exchange Rate Updater found under EXTENSIONS – MANAGE EXTENSIONS. Check you are running the latest build v1024. For exchange rates use the source European Central Bank. Alpha Vantage covers the US as well as some securities outside the US, but is very, very slow. It’s my understanding that the source IEX Trading no longer works.

    If the Quote and exchange rate updater does not work well for you try the extension Quote Loader under EXTENSIONS – MANAGE EXTENSION

    For information see post 9 at https://infinitekind.tenderapp.com/discussions/investments/4914-the...

    Download the PDF attached to posts 9 and have a read.

    To get an overview take a look at the YouTube videos by using the links on page 1 and 2 of the PDF.

    Let us know how you get on or if you need help just post.

    Hope this helps.

  2. 2 Posted by dstephure on 16 Mar, 2020 04:36 PM

    dstephure's Avatar

    Hi Derek ... Thanks for your help. I have been using Alpha Vantage on a weekly basis to update current security prices for securities that I own/want to follow. As you and others have said, it is TEDIOUSLY slow but it works for me. But I haven't found a way to use Alpha Vantage to obtain older historical security prices (for example from October 2009 to present). To do this, on a security by security basis, I would download the historical security data from Yahoo Finance Canada or Nasdaq and then import this using MoneyDance>Tools>Securities>Currency/Security History>Import. Initially the data appears looks like it has been imported correctly but after closing MoneyDance and then reopening the application, the data has disappeared. I have been using MoneyDance 2017.8 (1691) because when I tried using MoneyDance 2019.3 (1880), the security price data files were corrupted. As per your request, I tried to attached a CSCO.csv file but the ik site will not allow me to do so ... The site blocks attaching the .csv file. Not sure if you have another suggestion for getting the .csv file to you? Thanks for your help!

  3. 3 Posted by dstephure on 16 Mar, 2020 04:37 PM

    dstephure's Avatar

    I will try to upload the .csv file again.

  4. 4 Posted by dwg on 16 Mar, 2020 08:13 PM

    dwg's Avatar

    I'm a fellow user.

    I have imported your price history into the latest preview version of Moneydance 2019.4 (1904) without problem. I can exit and restart Moneydance and the data is there as expected. I know of no changes in this space since Build 1880 so would expect it to work the same.

    AlphaVantage is set so you get a few months of history only. Quote Loader will only bring in the current day.

  5. 5 Posted by dstephure on 16 Mar, 2020 08:27 PM

    dstephure's Avatar

    Interesting ... Are you working on a Microsoft version of MoneyDance or Mac? My PC is a MacBook Pro Early 2013 model running MacOS Mojave 10.14.6. Moving forward from here, if you were in my shoes, would you: Try to do a fresh install of MoneyDance 2017.8 (1691) or 2019.3 (1880). I can't think of anything else. Any other suggestions?

  6. 6 Posted by dstephure on 16 Mar, 2020 08:47 PM

    dstephure's Avatar

    Another thought ... Do you think Alpha Vantage or the Quotes and Exchange Rates Updater apps could be conflicting with importing old historical data using the process that I described above?

  7. 7 Posted by dwg on 16 Mar, 2020 09:09 PM

    dwg's Avatar

    I'm using Windows.

    I do not see any possibility of the Q&ER or Quote Loader extensions causing a problem here. I tried it on a test system that has both extensions installed.

    I'm skeptical about a fresh install of the software having any effect. What I would try is creating a new empty data set. Quickly setting up and investment account and the security and try importing the csv file into that and see what the result is. That may answer the question about it being a software problem at any rate and it may also give an indication of where to look next. I did see a couple of things in the CSV file that I thought the importer could object to, so I was a little surprised that it did import.

  8. 8 Posted by dstephure on 17 Mar, 2020 12:34 AM

    dstephure's Avatar

    Thanks for the suggestions Derek. I set up an new investment account, added a couple of securities (1 CDN - Royal Bank of Canada; 1 US - Cisco Systems) and imported the data after downloading the .csv files (RY from Yahoo Finance Canada; CSCO from Nasdaq). Importing the data into MoneyDance as described previously worked perfectly ... Until I quit MoneyDance. When I reopen MoneyDance, the imported data is no longer present. Wierd, eh? Any suggestions about what to try next? Thanks so much for trying to help.

  9. 9 Posted by dwg on 17 Mar, 2020 12:49 AM

    dwg's Avatar

    I meant create a completely new data set first (menu item File --> New), I'm not sure if you have done this. One of the objectives is to see if it could be something in your existing data set that is causing the issue. A new data set means existing software install but with no existing data.

  10. 10 Posted by dstephure on 17 Mar, 2020 01:47 AM

    dstephure's Avatar

    Derek, I followed your instructions as outlined in your post. Existing software instal but with no existing data. I imported the historical data for Royal Bank of Canada (RY.TO) from Yahoo Finance Canada and Cisco Systems (CSCO) from Nasdaq. Importing the data via the path Tools>Securities>Currency/Security History>Import>CSCO.csv. All of the imported data initially appear in the Currency/Security History Window ... until you close MoneyDance and then reopen the application. The imported data have disappeared. Exactly as I described previously. Sorry to be such a difficult "client".

  11. 11 Posted by dwg on 17 Mar, 2020 02:27 AM

    dwg's Avatar

    I'm about 14,000 miles from where Derek is :)

    Hmm interesting and unusual. You are running 2017 so yes I would think a re-installation is a reasonable step to take. What I would do is firstly deinstall Moneydance. Download a fresh copy from:

    https://infinitekind.com/download_2017

    Install it and see what happens, you are running an older copy of MD2017 so updating to the last release in this version is not a bad idea in any case.

    While I do not see how it could have an impact, but you do see some strange things at times, you could also try renaming your config.dict file. This is your Moneydance preferences file, so renaming it makes it look to Moneydance as if there is a fresh install and you can open your data set and see if the problem persists. You can rename the file back to its original name at a later stage.

  12. 12 Posted by dstephure on 17 Mar, 2020 03:55 AM

    dstephure's Avatar

    Hi dwg ... First, my apologies for referring to you incorrectly. Following your advice, I uninstalled all MoneyDance files on my MacBook Pro with the exception of my MoneyDance data file. Using the link imbedded in your post, I downloaded and installed a fresh copy of MoneyDance 2017.10 (1706). I reopened my MoneyDance datafile andI was able to upload and import the old historical security price data for RY.TO and for CSCO from Yahoo Finance Canada. After quitting the MoneyDance app and then reopening it, all of the imported data had been saved. Thank you so much for your patience, support and advice. You have eliminated one burr in my saddle. My sincere thanks. One final question: Now that we have finally solved this problem, can you think of any good reason why I should even consider upgrading the 2017.10 (1706) build to the 2019.3 (1880) build? David

  13. 13 Posted by dwg on 17 Mar, 2020 05:34 AM

    dwg's Avatar

    I'm fellow user.

    Glad to hear it is working.

    The changes between the 2017 and 2019 versions, so far, are more evolutionary rather than revolutionary. The compelling reasons for considering an upgrade today in my view are:

    1. There is a problem that MD2019 has the fix for e.g. fixes for some banks.
    2. You are concerned about data size. The 2019 version is more efficient.
    3. You intend upgrading to Catalina.
    4. You want to have dark mode to match that feature in recent Mac releases,

    Of the top of my head they are the highlights I can think of, there are a lot of little things.

  14. 14 Posted by derekkent23 on 17 Mar, 2020 08:55 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi dstephure

    Glad dwg got you sorted whilst I was asleep in my time zone.

    Have Fun.

  15. dstephure closed this discussion on 18 Mar, 2020 02:28 AM.

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