Today we will see how to import an Institution/fund manager stock information filed with SEC (https://www.sec.gov/) into Excel.

A fund manager is responsible for implementing a fund’s investing strategy and managing its portfolio trading activities. The fund can be managed by one person, by two people as co-managers, or by…


For this example we will be using https://fmpcloud.io/ ( stocks and financial API) and google sheet (https://www.google.com/sheets/about/).

We will demonstrate how easy it is to integrate their API into Google Sheets for accessing and keeping track of Apple Inc. price and financial statements.

Let’s get into it:

a. Create a…


1. What are the different types of financial models?

There are many types of financial modeling such as Discounted Cash Flow (DCF) Model, Merger Model (M&A), Leveraged Buyout (LBO) Model.

2. What is a DCF model?

A basic DCF model involves projecting future cash flows and discounting them back to the present using a discount rate (weighted average cost of capital) that reflects the riskiness…

Antoine Vulcain

Developer, Writer, Entrepreneur. Learn Financial modeling at: https://financialmodelingprep.com

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store