Manage Your Stocks with Google Sheet and Google Finance API

Learn how to Use Google Finance APIs in Google Sheets, to import the details about a particular stock.

Original Photo by Markus Spiske on Unsplash

“Ignoring technological change in a financial system based upon technology is like a mouse starving to death because someone moved their cheese” — Chris Skinner

• Are you an investor who has a habit to check your portfolio every now and then?
• Do you have some favorite stocks and you want to regular update of those stocks?

Here I have a simple trick with which you can observe or track your portfolio or your favorite stock from Google Sheet.

Requirement:-

• A Google Account
• Some Favorite Stocks
• Appetite to learn.

Syntax

Before start using the function GOOGLEFINANCE let's understand all about it.

GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date])

• GOOGLEFINANCE: Function.
• ticker : Stock symbol trading on the exchange.
• attribute : is the following parameter of stocks including (price, priceopen, high, low, volume, marketcap, pe, eps, high52, low,52)
• start_date : [optional] start date when fetching historical data.
• end_date: [optional] end date when fetching historical data.

How to use with Google Sheet

Now Here I did some examples to get to know how to use these APIs with Google sheet.

1. Open a new Google sheet and try to add the below formula

=GOOGLEFINANCE(NSE:TechM,price)

Here is a screenshot of what I included in my Google sheet.

Conclusion

In this article, we learn How to manage your portfolio or favorite stocks and manage an eye on their key attributes with the help of Google Sheet and Google Finance API. Put all of your stocks in this formula and create your own google sheet in your Google Drive. You can view the prices of stocks at any moment without opening your trading account or broker’s app.