How do I grab stock market data and get it to fill a spread sheet for doing calculations on that data?
Can it be done with any open source software? Could I use Excell or do I need an API.?
>>2922787
Yes it's actually ez, you start by putting ALL the data in your spreadsheet and then you use SUM(x1,x2,...), and there it is: your annual return. Good job OP
Use python to read an XML file you get from quandl.com
>doing calculations
It sounds like you have no fucking idea about quantitative analysis, so maybe read up on it before starting to analyze the data.
>>2922787
I did this by using an internet query in excel, then scanning the html document for the word for the metric I want then taking the next element in the table. I did this for everything in the income statement, balance sheet and cash flow statement. Then I just basically used cell formulas to make calculations using that data
>>2922787
>Could I use Excell or do I need an API
how old are you anyway?
>>2923653
I'm this many.
I'm talking about pulling the data from something like yahoo finance. I'm not going to input every stock from Nasdaq and US by hand.
>>2923737
Python then.
If you know how to program then this is pretty easy to do in python using something like beautifulsoup
>>2922898
Thanks for that link anon, that site looks awesome.
And yeah I know what QA is. I have my own little version of it I'd like to use and that's why I'd like to start learning to pull the data of the entire US and Nasdaq exchanges in. I want to run those formulas against all the stocks on the two markets to narrow down what looks promising. I want to do it on my own so I don't need to pay a website to do it for me.
>>2923748
I can program to an extent, but never used python. Only C# scripting with Unity. I have used Cobol, Fortran, Basic, VB, and a few other shit tier languages so I could probably figure it out eventually. I'm not a "programmer" though.
A Tutorial from Youtube would be great too, or I could do the old copy and paste someone else's then modify it for myself.