I need to get into excel a spread sheet with multiple financial data entries on 150 stocks. The things I need are closing prices on certain dates, average p/e 2011-2015, average p/s 2011-2015, and more.
When I try to enter these directly into wolfram alpha it stops giving me a downloadable table after I input more than 4 or so stocks, so I have concluded that I need to use either a executable notebook or file on the development platform not sure which.
I have experimented with the FinancialData and come up with this code for my first data needed:
FinancialData["GE", "Close",{{2011,12,30},{2011,12,30}}]
However I cannot figure out how to input this for multiple stocks to be downloaded in an excel file. I have experimented a bit with the Export function but it just returns that my file has been created. Where do I go to download it?
I apologize that these questions are very elementary as programming is not my strong suit. If someone can give me the code to export a FinancialData value for all of my stocks to an excel file and how to use it I believe I can figure out how to alter the code for each different needed statistic.
It would save me hours of hand entry if someone can help me figure this out!
Thanks!