2
$\begingroup$

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.

$\endgroup$
2
  • $\begingroup$ Why not just pull it down in csv and parse into JSON? $\endgroup$
    – Kch
    Jan 1 '18 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$
    – DVCITIS
    Jan 1 '18 at 21:12
2
$\begingroup$

try the Bloomberg API: https://www.bloomberg.com/markets/chart/data/1D/SPX:IND

I hope it's what you're looking for.

$\endgroup$
3
  • 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$
    – DVCITIS
    Jan 2 '18 at 20:59
  • $\begingroup$ You can find the logic behind this explained here: github.com/matthewfieger/bloomberg_stock_data $\endgroup$ Jan 7 '18 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$ Apr 23 '19 at 3:34

This site is temporarily in read only mode and not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .