Stock Prices API

**Mike Wilson** · 10-27-2019, 07:08 PM

Does anyone have a good API for looking up stock prices that allows petitions for many stocks? I have this one (below), but it limits petitions to 5 per about 20 -30 seconds moments.

Code:

ALPHAVANTAGE:
	url = "https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol="+vsymbol+"&interval=1min&apikey=csv" 
	result=http_get_page2(url,.f.)

	vc_price_now=word(word(word(result,2,"Time Series"),6,chr(10)),2,chr(58))
	vc_price_now=alltrim(stritran(stritran(vc_price_now,chr(34),""),chr(44),""))
        vn_price_now=val(vc_price_now)

**mumfie** · 10-30-2019, 06:50 AM

does it need to be realtime? If not you could schedule the update in a series of batches over a period of time.

**Mike Wilson** · 11-04-2019, 08:59 PM

Yes, I have been trying that, a loop of 5 with a period of 3 min quiet then loop the next 5. For some reason, it doesn't work. It works if I do it manually, but for some very odd reason it does not work in a loop script.