-
-
Notifications
You must be signed in to change notification settings - Fork 2
Yahoo Finance Quote Sources
If the source parameter is omitted or the source parameter below is supplied, then msmquote will update quote data using a list of security and currency pair symbols generated automatically from your Money file.
https://query1.finance.yahoo.com/v7/finance/quote?symbols=
To display a list of the symbols generated from your Money file without updating any quote data, simply append a ? to the source parameter as follows:
https://query1.finance.yahoo.com/v7/finance/quote?symbols=?
Where a symbol is found in your Money file that is not in the Yahoo Finance format, msmquote will attempt to generate its Yahoo Finance equivalent based on the Money symbol and its associated Country/Region value.
Examples:
| Money symbol | Country/Region | Generated symbol |
|---|---|---|
| TSCO | United Kingdom | TSCO.L |
| FR:CA | France | CA.PA |
| CA | France | CA.PA |
| US:WMT | United States | WMT |
| WMT | United States | WMT |
The symbol itself in your Money file will remain unchanged.
When using an auto-generated URL you may wish to limit which securities and exchange rates are updated; details of how to achieve this are provided here.
You can define your own list of security and currency exchange rate symbols to update after the symbols= statement in the source parameter.
For example, the following source parameter will update quota data for Walmart Inc., Tesco PLC, Carrefour SA, the FTSE-100 index and the Pound Sterling/Euro exchange rate:
https://query1.finance.yahoo.com/v7/finance/quote?symbols=WMT,TSCO.L,CA.PA,^FTSE,GBPEUR=X
Replace the symbols after the symbols= statement with those for the securities and currency exchange rates in your Money file that you wish to update. It should be possible to include any symbol for which quote data is available on Yahoo Finance. The symbols must match those defined in your Money file.
The Yahoo Finance API understands currency exchange rate symbols in the format FOOBAR=X, where FOO and BAR are the ISO codes of the currencies for which you wish to update the exchange rate. FOO should typically be set to the ISO code of the base currency in your Microsoft Money currency table.
For example, if your base currency is the Euro then you would use the symbol EURCHF=X to obtain the exchange rate for Swiss Francs to the Euro.
Update historical quote data for a single security with data retrieved from the Yahoo Finance API. For example, the following source parameter will update one month's worth of quote data for Tesco PLC (symbol TSCO.L):
https://query1.finance.yahoo.com/v7/finance/chart/TSCO.L?range=1mo&interval=1d&indicators=quote&includeTimestamps=true
The range= parameter in the URL for the historical data API controls the date range of the quote data to be retrieved for the given symbol. It takes one of the following arguments: 1d, 5d, 1mo, 3mo, 6mo, 1y, 2y, 5y, 10y, ytd, or max.
Update historical quote data for a single security using a CSV file generated by the Yahoo Finance historical prices download facility. The CSV filename must be in the format "symbol currency quotetype.csv", where:
-
symbolmatches the symbol in your Money file that you wish to update -
currencyis the three-character Yahoo Finance currency code of the quote data, for exampleGBp -
quotetypeis the quote type, currently one ofEQUITY,ETF,BOND,INDEXorMUTUALFUND.
For example, the following source parameter will update quote data for Tesco PLC (symbol TSCO.L) from a CSV file containing quote values in British pence:
"TSCO.L GBp EQUITY.csv"