Скачать или смотреть Build this CRYPTOCURRENCY DASHBOARD in Google Sheets

Hey,

So in this video I build a cryptocurrency dashboard in Google sheets.

As mentioned at the start I used a few sites to pull the data:

Logos: https://cryptologos.cc/
Cryptocurrency Prices: https://cryptoprices.cc/sitemap.txt
Google Finance Crytocurrency List: https://www.google.com/finance/market...

Here are the functions I use in the video too:

Live crypto prices:

=IMPORTDATA("https://cryptoprices.cc/BTC/")

All Time high:

=IMPORTDATA("https://cryptoprices.cc/BTC/ATH")

Logos:

=IMAGE("https://cryptologos.cc/logos/cardano-...")

Currency trailing 365 from dynamic dropdown

=GOOGLEFINANCE("CURRENCY:"&B2&"USD", "price", TODAY()-365, TODAY())

Cryptoprice for the last 365 days

=GOOGLEFINANCE("CURRENCY:ETHUSD", "price", TODAY()-365, TODAY())

Keywords:
cryptocurrency dashboard Google Sheets, build crypto dashboard, Google Sheets crypto tracker, live cryptocurrency data Google Sheets, cryptocurrency investment tracking, Google Sheets API crypto, automate crypto data in Sheets, Google Sheets tutorial crypto, custom crypto dashboard creation, managing crypto portfolio Google Sheets, cryptocurrency analytics Google Sheets, data visualization crypto Google Sheets, Google Sheets formulas for crypto, real-time crypto updates Sheets, Google Sheets crypto analysis, cryptocurrency portfolio dashboard, Google Sheets financial tracking, crypto market trends Google Sheets, creating crypto reports Google Sheets, crypto price alerts Google Sheets, Google Sheets integration cryptocurrency, cryptocurrency charts Google Sheets, dashboard setup Google Sheets crypto, Google Sheets crypto project, financial management crypto Google Sheets, crypto investment dashboard Google Sheets, API data fetch crypto Google Sheets, cryptocurrency valuation Google Sheets, Google Sheets crypto data import, cryptocurrency tracking solutions Google Sheets

Hashtags:
#CryptocurrencyDashboard #GoogleSheetsCrypto #CryptoTracker #LiveCryptoData #CryptocurrencyInvestment #GoogleSheetsAPI #CryptoDataAutomation #CryptoDashboardTutorial #CryptoPortfolioManagement #CryptoAnalytics #DataVisualization #RealTimeCrypto #CryptoAnalysis #PortfolioDashboard #FinancialTracking #CryptoMarketTrends #CryptoReports #PriceAlerts #CryptocurrencyCharts #DashboardSetup #CryptoProject #FinancialManagement #CryptoInvestment #APIDataFetch #CryptoValuation #CryptoDataImport #TrackingSolutions

This list aims to help your video reach viewers who are keen on using Google Sheets for financial tracking and analysis, specifically those interested in the cryptocurrency market, providing them with the keywords and tools they need to find your content for building a dynamic and informative cryptocurrency dashboard.