Stock spreadsheet 
This spreadsheet imports 8 tables of financial data about a given stock into one worksheet and uses functions to calculate value investing criteria.
Tech: Excel VBA
Go back to all projects 
Lessons learned:
- Pulling data from the web into excel using VBA.
- Type checking and correcting numbers to the correct decimals.
- Figuring out how to work with 1000 lines of excel data.
- Some python data pulling, which went on unused.
Description:
This was my summer 2023 project that involved taking lots of table data from a Stock analysis website, importing the data into excel and then converting the numbers so the digits are correct.
It is a merger of the skills from both of my universities, but the economics themselves aren't that complicated. They take known formulas and calculate the intrinsic stock value, which is then compared with the actual stock value.
The main struggle was 1) getting correct data and 2) converting the data into correct numbers, which involved writing complicated IF formulas to check if the number has a comma, or dot inside it (dot is used for thousands, comma is used for decimals).