How to use Google Sheets to get the price of specific crypto-currencies at specific times?

I have an assortment of cryptocurrency transactions over time. Different currency pairs at different prices. I must determine the price of these currencies, in Bitcoin, when I bought them.

The manual solution is to look for a historical price graph of each pair (ETH / BTC, LTC / BTC, XRP / BTC, etc.) at the time of purchase and to record it. But it goes without saying that this process is extremely tedious and tedious.

I already have the date and time of each purchase, with the currency purchased and the amount, in a spreadsheet. I would like to be able to extract the final data that I need from an API, directly in my sheet.

I had something similar using but it returns only the value of BTC in USD. I need to get the value of other currencies in BTC.

Liracoin – THE GREATEST Cryptocurrency of the future! – The corner of crypto-currencies

Imagine the lives of the people who invested in Bitcoin years ago. Today, they are among the richest personalities in the world! So what did they do and what were you unable to do? They were able to detect the potential, which most people like you were unable to detect or were busy criticizing. But can this change now? Is it possible to travel in time?

The answer is no! There is no time machine built yet, but before your head drops your head, there is a possible alternative: Liracoin! Liracoin is that chance that rarely gives life, the second chance for people who missed Bitcoin, and even today, they regret it!

Liracoin is a cryptocurrency, a digital currency built and applied to the blockchain, a registry of public sharing.


The blockchain is the revolution, the cryptocurrency is the first tool applied to the blockchain system. This makes digital currencies much safer and immutable, as they are disconnected from the banking system, while guaranteeing complete anonymity and irreproachable integrity.

In a wave of thousands of crypto-currencies, Liracoin has the chance to continue through his community. Liracoin has since its conception been a project run by the community, an autonomous and decentralized organization, independent of any political limit and without geographical location.

Liracoin is based on three pillars, as well as its strengths and differentiating characteristics: ambassadors, adoption and application.

Liracoin is the currency of the people. Liracoin has shown its spread especially in Africa and Europe, where 200 companies have started to accept Liracoin (LIC) as a means of payment.

Liracoin is a cryptocurrency built and applied to the blockchain, a public sharing registry. The production of liracoΓ―ne is carried out through: 95% of proof of participation and 5% of proof of work. Liracoin uses Green Mining Proof-Of-Stake technology, based on deposit, seniority and transactions in which new Liracoins are forged for each block and combined with POW extraction and Scrypt technology. Liracoin's point-of-sale model reduces the risk of hacker attacks, data manipulation, or concentration of value and market monopolization. This year, a difficult fork will take place to go entirely to point-of-sale technology.

So, with Liracoin DEJA in the portfolio of the biggest investors, it is the opportunity to which you also participate!

Get more details from here:

Satoshi Nakamoto blog top 50:

Satoshi Nakamoto's blog:


New Airdrop: Coinxes – The Corner of Cryptocurrencies

New Airdrop: Coinxes

πŸ’² Total reward: 15 CXG [~$3] + 30 CXG [~$6] by reference

πŸ”΄ Start the bot telegram

