It takes me 96 mouse clicks to update stock prices...

Chris's Avatar

Chris

03 Aug, 2019 10:26 AM

Admittedly it's partly my fault for having 12 active securities. For each one, to import prices from a .csv file takes 8 mouse clicks. (Actually more if I have to scroll down when viewing the list of .csv files in my downloads directory.)

Importing from csv files is the only way I have of getting prices (including historical prices) into Moneydance. The official loader extension apparently doesn't work for UK shares. (For example, on testing it returns random numbers for Vanguard ETFs, that don't correspond to the prices in any currency I can think of.)

Can there be an easier way to import data? If I could record a fixed file name in the profile of each security from which data would be automatically imported on start-up, that would be wonderful.

Alternatively, if I could invoke Moneydance in batch with a command-line instruction to update a securities price history from a specified file, I could get the daily job that creates the .csv files to do the import.

  1. 1 Posted by derekkent23 on 03 Aug, 2019 12:21 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Have you tried the free third-party Quote Loader it supports most UK stocks and funds?
    As a UK investor it’s what I use.

    If you want to try Quote Loader see post 205 at https://infinitekind.tenderapp.com/discussions/investments/4039-quo...

    Download the PDF attached to post 205 and have a read.
    To get an overview take a look at the YouTube video by using the link on page one of the PDF.

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

    Hope this helps.

  2. 2 Posted by Chris on 03 Aug, 2019 03:55 PM

    Chris's Avatar

    I've looked at it previously, I think the most immediate issue is that it only gets current prices for securities. I already see those in my investment spreadsheet, I don't particularly need them in Moneydance. What I want in Moneydance is a daily price history. At the moment I randomly import data somewhere between every two weeks and every two months, so if I only imported the most recent quotes each time I'd get very variable time-periods between quotes in the resulting history.

  3. System closed this discussion on 02 Nov, 2019 04:00 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