Does anyone know of a publicly available dataset for S&P500 index published daily in json format?
Took a look at quandl but nothing for free. Google searches bring back a whole host of unhelpful sponsored ads, old data or monthly publications.
$\begingroup$
$\endgroup$
2
-
$\begingroup$ Why not just pull it down in csv and parse into JSON? $\endgroup$– KchCommented Jan 1, 2018 at 21:10
-
$\begingroup$ Trying to keep things efficient - think thats gonna be the way forward. Or the S&P ETF prices in Json.. $\endgroup$– DVCITISCommented Jan 1, 2018 at 21:12
Add a comment
|
1 Answer
$\begingroup$
$\endgroup$
3
try the Bloomberg API: https://www.bloomberg.com/markets/chart/data/1D/SPX:IND
I hope it's what you're looking for.
-
1$\begingroup$ This looks close! I'm looking for the last year of close values though. How did you navigate to the API - I find the SPX:IND quote at the below link and don't see the option? bloomberg.com/quote/SPX:IND $\endgroup$– DVCITISCommented Jan 2, 2018 at 20:59
-
$\begingroup$ You can find the logic behind this explained here: github.com/matthewfieger/bloomberg_stock_data $\endgroup$ Commented Jan 7, 2018 at 19:30
-
$\begingroup$ Sadly it appears Bloomberg blocks traffic to this endpoint from AWS ip addresses. I have not found a good alternative for scripts running there. $\endgroup$ Commented Apr 23, 2019 at 3:34