Introduction

In this article, we will take a deep dive into SpreadSimple & how we can utilize this piece of Software to Build a Public, Dynamic, Crypto Portfolio Tracking Website for our Crypto Signals.

To achieve this, we will use SpreadSimple to display the Information about our CryptoCurrency Calls while Google Sheets resembles the backbone of our little application.

There are multiple ways to get Live Crypto Prices into your Google Sheets. In this article, although we will focus on two ways to get near to real-time, Cryptocurrency Information into our Sheets via =IMPORTDATA & =IMPORTXML.

A little bit of Background

One of my first memories about Bitcoin, The Blockchain & its existence, dates back to around 2010/2011, when one of my buddies & I had a conversation in Highschool trying to figure out how Bitcoin worked, what made it special, trying to grasp anything that we could understand about The Blockchain.

Bitcoin was very new at that time. Knowing nobody but my buddy who heard about this mysterious currency and its technology, the ball got rolling, and I found a new interest in the so-called crypto-verse.

Skipping through a few years in Highschool, earning a few Bitcoin with my Designing Service »real quick«, but also equally spending my first Bitcoin »real quick«, on dumb stuff like Games, pranking my friends with Spoofcard.com, or some other “fun” stuff at that time. Awfully paying with Bitcoin, of course.

I always kept an eye out on the Crypto-sphere and am glad that I did so. That so-called “Bitcoin Scam” or “Bitcoin Bubble” that should have burst at least a bazillion times in the past is now more present than ever, challenging the current state of our Financial System once again. want more? bitcoinisdead.org

Fast forward a couple of years, I have been investing pretty consistently into the space, building a small but growing Portfolio. Ever since Bitcoin, Ethereum & the altcoins took off in 2017, countless peers started reaching out to me asking for advice because I was that kid who told them about Bitcoin in high school. I will skip the stories about friends who ended up investing, first losing 50% of their stake because they panicked, then ultimately going mental when they realized they sold their asset at -50% when it’s up 100x to this point in time. As a result, I stopped talking to anyone about crypto besides fundamentals & technology.

I have been tracking my investments ever since but have never really talked about what assets I invested in and why, so I decided to create a Public, Crypto Portfolio Website with Google Spreadsheets + Spreadsimple. Using this platform, I can share my Investments with my Friends & Family without directly advising them in any way. (this is not financial advice btw :,-) I am just making them aware of specific Crypto-Related Projects I invest in.

Let’s get back to work!

Preparing the Spreadsheet

Duplicate & Link my Premade Spreadsimple Boilerplate or Create a Spreadsheet in your Google Sheets Dashboard & Copy & Paste all necessary rows.

Setting up SpreadSimple

• Sign Up at Spreadsimple.com
• Duplicate & Link my Premade Google Sheets Template or Copy & Paste necessary rows
  • Visit my premade Google Docs Spreadsheet Template & duplicate it
  • Link The Spreadsheet via the SpreadSimple Dashboard
  • Populate & Link all the Necessary Content to be displayed on the frontend.

Pulling Live Crypto Prices in Google Sheets

Method 1: =IMPORTDATA (Restricted Datapoints)

Use a service like Cryptoprices.cc to fetch Crypto Prices in Google Sheets:

Method 2: =IMPORTXML (More Datapoints)

Use XPath to Parse Crypto Prices directly into a Google Sheets Cell:

Styles & Scripts in Spreadsimple

In our Colorless Crypto Spreadsimple Website Example we added some styles to our data as well as injecting Splitbee.js Tracking Script to get some insights about our audience.

The Styles used in this Template can be found below:

Styling the Main Page

<style>
a{
color:white;
}
.sv-tile__image{
border-radius: 4px !important;
}
.sv-tile__table-row:nth-child(6) .sv-value {
color: #FF3643 !important;
}

.sv-tile__table-row:nth-child(7) .sv-value {
color: #D4A52E !important;
}

.sv-tile__table-row:nth-child(8) .sv-value {
color: #1672da !important;
}

.sv-tile__table-row:nth-child(9) .sv-value {
color: #4EAC4F !important;
}
</style>

Styling the Details Page

<style>
.sv-product__spec:nth-child(5) .sv-product__spec-value {
color: #FF3643 !important;
}

.sv-product__spec:nth-child(6) .sv-product__spec-value {
color: #D4A52E !important;
}

.sv-product__spec:nth-child(7) .sv-product__spec-value {
color: #1672da !important;
}

.sv-product__spec:nth-child(8) .sv-product__spec-value {
color: #4EAC4F !important;
}

.sv-product__spec:nth-child(9) .sv-product__spec-value {
color: #ba07d7 !important;
}
</style>

Styling the Hero with CSS Gradients

<style>
.sv-viewer-intro.sv-has-cover:before{

background: linear-gradient(131deg, #ff568b, #ffa3c0, #ffa786, #ffd58e, #ffdf59, #eda900);
background-size: 1200% 1200%;

-webkit-animation: AnimationName 0s ease infinite;
-moz-animation: AnimationName 0s ease infinite;
-o-animation: AnimationName 0s ease infinite;
animation: AnimationName 0s ease infinite;
}

.card-accent{
color: rgb(255, 86, 139);
}

.sv-tile__image{
border-radius: 4px !important;

}
</style>

Injecting Splitbee Analytics Tracking Script

<script async src="https://cdn.splitbee.io/sb.js"></script>

You can Inject any tracking script from Splitbee, Google Analytics, Hotjar and many more. To do so go to Spreadsimple –> Settings –> Scroll down & choose Body End, to inject your script.