Calculate the Daily Total Returns for ANY Company in Google Sheets
Автор: SheetsFinance
Загружено: 2023-12-21
Просмотров: 2212
Описание:
In this short walkthrough, we use the SheetsFinance extension in Google Sheets to calculate the total returns of an investment over a set period. The Sheet is entirely dynamic allowing you to instantly display the total returns for any of our available financial assets with real-time data ⏱️ 📈
SheetsFinance gives you access to over 80,000 global financial assets via a series of highly customisable functions. In-built tools like the Function Generator and Stock Screener streamline your spreadsheet building allowing you to forget about the data collection and focus solely on your analysis. 🌎
0:00 Intro
0:35 The equation
1:08 Pulling in the data from SheetsFinance
4:35 Writing the total return formula
7:56 Charting the total return and capital gains
Here's the template, remember to MAKE A COPY (File - Make a copy):
https://www.sheetsfinance.com/templat...
Get the extension on Google Workspace Marketplace:
https://workspace.google.com/u/0/mark...
🔎 Everything you need to know is in the docs: www.sheetsfinance.com/docs
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: