Supreme Stock Portfolio Google Sheets
Note the disclaimer not for professional or stock trading purposes or advice.
Stock portfolio google sheets. At first when I created CRYPTOTOOLS I wanted to have a. You can use the GoogleFinance function in Google Sheets to get live as well as historical stock prices and currency exchange rates. This tutorial will focus on using Google Sheets Googles web-based spreadsheet app to work with stock data.
Also formatting and charting options should be very similar. Duplicate the sheet and make it your own. More Resources for Tracking Your Stock Trades.
In this article I will explain in brief how I built my Google-Finance-like portfolio tracker in Google Sheets. Converting Currency with Sheets. You can do this by typing the stock ticker CURRENCY followed by the codes of the two currencies you want to convert such as USDGBP or EURJPY You can also display historical currency data by specifying a date.
Lets look at both examples. What are the Easiest Ways to Track my Investments from Joshua Kennon via The Balance. You can play with the options to change the graph type adjust the date range or do anything you wish.
If you just want to download a copy scroll to the bottom of this page. A stock portfolio tracker using Google Drive with advanced functions than your average tracker. Build Your Own Stock Portfolio Tracker On Google Sheets Link to download all my Portfolio Trackers.
Google Drive isnt just a place to store files. You can tell it to pull in a stock using an explicit ticker or as you get used to working in these sheets you can use a different column to tell it what the ticker should be. This how-to can be followed along in either Excel or Google Sheets.