anyone know how to pull stock price data for top 300 stocks in s+p 500?

[Christopher lee]

anyone know how to pull stock price data for top 300 stocks in s+p 500?i'm going to use excel or matlab but don't know how to pull the data all at once. thanks!

 

[Varun Dubey]

This is one way: (You'll have to write a small piece of code)

Curl request to the website
CSS selectors + regex to scrape rates and names (n times)
write to Excel/csv

You can write this in JS, C++, Python, etc...

 

[Le Van]

There's a Matlab function called hist_stock_data, which can be found at Matlab File Exchange.

price = hist_stock_data('ddmmyyyy','ddmmyyyy','^gspc');

You can do the same in R, with the help of the package quantmod

require('quantmod')
getSymbols('^GSPC', from='yyyy-mm-dd', to='yyyy-mm-dd')

 

[Christopher lee]

i don't know how to pull the data for each individual stock all at once so that i could run that function haha. do you have any advice?

 

[Le Van]

i don't know how to pull the data for each individual stock all at once so that i could run that function haha. do you have any advice?

Don't know about Matlab but the following code works in R

x<-c('MMM','ABT','ABBV','ACN','ACE')
getSymbols(x, from='2015-11-01')


i.e. all you need is the ticker symbols of the stocks, then put them into a (character) vector and pass it to getSymbols.

 

[Ken Abbott]

Do you have access to a Bloomberg terminal? I did this for the S&P 100 once (many years ago) and once I had the symbols, it was easy.

 

[Berk Torun]

Download the list of symbols from the link below to Excel. Export the data to MATLAB and build a string vector.
https://en.wikipedia.org/wiki/List_of_S&P_500_companies

Then write a loop with the following
fetch(yahoo, '[Company Ticker]', 'Close', '[Beginning Date]', '[End Date]')