Difference between revisions of "AlphaVantage Quote Source"
(Created page with "=== AlphaVantage Quote Source === As of the beginning of November, 2017, the Yahoo Finance APIs used below stopped working. See the blog. Because of this, PalOMoney was updat...") |
|||
| Line 7: | Line 7: | ||
Copy and paste 'AlphaVantage.CSV=AlphaVantage.CSV Section' into your PalOMoney.ini file at the <nowiki>[Quote Sources]</nowiki> section: | Copy and paste 'AlphaVantage.CSV=AlphaVantage.CSV Section' into your PalOMoney.ini file at the <nowiki>[Quote Sources]</nowiki> section: | ||
| − | <nowiki>[Quote Sources] | + | <nowiki>[Quote Sources] |
AlphaVantage.CSV=AlphaVantage.CSV Section | AlphaVantage.CSV=AlphaVantage.CSV Section | ||
Finance.Yahoo.CSV=Finance.Yahoo.CSV Section</nowiki> | Finance.Yahoo.CSV=Finance.Yahoo.CSV Section</nowiki> | ||
| Line 13: | Line 13: | ||
Then copy the entire section below, and substitute the API key you obtained from AlphaVantage. | Then copy the entire section below, and substitute the API key you obtained from AlphaVantage. | ||
| − | <nowiki>[AlphaVantage.CSV Section] | + | <nowiki>[AlphaVantage.CSV Section] |
Name=AlphaVantage.CSV | Name=AlphaVantage.CSV | ||
AddOn=(internal) | AddOn=(internal) | ||
| Line 25: | Line 25: | ||
Login ID=PutYourAPIKeyHere | Login ID=PutYourAPIKeyHere | ||
Password=</nowiki> | Password=</nowiki> | ||
| + | |||
| + | Then you should be good to go. Hit the update now button to test. Retrieving quotes takes longer than Yahoo Finance, and uses more bandwidth, because the AlphaVantage API returns at least 100 dates of data. This is a serious waste of your bandwidth and their processing, and hopefully we can request that they support returning only the most recent quote for single updates, instead of a 100 sample block of historical data. | ||
| + | |||
| + | Also some composite symbols are not supported, e.g., $INDU, $COMPX, $INX, etc. These return the message | ||
| + | "Error Message": "Invalid API call. Please retry or visit the documentation (https://www.alphavantage.co/documentation/) for TIME_SERIES_DAILY_ADJUSTED." | ||
| + | This also occurs for symbols that are no longer traded, e.g., WCOM, GTW, MCIT, and YHOO! | ||
Revision as of 23:13, 6 November 2017
AlphaVantage Quote Source
As of the beginning of November, 2017, the Yahoo Finance APIs used below stopped working. See the blog. Because of this, PalOMoney was updated to version 1.0.8, and MoneyPal was also updated to support the free AlphaVantage service. AlphaVantage.CSV has become the new default quote source.
The free Alpha Vantage service requires a free API key that you can immediately obtain from their web site. Anyone can instantly get this API key that works for all sorts of useful security and currency price time series. The quotes are supposedly real-time (not delayed), which is a plus.
Copy and paste 'AlphaVantage.CSV=AlphaVantage.CSV Section' into your PalOMoney.ini file at the [Quote Sources] section:
[Quote Sources] AlphaVantage.CSV=AlphaVantage.CSV Section Finance.Yahoo.CSV=Finance.Yahoo.CSV Section
Then copy the entire section below, and substitute the API key you obtained from AlphaVantage.
[AlphaVantage.CSV Section] Name=AlphaVantage.CSV AddOn=(internal) Output Format=0 Header Schema=1 Schema= URL Template= Real Time=1 Historical=1 Multiple Hist=0 Login ID=PutYourAPIKeyHere Password=
Then you should be good to go. Hit the update now button to test. Retrieving quotes takes longer than Yahoo Finance, and uses more bandwidth, because the AlphaVantage API returns at least 100 dates of data. This is a serious waste of your bandwidth and their processing, and hopefully we can request that they support returning only the most recent quote for single updates, instead of a 100 sample block of historical data.
Also some composite symbols are not supported, e.g., $INDU, $COMPX, $INX, etc. These return the message
"Error Message": "Invalid API call. Please retry or visit the documentation (https://www.alphavantage.co/documentation/) for TIME_SERIES_DAILY_ADJUSTED."
This also occurs for symbols that are no longer traded, e.g., WCOM, GTW, MCIT, and YHOO!