(Http://πŸ”˜ Create an account on the Coinxes website (
πŸ”˜ Join the telegram ( of Coinxes.
πŸ”˜ Follow their Twitter account (
πŸ”˜ Submit your information to the Airdrop bot.

πŸ”΄ The chips will be distributed on your ERC20 wallet on Coinxes.

Verge Discussions – The corner of cryptocurrencies

Verge is a thriving cryptocurrency that aims to make transactions completely anonymous. Produced in 2014 under the title DogeCoinDark, it was renamed Verge Currency last year.

The currency is virtually unobtainable and Verge consumers can make instant anonymous transactions. To do this, they use a very innovative blockchain technology, complemented by services such as Tor and I2P that hide your personal data, such as IP addresses and geolocation.

The currency also differs from other crypto-currencies as a 100% open-source project, with members of the community able to make a decisive contribution to any decision about potential changes.

Read more:

Follow us: @monetizeinfo on Twitter | monetize on Facebook


The easiest way to create Bitcoin is here! – The corner of crypto-currencies

Earning money is never easy and is never supposed to be easy at all. But now, it will certainly be simple and easy. CryptoTab, that's all. All you need is to add it to your Google Chrome browser and that will help you win easily.

Once you have added and activated it according to the desired speed, you will be able to extract Bitcoin easily and earn money, but that is not all you can invite your family / friends to win more. With the reference system down to 10 levels, it allows you to WIN MASSIVELY.


Distribution of the automated trading industry! – The corner of crypto-currencies

Have you heard of Profit Trailer 2.0, Eonbot 1.4.1 & Crypto Hopper? Not yet? So you have no idea about how automated trading works! Or you have been fooled into believing something that is really not automated trading.

Put all this information aside and discuss the latest programs under development for automated trading. How many of you have heard of Profit Trailer, Eonbot 1.4.1 & Crypto Hopper. I'm sure a lot, as these are the hottest deals out there.


You can get full coverage with regards to setup, usage and all the rest for these and many others only through

Or if you want to know specifically these 3 dynamic systems, then you have to visit


If you are still uncertain, do not worry, because you can have a FREE TRIAL for 1 month.

Try the FREE trial:


Setup free trial for 1.42% of daily returns:

Average base configuration for the upgrade:

Advanced settings:

Look below for more information:

Official site:


Social Media Links:

– Facebook:

– Twitter:

– Steemit:

– Youtube:

freeBit – – The corner of crypto-currencies

Win btc you do not do anything
your balance will increase!

1.1. Current charge rate: The basic speed is 50 satoshi / day. If you have been online at least 75% of the time in the last 24 hours, the speed will be 100 satoshi / day. Thus, the more you are on the site for 24 hours, the faster the speed.

1.2. If the user has references, he gets 50% of his speed. If his referrals have referrals, the user receives an additional 10% of their speed.

1.3. If the user has not logged in to his / her personal account for more than 24 hours, the charges are terminated.

1.4. If the user has not logged in to his / her personal account for more than 7 days, the balance is reset.

1.5 The removal of Satoshi is only possible in the FaucetHUB system.

FREEBIT – passive income

freebitfunpayment.jpg "class =" ipsImage "src =" "/></p>
<div data-id=

How to start with Bitcoin β†’ 2019 [Step-By-Step Beginner Guide] – The corner of crypto-currencies

Start with Bitcoin, it's easy! Follow our steps. Ultimate Tutorial βœ… Buy Bitcoin βœ… Fast and easy βœ… Start in 5 minutes β†’ CryptoRunner

Start with Bitcoin, it's easy! Follow our step-by-step instructions β†’

What? Why? How?
Bitcoin has never been as popular as today. Demand is growing as more and more people understand the benefits and opportunities of cryptocurrency. This is a guide to help you get started with Bitcoin.

What is Bitcoin? Why should you use Bitcoin? How to start with Bitcoin? Where can I buy Bitcoin? We will answer these questions and explain everything you need to know.

This is a brief overview of the digital currency to start quickly. We have simple, step-by-step instructions, and at the end of the guide, we help you buy Bitcoin instantly.

Some people say they do not use Bitcoin because they do not understand the underlying Blockchain technology. A common excuse not to start using new technologies.

It's easy to buy and use Bitcoin, and you do not need to understand the technology to use it (although that's fine). It was the same thing at the beginning of the internet. However, all are using the Internet today even if everyone does not understand the technology.

Bitcoin is here to stay, and it is proven that technology works and is safe. The only question is how long will you wait before buying cryptocurrency. Have you ever considered buying Bitcoin but have not done so because of the high price? You are not alone. However, remember that the price was also high, at $ 10, $ 100 and $ 1,000.

Past performance does not prejudge future results. But there will never be more than 21 million bitcoins. If you buy only one bitcoin, you still have more than 99.85% of the world's population. (You can of course buy less than a bitcoin).

What? Why? How? If you can answer these questions, you already have more knowledge about Bitcoin than 99% of the population. It's time to stop procrastinating and getting started with Bitcoin!

Want to know more about Bitcoin? Visit here:

We have many guides and reviews to help you navigate the crypto space. You can also subscribe to our newsletter to stay up-to-date and receive exclusive offers.

Contact us:

Connect with us:

The corner of cryptocurrencies?

Hello my dear,

Please tell me what are Bitcoins?

Adethereum – – The corner of crypto-currencies


Earn 0.15 – 6 Szabo By click
Earn 0.03 – 1.2 Szabo per referral click
10% to 2% via the 7-level reference upgrade
10% to 2% through 7-level benchmark expenditures
The minimum withdrawal amount is 2500 Szabo
1 Szabo = 0.00000100 ETH
Supports multiple payment currencies (Payeer and Ethereum)
Earn more Szabo in our Games section
Earn 4x with the subscription

SISTER SITE from and !!

Registration bonus:

– Free Szabo 250

– 10000 free banner impressions;

– Free 100 PTC views.