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 free third-party Quote Loader. Both of the sources in the Quote Loader have good coverage of worldwide securities.
on 09 Dec, 2019 10:51 AM
thanks for the interesting idea which i have downloaded however i dont
SELECT, am i supposed to tick this, if i do it says this line doesn't
have a price which refers to lack of NEW PRICE also NEW PRICE doesnt
show for evry holding and if it does it seems a strange amount compared
to the A$ price in LAST PRICE
What is TRADE DATE
What is TRADE CURR as the Australian exchange are all in A$
Will these prices automatically appear in my Investments page where i
list all my holdings etc
PRAECO AU3CB fixed bond jul 2022 is a fixed rate bond and thus not quoted on Yahoo or FT. If you have found a price for this from another source you can edit to add this price and traded date as outlined in the PDF before saving selected values.
For ASX you need to change the ticker symbol from ASX.AX to ASX
Set up Quote Loader as the seen shot and it should work for you.
All the questions you have asked are covered in the PDF.
After clicking “ Get Prices” to select all the returned New Prices click “Click to Select all lines” then click “Save Selected Value” the Prices are entered into the relevant security price history windows within Moneydance.
As outlined in the PDF some ticker symbols are stock exchange specific. In these cases, if no exchange is selected it is normal to default to a main stock market e.g. ALG is the ticker for Alamo Group, Inc. a US traded company, thus it returns a US dollar price. Ardent Leisure Group Ltd has the same ticker symbol ALG but is traded on the Australian stock exchange, thus it requires the exchange to be selected to enable the correct price to be returned.
TRADED DATE defines the date to which the New Price relates.
TRADED CURRENCY defines the currency in which the security is quoted. Some user have securities that are quoted in a foreign currency, that is not the base currency.