Create an apps script to read data from the Google sheet and email it Here the cell C3 contains the ticker symbol.Ĭreate a Named Range for this data to make it easy to access it from a script.Įnter a name for the range. Here is an example: =GOOGLEFINANCE(C3, "price"). 🛈 To get the current price of a stock, use the GOOGLEFINANCE formula. The three columns are for each company's name, ticker symbol and stock price. Create a table with three columns in a sheet named "Data". The first step is to create a Google Sheet and enter information about the stocks you want to track.
You're familiar with Google Sheets and basic concepts such as using functions.Ĭreate a Google Sheet containing data for the report If you're not familiar, I've created an introduction to apps script series that you can refer to. Ideally, you've used JavaScript or Google Apps Script before (they're both based on ECMAScript). You're familiar with basic coding concepts. If your use case requires reliable and accurate information on stocks that you own, I'll let you evaluate and decide for yourself if this solution will work for you. Therefore, please treat this post as just an example of how to build automated email reports using Google Sheets. I used to use this approach to keep a tab on stocks that I own but I have since moved to using other software since Google Finance data can sometimes be inaccurate or stale.
0 kommentar(er)
