{"id":57705,"date":"2021-10-05T21:01:27","date_gmt":"2021-10-05T13:01:27","guid":{"rendered":"https:\/\/www.hongkiat.com\/blog\/?p=57705"},"modified":"2023-04-06T19:22:30","modified_gmt":"2023-04-06T11:22:30","slug":"spreadsheets-for-crypto-portfolio","status":"publish","type":"post","link":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/","title":{"rendered":"Best Free Cryptocurrencies Portfolio Tracking Spreadsheet"},"content":{"rendered":"<p>If you\u2019re into <a target=\"_blank\" href=\"https:\/\/www.hongkiat.com\/blog\/tag\/cryptocurrency\/\" rel=\"noopener\">cryptocurrencies<\/a> and have a portfolio of assets lying around in one or two or more <a target=\"_blank\" href=\"https:\/\/www.hongkiat.com\/blog\/exchanges-buy-sell-bitcoins\/\" rel=\"noopener\">marketplaces<\/a>, at one point I\u2019m sure you\u2019ve thought about having an all-in-one dashboard where you can just login and see if everything is going to the moon or not.<\/p>\n<p>Sure, you can have your phone widget or ticker that will show you the price changes in the past hour, or you can simply open <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.hongkiat.com\/blog\/go\/binance\">Binance<\/a> to check the prices\u2026 but will you see how much you have, your assets\u2019 value in fiat, the daily changes, charts, and other attributes you\u2019d like to see at a glance, in one page? I don\u2019t think so.<\/p>\n<p>Sure, you can build one yourself if you have decent skills with Google Sheets or Excel, but why should you invent the wheel from scratch when you can just copy these free templates?<\/p>\n<div class=\"ref-block ref-block--post\" id=\"ref-post-1\">\n\t\t\t\t\t<a href=\"https:\/\/www.hongkiat.com\/blog\/secure-ethereum-wallets\/\" class=\"ref-block__link\" title=\"Read More: 6 Ethereum Wallets to Keep ETH and Other Crypto Safe\" rel=\"bookmark\"><span class=\"screen-reader-text\">6 Ethereum Wallets to Keep ETH and Other Crypto Safe<\/span><\/a>\n<div class=\"ref-block__thumbnail img-thumb img-thumb--jumbo\" data-img='{ \"src\" : \"https:\/\/assets.hongkiat.com\/uploads\/thumbs\/250x160\/secure-ethereum-wallets.jpg\" }'>\n\t\t\t\t\t\t\t<noscript>\n<style>.no-js #ref-block-post-37718 .ref-block__thumbnail { background-image: url(\"https:\/\/assets.hongkiat.com\/uploads\/thumbs\/250x160\/secure-ethereum-wallets.jpg\"); }<\/style>\n<\/noscript>\n\t\t\t\t\t\t<\/div>\n<div class=\"ref-block__summary\">\n<h4 class=\"ref-title\">6 Ethereum Wallets to Keep ETH and Other Crypto Safe<\/h4>\n<p class=\"ref-description\">\n\t\t\t\t\t\tEthereum is a rapidly growing digital currency that thousands of people are using for trade. However, it's not...\t\t\t\t\t\t<span>Read more<\/span><\/p>\n<\/div>\n<\/div>\n<h2>1. <a target=\"_blank\" href=\"https:\/\/www.reddit.com\/r\/CryptoCurrency\/comments\/n5tvpv\/due_to_a_high_number_of_requests_ive_updated_my\/\" rel=\"noopener nofollow\">\/u\/Fly115\u2019s Cryptoprices Spreadsheet<\/a><\/h2>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-1.jpg\" width=\"1000\" height=\"805\" alt=\"Cyptocurrency spreadsheet tracker Cryptoprices\"><\/figure>\n<p>Reddit user \/u\/Fly115\u2019s live crypto tracker can <strong>track up to 5000 cryptocurrencies<\/strong>, and supports moons on <a target=\"_blank\" href=\"https:\/\/reddit.com\/r\/cryptocurrency\" rel=\"noopener\">\/r\/cryptocurrency<\/a> subreddit. With this spreadsheet, you can <strong>track your trading gain and loss<\/strong> in BTC and fiat.<\/p>\n<p>The great thing about this? Fly115 has been working on this tracker for a couple of years now, and it is already on its 14th version.<\/p>\n<p>That said, you can compare how altcoins are faring compared to Bitcoin. Not only that, it can also <strong>keep track of all the amount of coins you\u2019ve had since you started<\/strong>, and how the balances have worked throughout. This is particularly useful if you live in a country that actively taxes your crypto gains.<\/p>\n<p>Aside from the rows and columns that you\u2019re used to seeing when it comes to spreadsheets, it also has charts so you can visually see the dips and spikes of your coins.<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li>Can track up to 5,000 coins.<\/li>\n<li>Tracks trading gain and loss.<\/li>\n<li>Constantly being updated on Reddit (now on its 14th version).<\/li>\n<li>Has nice charts for easy visual analysis.<\/li>\n<\/ul>\n<h2>2. <a target=\"_blank\" href=\"https:\/\/medium.com\/coinmonks\/track-your-cryptocurrency-assets-near-real-time-using-google-sheets-d76f80f20b16\" rel=\"noopener nofollow\">Ahmet BUTUN\u2019s Crypto Tracker<\/a><\/h2>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-2.jpg\" width=\"1000\" height=\"805\" alt=\"Cyptocurrency spreadsheet tracker Ahmet BUTUN\"><\/figure>\n<p>Ahmet\u2019s crypto tracker is a <strong>straightforward tracker<\/strong> that you can use to keep a close watch of your crypto portfolio. The setup is a bit technical, but if you have a bit of knowledge in Google Sheets or Excel, you will fare well.<\/p>\n<p>The tracker does not give you live tracking, but it is near-live. You can <strong>automatically update the prices<\/strong> in increments of 5 minutes or more.<\/p>\n<p>In order to add cryptos, you will have to use <strong>Google Sheet functions<\/strong>, which are available for copy\/pasting on the link above. You will also need to edit the script a little bit to adjust the trigger for refresh, but it shouldn\u2019t be too difficult to do.<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li>For technical users since it utilizes Google Sheet functions to make changes.<\/li>\n<\/ul>\n<h2>3. <a target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1v1YoyR7ZLCPbtY2QTXCuKz8TOOvY4_iDPfEZvGUXmlo\/edit#gid=0\" rel=\"noopener\">Tario Sultan\u2019s Crypto Tracker (Google Sheet + Add-On)<\/a><\/h2>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-3.jpg\" width=\"1000\" height=\"805\" alt=\"Cyptocurrency spreadsheet tracker using Cryptofinance\"><\/figure>\n<p>Tario Sultan\u2019s crypto tracker is another <strong>comprehensive portfolio tracker<\/strong> for cryptocurrency investors. The only downside here is that it <strong>piggybacks on the paid service Cryptofinance<\/strong>, but it has a free trial of 1 week.<\/p>\n<p>Once that trial expires, you can still use its free features to keep track of your coins, but you\u2019ll lose access to advanced tools that are useful for active trading. But then again, if you\u2019re making money through your trades, a few dollars won\u2019t hurt for a premium experience, right?<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li>Uses Cryptofinance.<\/li>\n<li>Tracks trades, volume changes, portfolio value changes.<\/li>\n<li>Has nice graph indicators at a glance.<\/li>\n<\/ul>\n<h2>4. <a target=\"_blank\" href=\"https:\/\/cryptosheets.com\/\" rel=\"noopener\">Cryptosheets (has free tier)<\/a><\/h2>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-4.gif\" width=\"1000\" height=\"805\" alt=\"Cyptocurrency spreadsheet tracker Cryptosheets\"><\/figure>\n<p>Cryptosheets is a SaaS that does all the grunt work for you. It appeals to both hobbyists, analysts, and investors, so you can imagine how in-depth its features are.<\/p>\n<p>It can <strong>integrate with both Google Sheets and Excel<\/strong>, and has <strong>pre-built templates and functions<\/strong> that you can use with just a few clicks.<\/p>\n<p>It also <strong>supports hundreds of crypto exchanges, over 200,000 crypto assets, and derivatives<\/strong>. Compared to other services that tracks crypto for a fee, Cryptosheets\u2019 free tier is extensive enough to keep you happy, but if you\u2019re taking things seriously, then the price for upgrading isn\u2019t bad either.<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li>Supports over 200,000 crypto assets.<\/li>\n<li>Has pre-built templates you can use immediately.<\/li>\n<li>Uses Cryptosheets\u2019 free plan.<\/li>\n<\/ul>\n<h2>5. <a target=\"_blank\" href=\"https:\/\/blog.coingecko.com\/import-coingecko-cryptocurrency-data-into-google-sheets\/\" rel=\"noopener\">CoinGecko<\/a><\/h2>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-5.jpg\" width=\"1000\" height=\"805\" alt=\"Cyptocurrency spreadsheet tracker Coingecko\"><\/figure>\n<p>Who doesn\u2019t know CoinGecko? It\u2019s just one of the biggest cryptocurrency trackers in the world. It <strong>tracks over 8,000 cryptocurrencies, supports 400+ exchanges<\/strong>, and aggregates millions of data daily to provide an accurate report to millions of people worldwide.<\/p>\n<p>That said, they also have their own <strong>API which can be integrated with Google Sheets<\/strong>. With their API, you can build your own cryptocurrency portfolio tracker, crypto tracker (of coins you own or are planning on buying), and analysis of coins where you can <strong>track the volume changes, price changes<\/strong>, and other indicators.<\/p>\n<p>If you\u2019re not very familiar with coding, you\u2019ll probably need to spend a bit of time understanding CoinGecko\u2019s guide linked above, but it shouldn\u2019t be too difficult!<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li>One of the biggest crypto tracker in the world.<\/li>\n<li>An actual dashboard that will help you analyze risks, price changes, volume changes, etc.<\/li>\n<\/ul>\n<h2>6. <a target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1sIz8V9IaG60HTuK9ZEsdHgjHHK__VXnzULx5Ccukc_Y\/edit#gid=709394810\" rel=\"noopener\">CoinAtlas\u2019 Investment Tracker<\/a><\/h2>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-6.jpg\" width=\"1000\" height=\"805\" alt=\"Cyptocurrency spreadsheet tracker CoinAtlas\"><\/figure>\n<p>CoinAtlas\u2019 investment tracker is a <strong>free Google Spreadsheet template for crypto and stock investors<\/strong>. That\u2019s right, it\u2019s not just for cryptocurrencies, but actual stocks. It <strong>piggybacks on the Google Finance function<\/strong> where it pulls data directly from the stock market, and from CoinGecko for cryptocurrencies.<\/p>\n<p>It is a <strong>100% free tool that does calculations automatically<\/strong> and updates your history and the coins you are tracking dynamically.<\/p>\n<p>The setup is relatively easy too. The template itself has the guide you\u2019ll need to set up everything.<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li>Pretty spreadsheet with charts and graphs.<\/li>\n<li>Can be used for both Cryptocurrencies and the Stock Market.<\/li>\n<\/ul>\n<h2>7. <a target=\"_blank\" href=\"https:\/\/www.reddit.com\/r\/CryptoCurrency\/comments\/pho5yt\/thinking_of_selling_this_bull_runs_peak_to_buy\/\" rel=\"noopener nofollow\">Yogofubi\u2019s Crypto Market Cycle \u201cWhat If\u201d Spreadsheet<\/a><\/h2>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-7.jpg\" width=\"1000\" height=\"805\" alt=\"Cyptocurrency spreadsheet tracker, visualize risks\"><\/figure>\n<p>Compared to the previous entries, Yogofubi\u2019s crypto market spreadsheet is <strong>not a tracker<\/strong> of your trades, history, and coins, but more like <strong>a tool that helps you visualize your risks<\/strong>.<\/p>\n<p>If used correctly, it will help you decide whether it\u2019s time to sell or buy, or if you\u2019re at risk of losing money based on the trades that you\u2019ll want to make. But of course you\u2019ll still need to keep an open mind and do your research.<\/p>\n<p>Think of it as a \u201cwhat if I buy X coin at $50,000, but days later it goes up to $60,000, how much would I be losing or earning then?\u201d kind of thing.<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li>Not a trade or asset tracker, but a risk assessment spreadsheet.<\/li>\n<li>Prediction spreadsheet.<\/li>\n<\/ul>\n<h2>8. <a target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1XtHY5pR4iVSAcTWN5QWn8-WTHEoQ2ALDIKXaPSvhQS8\/edit#gid=1882097250\" rel=\"noopener\">Transilvlad and MindupLife\u2019s CryptoBooks<\/a><\/h2>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-8.jpg\" width=\"1000\" height=\"805\" alt=\"Cyptocurrency spreadsheet tracker CryptoBooks\"><\/figure>\n<p>Cryptobooks is a spreadsheet designed by Redditors who are deeply into cryptocurrencies. It <strong>utilizes Google Finance functions and CoinGecko<\/strong>, so you can keep track of both stocks and cryptos with a little bit of tinkering.<\/p>\n<p>It also <strong>hooks up with CryptoCompare<\/strong>, which is a paid service but its free account enables users to make up to 100,000 requests, so if you are a light user, this might just be the perfect tool for you.<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li>Has an in-depth structure with graphs, colors, etc.<\/li>\n<li>Utilizes CyptoCompare. Allows for 100,000 requests for free users.<\/li>\n<\/ul>\n<h2>9. <a target=\"_blank\" href=\"https:\/\/github.com\/emmtte\/Cryptocurrency-Portfolio\" rel=\"noopener nofollow\">Emmte\u2019s Cryptocurrency Portfolio Tracker<\/a><\/h2>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-9.jpg\" width=\"1000\" height=\"805\" alt=\"Cyptocurrency spreadsheet tracker Portfolio tracker\"><\/figure>\n<p>Without going much into the technicalities that built this tracker, you can just simply create a copy of the spreadsheet and fill in the Config sheet with the necessary information so you can get started with pulling your data from various marketplaces.<\/p>\n<p>It <strong>supports Kraken, Bittrex, Poloniex, Binance, Cryptopia, Kucoin, and Bitstamp<\/strong>. You just have to get your Key and Secret from your accounts in those marketplaces and the spreadsheet will start keeping track of your coins for you, including your deposits, gains and losses, etc.<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li>Supports 7 of the biggest marketplaces: Binance, Kraken, Bittrex, Poloniex, Bitstamp, and others.<\/li>\n<li>Tracks deposits, gains, losses, trades.<\/li>\n<\/ul>\n<h2>10. <a target=\"_blank\" href=\"https:\/\/codegena.com\/free-crypto-portfolio-tracker-sheet-with-wazirx-api\/\" rel=\"noopener\">Shan Eapen Koshy\u2019s Crypto Portfolio Tracker<\/a><\/h2>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-10.jpg\" width=\"1000\" height=\"805\" alt=\"Cyptocurrency spreadsheet tracker WazirX\"><\/figure>\n<p>For cryptocurrency investors in India, <strong>WazirX<\/strong> remains to be one of the primary crypto marketplaces, but it is not that well known outside of the country so there isn\u2019t much chance to create a tracker out of their API unless you make one yourself.<\/p>\n<p>So it\u2019s really great that <strong>Shan Eapen Koshy<\/strong> published a guide on how to make one, and provided a <strong>free template to keep track of your portfolio in WazirX<\/strong> through Google Sheets.<\/p>\n<p><strong>Key Features:<\/strong><\/p>\n<ul>\n<li>Built for WazirX users in India.<\/li>\n<li>Straightforward tracker of assets.<\/li>\n<\/ul>\n<h2>To End<\/h2>\n<p>So, did you find the perfect crypto price and trade tracker for you? Most likely if you\u2019re heavily invested in this, you\u2019ll need more than the items listed above, but hey, it\u2019s a good start for hobbyists! While you\u2019re at it, you might as well start tinkering and learn how to work with spreadsheets \u2013 it will come a long way!<\/p>\n<p>In any case, I hope your portfolio goes to the moon!<\/p>","protected":false},"excerpt":{"rendered":"<p>If you\u2019re into cryptocurrencies and have a portfolio of assets lying around in one or two or more marketplaces, at one point I\u2019m sure you\u2019ve thought about having an all-in-one dashboard where you can just login and see if everything is going to the moon or not. Sure, you can have your phone widget or&hellip;<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3398],"tags":[3825],"topic":[],"class_list":["entry-content","is-maxi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.8 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Best Free Cryptocurrencies Portfolio Tracking Spreadsheet - Hongkiat<\/title>\n<meta name=\"description\" content=\"If you&#039;re into cryptocurrencies and have a portfolio of assets lying around in one or two or more marketplaces, at one point I&#039;m sure you&#039;ve thought about\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Best Free Cryptocurrencies Portfolio Tracking Spreadsheet\" \/>\n<meta property=\"og:description\" content=\"If you&#039;re into cryptocurrencies and have a portfolio of assets lying around in one or two or more marketplaces, at one point I&#039;m sure you&#039;ve thought about\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/\" \/>\n<meta property=\"og:site_name\" content=\"Hongkiat\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hongkiatcom\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-05T13:01:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-06T11:22:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-1.jpg\" \/>\n<meta name=\"author\" content=\"Rean\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:site\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rean\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/spreadsheets-for-crypto-portfolio\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/spreadsheets-for-crypto-portfolio\\\/\"},\"author\":{\"name\":\"Rean\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/9055cf045c2ed578773e8a4e184ba621\"},\"headline\":\"Best Free Cryptocurrencies Portfolio Tracking Spreadsheet\",\"datePublished\":\"2021-10-05T13:01:27+00:00\",\"dateModified\":\"2023-04-06T11:22:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/spreadsheets-for-crypto-portfolio\\\/\"},\"wordCount\":1446,\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/spreadsheets-for-crypto-portfolio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/spreadsheets-for-crypto-portfolio\\\/cypto-investment-tracker-1.jpg\",\"keywords\":[\"Cryptocurrency\"],\"articleSection\":[\"Internet\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/spreadsheets-for-crypto-portfolio\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/spreadsheets-for-crypto-portfolio\\\/\",\"name\":\"Best Free Cryptocurrencies Portfolio Tracking Spreadsheet - Hongkiat\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/spreadsheets-for-crypto-portfolio\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/spreadsheets-for-crypto-portfolio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/spreadsheets-for-crypto-portfolio\\\/cypto-investment-tracker-1.jpg\",\"datePublished\":\"2021-10-05T13:01:27+00:00\",\"dateModified\":\"2023-04-06T11:22:30+00:00\",\"description\":\"If you're into cryptocurrencies and have a portfolio of assets lying around in one or two or more marketplaces, at one point I'm sure you've thought about\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/spreadsheets-for-crypto-portfolio\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/spreadsheets-for-crypto-portfolio\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/spreadsheets-for-crypto-portfolio\\\/#primaryimage\",\"url\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/spreadsheets-for-crypto-portfolio\\\/cypto-investment-tracker-1.jpg\",\"contentUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/spreadsheets-for-crypto-portfolio\\\/cypto-investment-tracker-1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/spreadsheets-for-crypto-portfolio\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Best Free Cryptocurrencies Portfolio Tracking Spreadsheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"name\":\"Hongkiat\",\"description\":\"Tech and Design Tips\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\",\"name\":\"Hongkiat.com\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"contentUrl\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"width\":1200,\"height\":799,\"caption\":\"Hongkiat.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hongkiatcom\",\"https:\\\/\\\/x.com\\\/hongkiat\",\"https:\\\/\\\/www.pinterest.com\\\/hongkiat\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/9055cf045c2ed578773e8a4e184ba621\",\"name\":\"Rean\",\"description\":\"Rean is an operations specialist, growth hacker, and a consultant specializing in remote team setup and management.\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/author\\\/rean\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Best Free Cryptocurrencies Portfolio Tracking Spreadsheet - Hongkiat","description":"If you're into cryptocurrencies and have a portfolio of assets lying around in one or two or more marketplaces, at one point I'm sure you've thought about","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/","og_locale":"en_US","og_type":"article","og_title":"Best Free Cryptocurrencies Portfolio Tracking Spreadsheet","og_description":"If you're into cryptocurrencies and have a portfolio of assets lying around in one or two or more marketplaces, at one point I'm sure you've thought about","og_url":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/","og_site_name":"Hongkiat","article_publisher":"https:\/\/www.facebook.com\/hongkiatcom","article_published_time":"2021-10-05T13:01:27+00:00","article_modified_time":"2023-04-06T11:22:30+00:00","og_image":[{"url":"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-1.jpg","type":"","width":"","height":""}],"author":"Rean","twitter_card":"summary_large_image","twitter_creator":"@hongkiat","twitter_site":"@hongkiat","twitter_misc":{"Written by":"Rean","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/#article","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/"},"author":{"name":"Rean","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/9055cf045c2ed578773e8a4e184ba621"},"headline":"Best Free Cryptocurrencies Portfolio Tracking Spreadsheet","datePublished":"2021-10-05T13:01:27+00:00","dateModified":"2023-04-06T11:22:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/"},"wordCount":1446,"publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-1.jpg","keywords":["Cryptocurrency"],"articleSection":["Internet"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/","url":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/","name":"Best Free Cryptocurrencies Portfolio Tracking Spreadsheet - Hongkiat","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/#primaryimage"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-1.jpg","datePublished":"2021-10-05T13:01:27+00:00","dateModified":"2023-04-06T11:22:30+00:00","description":"If you're into cryptocurrencies and have a portfolio of assets lying around in one or two or more marketplaces, at one point I'm sure you've thought about","breadcrumb":{"@id":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/#primaryimage","url":"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-1.jpg","contentUrl":"https:\/\/assets.hongkiat.com\/uploads\/spreadsheets-for-crypto-portfolio\/cypto-investment-tracker-1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hongkiat.com\/blog\/spreadsheets-for-crypto-portfolio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hongkiat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Best Free Cryptocurrencies Portfolio Tracking Spreadsheet"}]},{"@type":"WebSite","@id":"https:\/\/www.hongkiat.com\/blog\/#website","url":"https:\/\/www.hongkiat.com\/blog\/","name":"Hongkiat","description":"Tech and Design Tips","publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hongkiat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hongkiat.com\/blog\/#organization","name":"Hongkiat.com","url":"https:\/\/www.hongkiat.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","contentUrl":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","width":1200,"height":799,"caption":"Hongkiat.com"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hongkiatcom","https:\/\/x.com\/hongkiat","https:\/\/www.pinterest.com\/hongkiat\/"]},{"@type":"Person","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/9055cf045c2ed578773e8a4e184ba621","name":"Rean","description":"Rean is an operations specialist, growth hacker, and a consultant specializing in remote team setup and management.","url":"https:\/\/www.hongkiat.com\/blog\/author\/rean\/"}]}},"jetpack_featured_media_url":"https:\/\/","jetpack_shortlink":"https:\/\/wp.me\/p4uxU-f0J","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/57705","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/comments?post=57705"}],"version-history":[{"count":4,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/57705\/revisions"}],"predecessor-version":[{"id":66076,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/57705\/revisions\/66076"}],"wp:attachment":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/media?parent=57705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/categories?post=57705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/tags?post=57705"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/topic?post=57705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}