The script does not seem to pick up the GOOGLEFINANCE formula that is used in the Universe tab from which the data is being looked up with the VLOOKUP function in the submit tab (H2:I2). This works perfectly however I’m facing a problem with the price and market cap in column F and G on the watchlist tab. I repeat the process to add multiple tickers and stock information to the watchlist tab. This basically moves the data from cell C4:N4 to a new sheet ‘watchlist’. Once I have all the information on cells C4:N4, I have a script that I found (I have no prior experience with app scripts) which I run by clicking the “Submit” button on cell P3. Build and create your own stock watchlist in this Google Sheets tutorial The stock watchlist we build will give you a quick dashboard so that you can monitor your all your potential stock. Using cell references again the cells B4:N4 are populated. Create Stock Watchlist The video below shows a step-by-step technique of how to create a stock portfolio in Google sheets. The cells from J2:N2 are manually entered. Google sheets is a very versatile tool and provides a quick way to monitor your stock portfolio in combination with updated stock quotes from Google Finance. Along with a real-time view of the stock’s market data, you can see financial news related to the stocks you follow. The cells C2:I2 get populated with the relevant information. If you haven't organized your watchlist yet, head to Google's finance search or look for a company you'd like to monitor, like Alphabet, and hit the plus button next to the results to add. The Universe tab is a database of stocks. I’ve identified at least six free Google Finance replacements (they have premium versions) and each is worth investigating. The cell has a reference at C2 that searches for the ticker, name, sector, industry, sub-industry, price and market cap in the Universe tab using VLOOKUP.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |