Import from file stopped working
Since Moneydance can no longer update security prices using the Download Quotes and Exchange Rates extension, I have been downloading daily prices and saving them to .csv file which I then import into price history. This has been working fine except for the past week or two. When I try to import from a file, I receive a message the the import completed but had "x" number of errors and the prices are not included in the security's price history. Looking at the error log I find the following item: "Import error: discarding currency snapshot with zero date: 2/26/2018,10.24,10.24,10.24,10.24,10.24,0" The date looks correct as does the price information, so why all of a sudden did this stop working?
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 derekkent23 on 10 Mar, 2018 09:50 AM
I am not support staff, just a user.
You don’t state which version or build of Moneydance you are running, see under HELP – ABOUT MONEYDANC, e.g. 2017.6(1656)
The latest build of 2017 can download quotes using the Q & ER extension v1015 from Alpha Vantage.
If you are running 2017 and purchased direct have you tried updating from https://infinitekind.com/download-moneydance-personal-finance-software
If Alpha Vantage is not returning any or all of your quotes there is an alternative.
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.
http://help.infinitekind.com/discussions/investments/3036-third-par...
Hope this helps.
2 Posted by dwg on 10 Mar, 2018 10:05 AM
I would suggest opening the CSV file in a text editor and/or a spreadsheet program and look at the structure just in case something has changed, if a CSV file is not of a consistent format you can get problems, even something as simple as an extra line with just a carriage return on it can throw it out.
Word processors are very good for detecting problems like this as you can turn field marks on, and spreadsheets as they can process CSV files, can help you to check that the table structure is correct
3 Posted by charles.cross2 on 11 Mar, 2018 11:24 PM
Thanks derekkent23 and dwg. I updated the Quotes and Exchange rate extension to use Alpha Vantage and now my security prices are once again being updated via the extension rather than having to import from a csv file.
System closed this discussion on 10 Jun, 2018 11:30 PM.