Read the statement by Michael Teeuw here.
MMM-AVStock returning empty values
-
Hi,
I use MMM-AVStock to display my portfolios stock and ETF price changes. I look up the symbols on AlphaVantage and so far everything has worked fine.
But now, some fields stay empty for days, though a direct call returns valid price information.Example: 6AQQ.DEX
{ "Meta Data": { "1. Information": "Intraday (5min) open, high, low, close prices and volume", "2. Symbol": "6aqq.dex", "3. Last Refreshed": "2020-02-21 07:10:00", "4. Interval": "5min", "5. Output Size": "Compact", "6. Time Zone": "US/Eastern" }, "Time Series (5min)": { "2020-02-21 07:10:00": { "1. open": "98.2600", "2. high": "98.2600", "3. low": "98.2600", "4. close": "98.2600", "5. volume": "0" }, "2020-02-21 06:55:00": { "1. open": "98.2200", "2. high": "98.2200", "3. low": "98.2200", "4. close": "98.2200", "5. volume": "10" }, "2020-02-21 06:15:00": { "1. open": "98.1800", "2. high": "98.1800", "3. low": "98.1800", "4. close": "98.1800", "5. volume": "31" }, "2020-02-21 06:05:00": { "1. open": "98.2800", "2. high": "98.2800", "3. low": "98.2800", "4. close": "98.2800", "5. volume": "200" }, "2020-02-21 05:50:00": { "1. open": "98.2400", "2. high": "98.2400", "3. low": "98.2400", "4. close": "98.2400", "5. volume": "100" }, "2020-02-21 04:30:00": { "1. open": "98.0200", "2. high": "98.0200", "3. low": "97.9700", "4. close": "97.9700", "5. volume": "1350" }, "2020-02-21 04:15:00": { "1. open": "98.0400", "2. high": "98.0500", "3. low": "98.0300", "4. close": "98.0500", "5. volume": "448" }, "2020-02-21 04:10:00": { "1. open": "98.0700", "2. high": "98.0700", "3. low": "98.0300", "4. close": "98.0300", "5. volume": "145" }, "2020-02-21 03:55:00": { "1. open": "97.9700", "2. high": "97.9700", "3. low": "97.9700", "4. close": "97.9700", "5. volume": "58" }, "2020-02-21 03:50:00": { "1. open": "98.0500", "2. high": "98.0500", "3. low": "98.0300", "4. close": "98.0300", "5. volume": "80" }, "2020-02-21 03:35:00": { "1. open": "98.2200", "2. high": "98.2200", "3. low": "98.2200", "4. close": "98.2200", "5. volume": "102" }, "2020-02-21 03:25:00": { "1. open": "97.9800", "2. high": "97.9800", "3. low": "97.9800", "4. close": "97.9800", "5. volume": "106" }, "2020-02-21 03:05:00": { "1. open": "97.9800", "2. high": "97.9800", "3. low": "97.9800", "4. close": "97.9800", "5. volume": "28" }, "2020-02-21 03:00:00": { "1. open": "98.0100", "2. high": "98.0100", "3. low": "98.0100", "4. close": "98.0100", "5. volume": "0" }, "2020-02-20 11:25:00": { "1. open": "98.8900", "2. high": "98.8900", "3. low": "98.8900", "4. close": "98.8900", "5. volume": "1033" }, "2020-02-20 11:15:00": { "1. open": "98.8700", "2. high": "98.8700", "3. low": "98.8700", "4. close": "98.8700", "5. volume": "50" }, "2020-02-20 11:10:00": { "1. open": "99.3300", "2. high": "99.3300", "3. low": "99.2900", "4. close": "99.2900", "5. volume": "58" }, "2020-02-20 11:00:00": { "1. open": "99.4000", "2. high": "99.4000", "3. low": "99.4000", "4. close": "99.4000", "5. volume": "45" }, "2020-02-20 10:45:00": { "1. open": "99.6300", "2. high": "99.6500", "3. low": "99.6300", "4. close": "99.6500", "5. volume": "101" }, "2020-02-20 10:25:00": { "1. open": "99.4100", "2. high": "99.4100", "3. low": "99.4100", "4. close": "99.4100", "5. volume": "146" }, "2020-02-20 09:35:00": { "1. open": "99.4300", "2. high": "99.4300", "3. low": "99.3700", "4. close": "99.3700", "5. volume": "133" }, "2020-02-20 09:30:00": { "1. open": "99.4600", "2. high": "99.4600", "3. low": "99.4600", "4. close": "99.4600", "5. volume": "140" }, "2020-02-20 08:50:00": { "1. open": "99.5000", "2. high": "99.5000", "3. low": "99.4200", "4. close": "99.4300", "5. volume": "1286" }, "2020-02-20 08:45:00": { "1. open": "99.5300", "2. high": "99.5300", "3. low": "99.5200", "4. close": "99.5200", "5. volume": "780" }, "2020-02-20 08:25:00": { "1. open": "99.6900", "2. high": "99.6900", "3. low": "99.6500", "4. close": "99.6500", "5. volume": "97" }, "2020-02-20 08:10:00": { "1. open": "99.7900", "2. high": "99.7900", "3. low": "99.7700", "4. close": "99.7700", "5. volume": "25" }, "2020-02-20 07:50:00": { "1. open": "99.6800", "2. high": "99.6800", "3. low": "99.6800", "4. close": "99.6800", "5. volume": "105" }, "2020-02-20 07:25:00": { "1. open": "99.6300", "2. high": "99.6300", "3. low": "99.6300", "4. close": "99.6300", "5. volume": "45" }, "2020-02-20 07:20:00": { "1. open": "99.6600", "2. high": "99.6600", "3. low": "99.6600", "4. close": "99.6600", "5. volume": "10" }, "2020-02-20 07:15:00": { "1. open": "99.6800", "2. high": "99.6800", "3. low": "99.6800", "4. close": "99.6800", "5. volume": "2843" }, "2020-02-20 07:10:00": { "1. open": "99.6900", "2. high": "99.6900", "3. low": "99.6900", "4. close": "99.6900", "5. volume": "0" }, "2020-02-20 05:45:00": { "1. open": "99.7200", "2. high": "99.7200", "3. low": "99.7200", "4. close": "99.7200", "5. volume": "488" }, "2020-02-20 05:25:00": { "1. open": "99.7700", "2. high": "99.7700", "3. low": "99.7700", "4. close": "99.7700", "5. volume": "40" }, "2020-02-20 04:40:00": { "1. open": "99.7100", "2. high": "99.7100", "3. low": "99.7100", "4. close": "99.7100", "5. volume": "1000" }, "2020-02-20 04:20:00": { "1. open": "99.6400", "2. high": "99.6400", "3. low": "99.6400", "4. close": "99.6400", "5. volume": "57" }, "2020-02-20 04:15:00": { "1. open": "99.7300", "2. high": "99.7300", "3. low": "99.7300", "4. close": "99.7300", "5. volume": "100" }, "2020-02-20 03:50:00": { "1. open": "99.7300", "2. high": "99.7300", "3. low": "99.7300", "4. close": "99.7300", "5. volume": "543" }, "2020-02-20 03:20:00": { "1. open": "99.7000", "2. high": "99.7000", "3. low": "99.7000", "4. close": "99.7000", "5. volume": "250" }, "2020-02-20 03:05:00": { "1. open": "99.8700", "2. high": "99.8700", "3. low": "99.8700", "4. close": "99.8700", "5. volume": "27" }, "2020-02-20 03:00:00": { "1. open": "99.9000", "2. high": "99.9000", "3. low": "99.9000", "4. close": "99.9000", "5. volume": "0" }, "2020-02-19 11:25:00": { "1. open": "99.8600", "2. high": "99.8600", "3. low": "99.8600", "4. close": "99.8600", "5. volume": "400" }, "2020-02-19 11:10:00": { "1. open": "99.9100", "2. high": "99.9100", "3. low": "99.9100", "4. close": "99.9100", "5. volume": "58" }, "2020-02-19 11:05:00": { "1. open": "99.9300", "2. high": "99.9300", "3. low": "99.9300", "4. close": "99.9300", "5. volume": "10" }, "2020-02-19 10:35:00": { "1. open": "99.7800", "2. high": "99.7800", "3. low": "99.7800", "4. close": "99.7800", "5. volume": "14" }, "2020-02-19 10:25:00": { "1. open": "99.8400", "2. high": "99.8400", "3. low": "99.8400", "4. close": "99.8400", "5. volume": "485" }, "2020-02-19 09:35:00": { "1. open": "99.5700", "2. high": "99.6300", "3. low": "99.5700", "4. close": "99.6100", "5. volume": "87" }, "2020-02-19 09:30:00": { "1. open": "99.6000", "2. high": "99.6000", "3. low": "99.6000", "4. close": "99.6000", "5. volume": "501" }, "2020-02-19 08:30:00": { "1. open": "99.2900", "2. high": "99.2900", "3. low": "99.2900", "4. close": "99.2900", "5. volume": "3384" }, "2020-02-19 07:10:00": { "1. open": "99.2400", "2. high": "99.2400", "3. low": "99.2400", "4. close": "99.2400", "5. volume": "0" }, "2020-02-19 06:50:00": { "1. open": "99.2500", "2. high": "99.2500", "3. low": "99.2500", "4. close": "99.2500", "5. volume": "20" }, "2020-02-19 06:20:00": { "1. open": "99.2200", "2. high": "99.2200", "3. low": "99.2200", "4. close": "99.2200", "5. volume": "6" }, "2020-02-19 05:45:00": { "1. open": "99.1600", "2. high": "99.1600", "3. low": "99.1300", "4. close": "99.1300", "5. volume": "969" }, "2020-02-19 05:35:00": { "1. open": "99.1800", "2. high": "99.1800", "3. low": "99.1800", "4. close": "99.1800", "5. volume": "6" }, "2020-02-19 05:25:00": { "1. open": "99.1800", "2. high": "99.1800", "3. low": "99.1800", "4. close": "99.1800", "5. volume": "40" }, "2020-02-19 05:05:00": { "1. open": "99.1000", "2. high": "99.1000", "3. low": "99.1000", "4. close": "99.1000", "5. volume": "13" }, "2020-02-19 04:40:00": { "1. open": "99.1300", "2. high": "99.1300", "3. low": "99.1300", "4. close": "99.1300", "5. volume": "991" }, "2020-02-19 04:10:00": { "1. open": "99.1400", "2. high": "99.1400", "3. low": "99.0700", "4. close": "99.0700", "5. volume": "58" }, "2020-02-19 04:05:00": { "1. open": "99.0500", "2. high": "99.0500", "3. low": "99.0500", "4. close": "99.0500", "5. volume": "313" }, "2020-02-19 04:00:00": { "1. open": "99.0300", "2. high": "99.0300", "3. low": "99.0300", "4. close": "99.0300", "5. volume": "248" }, "2020-02-19 03:55:00": { "1. open": "99.0300", "2. high": "99.0300", "3. low": "99.0300", "4. close": "99.0300", "5. volume": "58" }, "2020-02-19 03:50:00": { "1. open": "98.9900", "2. high": "98.9900", "3. low": "98.9900", "4. close": "98.9900", "5. volume": "29" }, "2020-02-19 03:40:00": { "1. open": "99.0700", "2. high": "99.0700", "3. low": "99.0700", "4. close": "99.0700", "5. volume": "29" }, "2020-02-19 03:30:00": { "1. open": "99.0000", "2. high": "99.0000", "3. low": "99.0000", "4. close": "99.0000", "5. volume": "13" }, "2020-02-19 03:20:00": { "1. open": "99.0100", "2. high": "99.0100", "3. low": "99.0100", "4. close": "99.0100", "5. volume": "1" }, "2020-02-19 03:15:00": { "1. open": "99.0500", "2. high": "99.0500", "3. low": "99.0500", "4. close": "99.0500", "5. volume": "15" }, "2020-02-19 03:00:00": { "1. open": "99.1500", "2. high": "99.1500", "3. low": "99.1500", "4. close": "99.1500", "5. volume": "56" }, cropped...
Any ideas on this?
-
@requiemmg said in MMM-AVStock returning empty values:
the code uses that call, without the interval=5min value…
-
…which gives me
"Thank you for using Alpha Vantage! Our standard API call frequency is 5 calls per minute and 500 calls per day. Please visit https://www.alphavantage.co/premium/ if you would like to target a higher API call frequency."
What it would also do with all other values. But these work! Only 6AQQ.FRK results in not being shown and I have no Idea why. (also all other markets for 6AQQ)
Any ideas?
-
@requiemmg the API returns no data when u exceed the call limit. U just have to wait
-
@sdetweil I’ve been waiting for this until this moment.
-
@brindlednearly I don’t understand your message
i consider this api one of the lazy/sloppy kind
there is a documented error code that can be used
but they return 200 (good), but have bad data…