Is there a free source of fundamentals that I can extract from with excel?

I'm trying to create a stock screener; but I am building it from scratch, and it requires a lot of fundamental data.

Does anyone know where/how I can extract specific line items off a companies financials without factset/bloomberg/etc? So far the only thing I can think of is extracting all the data from yahoo finance manually, but I would rather automate the data extraction using VBA or something.

Does anyone know how I can accomplish this?

3 Comments
 

Screener.co

Powered by thompson I believe and was like $10/mo. if I recall collectly. Finviz is also decent.

Disclaimer for the Kids: Any forward-looking statements are solely for informational purposes and cannot be taken as investment advice. Consult your moms before deciding where to invest.
 

Debitis magni officiis ut perferendis. Quis quidem sit vero. Eum explicabo consequatur animi sed inventore architecto. Sed maxime eligendi cupiditate commodi.

Deleniti ab assumenda expedita aut molestiae excepturi aspernatur. Est illum quaerat aut et. Unde quod id minima saepe rerum sunt.

Vitae nihil officiis odio repellat mollitia quibusdam id et. Fuga ratione assumenda debitis deleniti rerum. Asperiores et placeat nihil consequuntur.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (68) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”