In this sheet I'll store every day at 00:00 the value of the cell A3 with the date in order to build a graph of the daily values. Now I create a new sheet and I put the header of two columns, date, and value. In cell A2: =GOOGLEFINANCE("NASDAQ:AMZN" "price")Īnd I want to keep track of the average of those two values, so A3: =AVERAGE(A1:A2) In cell A1: =GOOGLEFINANCE("NASDAQ:GOOG" "price") Import Stock Prices from Google Finance from Web Step 1: Import Stock Prices from Google Finance to Google Sheets Step 2: Publishing the Google Finance Stock Prices Data Step 3: Importing the Stock Prices into Excel Step 4: Modifying the Stock Prices Inside Power Query Step 5: Updating the Stock Prices Method-2.
To keep things simple for this question, let's say I have the following values: To do that I have my google Spreadsheet with many formulas calculating the profits or losses ratios taking into account the price I bought them, broker costs and the price right now calculated with: =GOOGLEFINANCE("MARKET:COMPANY" "price")
Hello, I want to keep track of the profit of the combination of many stock values.
0 kommentar(er)
