{"id":9857,"date":"2021-10-28T17:15:00","date_gmt":"2021-10-28T15:15:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=9857"},"modified":"2021-10-28T17:15:00","modified_gmt":"2021-10-28T15:15:00","slug":"how-to-use-cryptofinance-add-on-for-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/finance-processes\/how-to-use-cryptofinance-add-on-for-google-sheets\/","title":{"rendered":"Como usar o complemento CRYPTOFINANCE para o Google Sheets"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p>The CRYPTOFINANCE add-on for Google Sheets is a great tool that allows users to automatically transfer the latest cryptocurrency data into their spreadsheets. CRYPTOFINANCE also allows you to analyze and create insightful reports, as well as your own personal portfolio to keep track of the currencies you own. Now part of <a href=\"https:\/\/cryptowat.ch\/\" target=\"_blank\" rel=\"noopener\">Cryptowatch<\/a>, CRYPTOFINANCE pulls real-time cryptocurrency insights from over 988 cryptocurrencies in 29 exchanges.<\/p>\n<p>CRYPTOFINANCE is essentially a formula that you can use within Google Sheets to access Cryptowatch\u2019s huge database of cryptocurrency information. To access, you must have a Cryptowatch account. There is a free and paid version of Cryptowatch, which will determine the amount of access to both live and historical data.<\/p>\n<p>Let\u2019s explore in more detail on why you should use the CRYPTOFINANCE add-on in Google Sheets and how to successfully install and use it.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Why use CRYPTOFINANCE in Google Sheets?<\/h2>\n<p>The CRYPTOFINANCE add-on in Google Sheets is a great way to receive all of the latest cryptocurrency data whilst turning these into useful insights easily. Here are just a few of the additional benefits of choosing to use the product:<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<ul>\n<li><b>Real-time insights:<\/b> You can create a live connection to Cryptowatch with Google Sheets to receive all real-time data.<\/li>\n<li><b>Easy-to-use interface:<\/b> By monitoring cryptocurrency through the Google Sheets interface, you can make the most of a tool that you\u2019re already familiar with, for maximum efficiency.<\/li>\n<li><b>Implement analytical features of Google Sheets:<\/b> Use Google Sheets\u2019 powerful analytical tools to create visual representations of your data and calculate useful insights.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p>As CRYPTOFINANCE can only be accessed via Cryptowatch now, you must create an account to access the data. Cryptowatch has a number of plans that vary in price, or simply pay as you go. Every subscription is paid using credits, which you can exchange your money for. Cryptowatch does have a Fundamental package that\u2019s free to use (offering 100 requests), and you can also get a 2 week free trial of their Derivative package which offers unlimited access to everything.<\/p>\n<p>Click on this link to learn more about <a href=\"https:\/\/cryptowat.ch\/pricing\" target=\"_blank\" rel=\"noopener\">Cryptowatch\u2019s pricing plans<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to install CRYPTOFINANCE on Google Sheets<\/h3>\n<h4>Step 1: Remove old CRYPTOFINANCE add-on <\/h4>\n<p>If you already have CRYPTOFINANCE installed as an add-on from its old version on Workspace, you must remove it before installing the new version.<\/p>\n<p>To do this, open your spreadsheet and head to <b>Add-ons<\/b> > <b>Manage add-ons<\/b> and select <b>Uninstall<\/b> from the <b>More options (\u22ee)<\/b> button located on the CRYPTOFINANCE app. [\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h4>Step 2: Add the script<\/h4>\n<p>In your Google Sheets file, select <b>Tools<\/b> &gt; <b>Script editor<\/b>. The script editor should open in a new tab.<\/p>\n<p>Delete any existing copy. Copy and paste the content of CRYPTOFINANCE.gs into the page. Don\u2019t forget to name the script clearly.<\/p>\n<p>Once pasted correctly, click the <b>Save<\/b> icon found on the top menu.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CRYPTOFINANCE-\u2013-2.png&#8221; alt=&#8221;Cryptofinance apps script&#8221; title_text=&#8221;CRYPTOFINANCE \u2013 2&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 3: Run the script and refresh your Google Sheet<\/h4>\n<p>Once saved, click the <b>Run<\/b> button located immediately to the right. Cryptofinance may require permission to access your Google account.<\/p>\n<p>Head back to your Google Sheet and refresh the page. A new CRYPTOFINANCE section should appear in the toolbar.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CRYPTOFINANCE-\u2013-4.png&#8221; alt=&#8221;Cryptofinance in sheet&#8221; title_text=&#8221;CRYPTOFINANCE \u2013 4&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Now that you have successfully connected the CRYPTOFINANCE tool to Google Sheets, it\u2019s now time to learn how to use it.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to use CRYPTOFINANCE in Google Sheets<\/h3>\n<p>Google Sheets is able to access Cryptofinance data by generating Cryptowatch API keys.<\/p>\n<p>You must create your API keys in the Cryptowatch software before you can access it in Google Sheets.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>1. Sign in\/create Cryptowatch account<\/h4>\n<p>First, you must sign in to your <a href=\"https:\/\/cryptowat.ch\/account\/login?redirect=\/home\" target=\"_blank\" rel=\"noopener\">Cryptowatch account<\/a>. This should take you to the homepage.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>2. Generate API key<\/h4>\n<p>In the top right-hand corner of the homepage, click on the <b>Account<\/b> dropdown and select <b>API Access<\/b>. [\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CRYPTOFINANCE-\u2013-5.png&#8221; alt=&#8221;Cryptofinance generate API key&#8221; title_text=&#8221;CRYPTOFINANCE \u2013 5&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>To generate your key, provide a title for the <b>Key name<\/b> field. Then press <b>Generate key<\/b>.<\/p>\n<p>You should see two unique key codes appear. To access CRYPTOFINANCE, we only need the <b>Public key<\/b> code. <\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CRYPTOFINANCE-\u2013-6.png&#8221; alt=&#8221;Cryptofinance public key code&#8221; title_text=&#8221;CRYPTOFINANCE \u2013 6&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>3. Connect API key to Google Sheets<\/h4>\n<p>Now head back to your Google Sheets file. Go to <b>CRYPTOFINANCE<\/b> &gt; <b>Enter Cryptowatch Public API Key<\/b> and enter the unique Public key code into the field.<\/p>\n<p>Once entered, press <b>Ok<\/b>.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CRYPTOFINANCE-\u2013-7.png&#8221; alt=&#8221;Cryptowatch Enter Cryptowatch Public API Key&#8221; title_text=&#8221;CRYPTOFINANCE \u2013 7&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>4. Enter formula to extract data<\/h4>\n<p>Now that your Google Sheets is successfully connected to CRYPTOFINANCE, you can enter any formula to get the data you want.<\/p>\n<p>Your formula will always start with <b>=CRYPTOFINANCE(\u201cname\u201d)<\/b>:<\/p>\n<p>[\/et_pb_text][et_pb_text module_class=&#8221;spreadsheet-function&#8221; _builder_version=&#8221;4.16&#8243; border_width_left=&#8221;4px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]=CRYPTOFINANCE(&#8220;name&#8221;)[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Here are just a few examples of what you can do:<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h5>Access ALL data from Cryptowatch<\/h5>\n<p>To transfer all the data from Cryptowatch, enter the following formula:<\/p>\n<p><b>=CRYPTOFINANCE(\u201cCRYPTOWATCH\u201d)<\/b><\/p>\n<p>You should now have a new row for every cryptocurrency that Cryptowatch has data on.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CRYPTOFINANCE-\u2013-8.png&#8221; alt=&#8221;Cryptofinance formula&#8221; title_text=&#8221;CRYPTOFINANCE \u2013 8&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h5>Transfer specific cryptocurrency value<\/h5>\n<p>To get the latest data from specific cryptocurrencies, simply add the cryptocurrency symbol and your chosen exchange currency to the formula.<\/p>\n<p>For example, let\u2019s say I want to find the current exchange rate for Bitcoin in USD. I would enter the following formula:<\/p>\n<p><b>=CRYPTOFINANCE(\u201cBTC\/USD\u201d)<\/b><\/p>\n<p>The value should appear as shown below:<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CRYPTOFINANCE-\u2013-9.png&#8221; alt=&#8221;Cryptofinance Bitcoin&#8221; title_text=&#8221;CRYPTOFINANCE \u2013 9&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to create your own crypto portfolio<\/h3>\n<p>As long as you have a tab full of all CRYPTOFINANCE data (aka, your source sheet), you can then create your very own personal portfolio!<\/p>\n<p>Use this to keep track of any cryptocurrencies you own, and keep stay up-to-date with the latest insights.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>1. Create new tab<\/h4>\n<p>Create a new tab and name it \u201cMy portfolio\u201d.<\/p>\n<p>Copy and paste the headers you want to include in your portfolio from the source sheet.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>2. Pull in data from source sheet to your portfolio<\/h4>\n<p>To transfer data of specific cryptocurrencies, create a formula that pulls the data of specific cryptocurrencies from your source sheet.<\/p>\n<p>To do this, you first need to locate the cell of your chosen cryptocurrency.<\/p>\n<p>For example, if I want to use Bitcoin, I can see that in my source sheet, it is located in cell B4.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CRYPTOFINANCE-\u2013-10.png&#8221; alt=&#8221;Cryptofinance portfolio&#8221; title_text=&#8221;CRYPTOFINANCE \u2013 10&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Now, I can use a formula in My portfolio to transfer the Bitcoin data. The formula is as follows:<\/p>\n<p><b>= \u2018source sheet\u2019 !XX<\/b><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<ul>\n<li>\u2018sourcesheet\u2019 should be substituted for the name of your source sheet<\/li>\n<li>\u2018XX\u2019 should be substituted for the cell location of your cryptocurrency<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>In this example, I would enter the following formula:<\/p>\n<p><b>=\u2019All cryptocurrency\u2019 !B4<\/b><\/p>\n<p>Once entered, click the blue square on the cell and drag it to the right over the rest of your columns. Google Sheets will autofill the rest of the information for you.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CRYPTOFINANCE-\u2013-11.png&#8221; alt=&#8221;Cryptofinance all cryptocurrency&#8221; title_text=&#8221;CRYPTOFINANCE \u2013 11&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Continue to repeat the process for each cryptocurrency until you have a complete portfolio!<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.21.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>An all-in-one financial management solution<\/h3>\n<p><span style=\"font-weight: 400;\">If you&#8217;re looking for an automated system to control your finances, check out our<\/span><a href=\"https:\/\/www.sheetgo.com\/solutions\/finance\/\"> <span style=\"font-weight: 400;\">spreadsheet-based solution to automate your financial management<\/span><\/a><span style=\"font-weight: 400;\"> and track all your business transactions.<\/span>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.22.2&#8243; background_color=&#8221;#f9f9ff&#8221; custom_margin=&#8221;40px||40px||false|false&#8221; custom_padding=&#8221;15px|25px|15px|25px|true|true&#8221; border_width_left=&#8221;3px&#8221; border_color_left=&#8221;#808e95&#8243; global_module=&#8221;26540&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><em><strong>Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The CRYPTOFINANCE add-on for Google Sheets is a great tool that allows users to automatically transfer the latest cryptocurrency data into their spreadsheets. CRYPTOFINANCE also allows you to analyze and create insightful reports, as well as your own personal portfolio to keep track of the currencies you own. Now part of Cryptowatch, CRYPTOFINANCE pulls real-time [&hellip;]<\/p>\n","protected":false},"author":41,"featured_media":37626,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Let's Explore how to use\u00a0CRYPTOFINANCE\n\nToday we are learning about a really unique Google Sheet's add-on called <a href=\"https:\/\/chrome.google.com\/webstore\/detail\/cryptofinance\/bhjnahcnhemcnnenhgbmmdapapblnlcn?hl=en\" target=\"_blank\" rel=\"noopener\">CRYPTOFINANCE<\/a>. It is essentially a formula that operates as an add-on. This add-on was created by Cryptocurrency technologist Julien Buty as a way to create a crypto portfolio. It pulls the latest information from <a href=\"https:\/\/coinmarketcap.com\/\" target=\"_blank\" rel=\"noopener\">CoinMarketCap<\/a>, which currently tracks 1900+ currencies. With CRYPTOFINANCE you can import this information into a spreadsheet which you can use to analyze and report on crypto data. You can also create a personal portfolio that only tracks the coins you own and the information you want to track. By default, CRYPTOFINANCE uses USD, but you can also use 30+ other fiat currencies to track your portfolio.\n\nCRYPTOFINANCE offers both free and <a href=\"https:\/\/cryptofinance.jbuty.com\/data-availability-service\" target=\"_blank\" rel=\"noopener\">paid<\/a> versions. If you like the free version, but want more seamless data updates, you can update to the paid version without having to change anything in your sheets. It is 10USD a month, and of course, you can pay in crypto.\n<h4><span style=\"font-weight: 400\">How to Access <\/span><span style=\"font-weight: 400\">CRYPTOFINANCE<\/span><\/h4>\n<span style=\"font-weight: 400\">It is really simple to get add-ons for Sheets! The fastest way to get CRYPTOFINANCE is to<a href=\"https:\/\/chrome.google.com\/webstore\/detail\/cryptofinance\/bhjnahcnhemcnnenhgbmmdapapblnlcn?hl=en\" target=\"_blank\" rel=\"noopener\"> click this link<\/a> that will take you directly to the web store. Simply click the <\/span><b>Free<\/b><span style=\"font-weight: 400\"> button and the add-on will be added to your Google Sheets account.<\/span>\n\n<a href=\"https:\/\/chrome.google.com\/webstore\/detail\/cryptofinance\/bhjnahcnhemcnnenhgbmmdapapblnlcn?hl=en\" target=\"_blank\" rel=\"noopener\"><img class=\"aligncenter wp-image-10844 size-large\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-10-15-at-3.32.58-PM-1024x196.webp\" alt=\"\" width=\"1024\" height=\"196\" \/><\/a>\n\n<span style=\"font-weight: 400\">Alternatively, you can get the add-on by following these steps:<\/span>\n<ol>\n \t<li><span style=\"font-weight: 400\">Open a spreadsheet<\/span><span style=\"font-weight: 400\">\n<\/span><\/li>\n \t<li><span style=\"font-weight: 400\">Click the add-ons button in the navigation menu<\/span><span style=\"font-weight: 400\">\n<\/span><\/li>\n \t<li><span style=\"font-weight: 400\">Click the Get add-ons button<\/span><span style=\"font-weight: 400\">\n<\/span><\/li>\n \t<li><span style=\"font-weight: 400\">A window will pop up for you to browse<\/span><span style=\"font-weight: 400\">\n<\/span><\/li>\n \t<li><span style=\"font-weight: 400\">Type \u201cCRYPTOFINANCE\u201d in the search box.<\/span><span style=\"font-weight: 400\">\n<\/span><\/li>\n \t<li><span style=\"font-weight: 400\">Click the Free button to get the add-on<\/span><\/li>\n<\/ol>\n<span style=\"font-weight: 400\">You are ready to start<\/span><span style=\"font-weight: 400\">\u00a0using CRYPTOFINANCE!<\/span>\n<h4>How to Use CRYPTOFINANCE<\/h4>\nNow that you have added the CRYPTOFINANCE add-on to your Google Sheets account, it is time to give it a try.\n\nUnlike other add-ons which have a lot of complicated steps to set up, CRYPTOFINANCE is pretty easy and straightforward. It is essentially a formula that has been made into an add-on to make your life easier. When you add CRYPTOFINANCE to your Google account, it is ready to be used on all of your sheets. However, if you want to\u00a0<em>deactivate\u00a0<\/em>it on other spreadsheets, you can click <strong>Add-ons \u2192 Manage add-ons<\/strong>. From the add-ons manager, click the <strong>MANAGE<\/strong> button and then click \"Use in this document\" to switch CRYPTOFINANCE on or off for individual\u00a0sheets.\n\n<img class=\"aligncenter size-large wp-image-9993\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-03-at-1.22.54-PM-1024x678.webp\" alt=\"\" width=\"1024\" height=\"678\" \/>\n<h4><\/h4>\n<h4>OK\u2014Let's Make Your Crypto Portfolio!<\/h4>\nThe first step is to pull in ALL the data from CoinMarketCap onto your first sheet.\n\nAll you need to do is copy and paste this formula into cell A1 of your sheet, and let the add-on go to work.\n\n<strong>=CRYPTOFINANCE(\"COINMARKETCAP\")<\/strong>\n\nWhen you first enter the formula spreadsheet may need a few minutes to import all of the data. If you see an error message like the one in the picture before,\u00a0 don't worry. As long as you have typed the formula into the cell correctly, the information will load!\n\n<img class=\"aligncenter size-large wp-image-9997\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-03-at-1.32.00-PM-1024x656.webp\" alt=\"\" width=\"1024\" height=\"656\" \/>\n\nOK. Have a look! CRYPTOFINANCE has created 1910 new rows in the sheet\u00a0<span style=\"font-weight: 400\">\u2192 one for every cryptocurrency it has data on.<\/span>\n\n<img class=\"aligncenter size-large wp-image-9998\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-03-at-1.34.14-PM-1024x525.webp\" alt=\"\" width=\"1024\" height=\"525\" \/>\n\nSo, although it is great to have all of this data at our fingertips, no one wants to have to filter through nearly 2000 coins to find the info in their portfolio! Next, create a second spreadsheet within this Google Sheets File called \"My Portfolio\".\n\n<img class=\"aligncenter wp-image-10001 \" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-03-at-1.38.21-PM-300x160.webp\" alt=\"\" width=\"424\" height=\"226\" \/>\n\nLet's create the header for our portfolio. In cell A1 type \"Coin ID\". For cells B1-Q1 you can simply copy and paste the cell information from your data source sheet. (<em>If you copy\/paste cell A1, then the formula will be entered on the new sheet, pulling in all the data once again.<\/em>) Go ahead and customize your fonts and colors of your header if viewing data this way is more comfortable for you.\n<h4>Pull in Data For The Currencies You Own Or Monitor<\/h4>\nLet's say you own Bitcoin, Ethereum, and Shadow Coin, we want your portfolio sheet to only display data for these coins. We can use the formula =sourcesheet!<em>XX\u00a0<\/em>to import data. The name of our source sheet is CoinMarketCap. The XX's represent specific cells within our CoinMarketCap spreadsheet.\n\nSo, as you can see in the screenshot below, the Bitcoin data lives on row 2 of our CoinMarketCap sheet. On our portfolio sheet, we can type in\u00a0=COINMARKETCAPt!A2 into cell\u00a0A2. Now all you need to do is click the blue square on cell A2 and drag it to the right over the rest of your columns. Google Sheets will autofill the rest of the information for you. Next, simply repeat for the currency you want to track. Keep in mind that these currencies are sorted by market cap, so as the market fluctuates, their order may change, and you may need to fix the formula in your portfolio to reflect the new cell location.\n\n<img class=\"aligncenter size-large wp-image-10005\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-03-at-2.00.30-PM-1024x598.webp\" alt=\"\" width=\"1024\" height=\"598\" \/> <img class=\"aligncenter size-large wp-image-10006\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-03-at-2.00.52-PM-1024x601.webp\" alt=\"\" width=\"1024\" height=\"601\" \/> <img class=\"aligncenter size-large wp-image-10007\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-03-at-2.01.12-PM-1024x302.webp\" alt=\"\" width=\"1024\" height=\"302\" \/>\n\n&nbsp;\n\n<code class=\"markup--code markup--p-code\"><\/code>","_et_gb_content_width":"","footnotes":""},"categories":[36],"tags":[50],"class_list":["post-9857","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-finance-processes","tag-finance"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=9857"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9857\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/37626"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=9857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=9857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=9857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}