If you have a broker account, you can obviously check the data there, but brokerages will usually require you to login to see your portfolio and sometimes may also require two-factor authentication.
=GOOGLEFINANCE(ticker,, ,, )Īccording to Google, you can also add parameters to find out data like the opening price, the price high or low for the day, the trading volume, and you can also set a range of dates, so you can play around with it to get the information that you want to be shown in the cell. Using =GOOGLEFINANCE(“stock ticker name”) is the most basic option and will show you current prices, but the formula can be expanded to cover more information (see below). Hit enter and give it a second or two to pull the data and the price should now be reflected in the cell.So for example if you wanted to track Google’s stock prices, you would type =GOOGLEFINANCE(“GOOGL”).In any of the cells, type in =GOOGLEFINANCE(“stock ticker name”).So if you want to track your portfolio using Google Sheets, here’s how. Obviously if you have a brokerage account, you could always login to see how your stocks are doing, but that might be a bit troublesome compared to just pulling up Google Sheets. Plus the fact that Sheets is also free to use makes it a lot more appealing, but what if you wanted to keep track of your stock portfolio? Maybe you want to keep track of your daily expenses, work that needs to be done, keep a database of your contacts, and so on, all of that can be achieved with Sheets.
0 kommentar(er)
