Gemini API FAQs: Troubleshooting The Best Bitcoin DCA Strategy

Table of Contents*

*Nothing I post is financial advice

β™ŠοΈ Sign Up for Gemini and get $10 of BTC when you Trade $100:

​πŸŽ₯ Original Video Tutorial:

πŸ“‰ Does it Work With ETH, LINK, LTC etc? πŸ“‰

Yes! Check out the symbols and minimums section of the Gemini API.

You’ll see below that not only do you need to update the symbol from btcusd to ethusd (for Ethereum) but you also need to update the tick size. The tick size for BTC is 8 the tick size for ETH is 6 etc. Updating this tick size allows us to get more accurate rounding in the price variable.

πŸ‡ͺπŸ‡Ί Does it Work With Euros and Pounds? πŸ‡ͺπŸ‡Ί

Yes! Similarly to the last answer, just check the symbols and minimums section of the Gemini API. You’ll see below that there are codes for USD πŸ‡ΊπŸ‡Έ EUR πŸ‡ͺπŸ‡Ί GBP πŸ‡¬πŸ‡§ and SGD πŸ‡ΈπŸ‡¬

Just replace btcusd in the code with your desired currency pair.

πŸ’° How Do I Fix Insufficient Funds Error πŸ’°

You’ll get this error if you don’t have enough currency in your account to make the trade. If the symbol you are trading is btcusd, you’ll need USD to execute the trade. Similarly, if you’re trading ethbtc you’ll be writing in the script how much BTC of ETH you want to buy (a little confusing). You can check to see how much of each currency you have in the Account balances and history tab of your Gemini account (Account in the top right -> Balances)

Account Balances and History

It should look something like that ^^ and should show you any holds that are being placed on your account by active trades or other situations that would lower your “Available to trade” balance.

πŸ”‘ How Do I Fix Invalid Signature Error πŸ”‘

Invalid Signature Error

A few people have run into this error and it has been solved every time by generating new API Keys and readding them to your Lambda Function in AWS.

❓What is in❓ contains the gemini-python and google sheets Python packages that I leveraged to write the scripts. We need this code to be hosted in AWS to run the code correctly.

I generated using my local python environment and Docker. If you’d like to generate your own I was able to follow this great tutorial and (with 0 prior Docker experience) generate a working

πŸ’» Can You Implement This Locally Without AWS? πŸ’»

Yes you can! Here’s a video of me implementing the script on iOS using Pyto and Siri Shortcuts:

The first recorded video of a human buying Bitcoin with a HomePod

Of course you can implement for free with your own Python environment on your Mac/PC. You’ll just need to pip install gemini-python and pip install gspread (if you want the spreadsheet functionality) to get the necessary code packages (you don’t need to do this in the AWS version because all those dependencies are packaged in

🏷 Can I Set the Limit Price to $X 🏷

Yes! The script in the Siri Shortcuts video works by letting you set your own limit price. If you want to manipulate the code from Notion, you’ll just need to update the price variable from:

price = str(round(float(trader.get_ticker(“BTCUSD”)[‘ask’])*.999,2))


price = “30000”

In this example, we’re making a limit order where the limit price is $30,000. This has the benefit that your order will fill only when the price falls to $30,000 giving you a better execution price. But comes with the downside that if the price never falls to $30,000 your order will never fill.

The current line: price = str(round(float(trader.get_ticker(“BTCUSD”)[‘ask’])*.999,2))

Is taking the current spot price of Bitcoin (“BTCUSD”)[‘ask’] and setting the price of your order to .999 * current spot price (ie. if Bitcoin is trading at $35,000 your limit order will be made for $34,965). You can change that .999 factor to any other number you’d like if you want to try to get Bitcoin at a lower price.

Comment thread on what happens if you set the factor too low

Above is a comment thread answering the popular question: can I set the factor to be 0.9 / 0.85 / something lower than 0.999

In short, the answer is yes and usually you’ll be fine. When BTC (or whatever currency you’re trading) rips up and doesn’t come back down though you’ll end up with lots of orders on the book over a long period of time.

πŸ€– How Do I Automatically Deposit Funds to Gemini? πŸ€–

EDIT: I figured it out (rejoice πŸ₯³), here’s a tutorial:

Unfortunately, I haven’t found a way to do this yet. Ally Bank, Schwab, and Capital One all refused to do recurring deposits to my Gemini account and there is no functionality in the current Gemini API to automate deposits.

If you find a bank that allows creating recurring deposits to Gemini please send me an email at and I’ll give you credit (and love you forever).

I’ll update this thread (and probably make a video) if/when I figure that out.

As of now, this is the missing piece that would make the strategy fully automated.

My current strategy is to make one large deposit each month to cover all my monthly DCA.

πŸ™ˆ How Do I See My Order? πŸ™ˆ

Go to Account -> Settings -> Account and select ActiveTrader as your Trading Interface.

Account -> Settings -> Account

Your open orders should show at the bottom left of your trading interface

Total shown is exclusive of fees

πŸ’Έ How Do I Confirm The Fees I Paid? πŸ’Έ

You should be getting an email to the email associated with your Gemini account every time an order fills that looks like this:

Email showing fees

If not, go into Gemini -> Account -> Settings -> Notifications and make sure “Your limit order is complete” is selected.


If you still aren’t getting the emails, check your spam filter.

🏦 Why Aren’t My Withdrawals Processing? 🏦

If your withdrawals aren’t processing, first confirm that you’ve whitelisted the address that you’re trying to send to.

You can check this by going to Gemini -> Account -> Settings -> Approved Addresses

You’ll see your withdrawal addresses where that giant black box is

Additionally, when you try to make a withdrawal you’ll want to confirm that the funds you’re expecting to withdraw have settled.

Available for withdrawal under the bell icon in the top right of the trading UI

By default the script will try to withdrawal the full amount of BTC/ETH that is “available for withdrawal”

If you deposited via ACH your funds will take ~7 days to settle within Gemini. Only after the funds have settled will they be considered to be available for withdrawal.

πŸ“§ Why Won’t Gemini Support Won’t Email Me Back? πŸ“§

Contrary to what some people might think, I actually don’t work in Gemini support. I have heard though from quite a few people that Gemini’s email support is horrible. This mostly seems to be around account verification.

To avoid this problem I would suggest fully verifying your account before trading on the platform (I agree that this is not a great solution).

If you are already stuck in Gemini email support hell, I received feedback from one commenter who successfully escaped Gemini email support hell that sending a kind email explaining your situation and what you need to get unstuck helped a lot. Sometimes we have to check our egos to get what we want πŸ˜ƒ

If this doesn’t work, I don’t really know what to tell you sorry! πŸ˜”

πŸ‘» All My Lambda Functions Disappeared! πŸ‘»

AWS has different regions that basically act as different environments. If all your functions disappeared you’re probably not in the region you originally created them in. Go up to the top right and click through the different regions to find where you created them.

To find out where you’ve created functions you can go into billing and see what is running.

Billing shows where you’ve created functions

🧠 Final Thoughts 🧠

Feel free to DM me on Twitter if you have any questions not covered here. This has been a really fun project and a ton of people have sent me screenshots of them getting this to work and saving a ton of $$$ on fees, so if you get stuck don’t despair! This is definitely doable, even with limited / no technical expertise.

If you can manage to avoid the dreaded Gemini email support system, this is still the lowest fee way to buy Bitcoin.

Onward and upward!


The Best Way to Buy Cryptocurrency in 2021 (How To Buy Automatically and With Lowest Fees using Gemini + AWS )

Table of Contents*

*Nothing I post is financial advice

β™ŠοΈ Sign Up for Gemini and get $10 of BTC when you Trade $100:

​πŸŽ₯ Full Video Tutorial (if you don’t like reading):

πŸ““ Notion Code Link:

πŸ’Έ Fee Structure πŸ’Έ

The reason that Gemini is the best exchange to use is that WHEN USED CORRECTLY they have the best fee structure

However, there are lots of way to mess this up. Example 1 (that most people will use) is the mobile fee structure.

You can see here when you do a regular mobile order (which is very convenient and likely how most people will by default use Gemini) the fees can be anywhere from 1.49% to 10% (!!) – this is WAYYYYY too high

Where Gemini excels is their API Fee schedule + their Transfer Fee schedule (don’t snooze on me here just because I brought up APIs – I’ve already coded everything for you)

You can see here at the lowest volume tier they offer .35% taker fees, but we can do better than that. We’ll be shooting for that .1% maker fee (100X better than the worst case 10% fee on the mobile schedule).

Some other exchanges (Kraken / Binance) also have .1% fees and in some cases (like Binance) allow you to get even lower when you pay the fees using their token.

The reason Gemini is better than both of these exchanges from a fee perspective is that Gemini doesn’t charge you on chain withdrawal fees on your first 10 withdrawals each month. This is huge for tokens like Ether and other ERC-20 tokens with massive gas fees, but it will save you money on Bitcoin too.

β™ŠοΈŽ Set Up Gemini API β™ŠοΈŽ

To take advantage of these low fees we need to set up access to your Gemini API. So after you’ve set up a Gemini Account here you’ll head into settings -> API (Programmatic access)

And you should see a screen that looks something like this

Click that big CREATE A NEW API KEY button

Select Primary

And copy your API key / API Secret into a safe place (and make sure never to show them to anyone or they will be able to trade/transfer on your behalf) the API Keys above are for demo purposes only and are not active

Select fund management and trading settings like we have in the screenshot above

Confirm that you’ve copied and pasted your API Key (Public Key) and API Secret (Private Key) into a safe place we’ll be accessing them in the next section (if you ever lose them or the script stops working for some reason you’ll need to come back here and regenerate new ones – no big deal)

Hit confirm and you’re done! – Pretty easy

πŸ€‘ Buying With AWS Lambda Functions πŸ€‘

First you’ll need to make an AWS account (you might need to provide them credit card info but all the services we’re using are completely free as of this writing – you can check the current cost of Lambda Functions and Cloudwatch here)

If you’re like “But Rhett I don’t wanna make an AWS account”

Tough Toenails!

It’s 2021! The world is teeming with FREE opportunity!

AWS is one of those opportunities.

Learn it, level up your brain, and prosper!

Now that you’ve set up AWS, all the code you’ll need is hosted for you here in Notion

The first thing you’ll want to do is download this file from the Notion link. This zip file contains all the Python dependencies for the code hosted on the Notion page (namely gemini-python and gsheets [Google Sheets])

If you are suspicious of the code in the feel free to generate your own. Instructions here to generate the layer zip using Docker + your own local Python environment.

Once you’re in AWS you’ll head over to the Management console and you’ll go over to Lambda under Compute

Inside Lambda head over to Layers on the left nav and hit Create Layer (top right)

Inside Create Layer, name your layer and upload the file from Notion and choose Python 3.8 as the runtime

Hit create and then head over the functions in the left nav of Lambda and hit create function

Choose Author from Scratch, name your function, and choose Python 3.8 runtime

Delete the code in and paste in the code from the Notion link above

Fill in the public_key and private_key strings with your public key (API Key) and private key (API Secret) from the Gemini API step above.

It should look something like this (yours will obviously be different but format should be the same):

public_key = “account-SDcdX7y3E5XsYRy6pkt8”

private_key = “AytmxmozZbeNokpfnRFcZfYkrq”

Next go down to add a layer (bottom right of screenshot)

Choose custom layer and pick the layer you imported earlier in this step from

After you hit add, come back to the code tab hit the deploy button to save your changes.

Note that by default on line 21 of the buy-bitcoin the script will try to buy $20 of Bitcoin. You can change this number to whatever number you want.

When you hit test, you can fill out an event name and hit create (leave the code alone).

And then your script will try to buy $20 of Bitcoin from your Gemini account (note: you obviously have to have more than $20 in your account for this to work).

If you are getting timeout issues go to “Configuration” next to the code tab and hit edit on general configuration and change the timeout from 3 seconds to 30 seconds.

You should now have a script that allows you to buy $X from Gemini, so next let’s automate it so you can buy once a day/week/month/year etc.

πŸ€– Automation With AWS Cloudwatch πŸ€–

Go back to the AWS Management Console and click on CloudWatch

Inside CloudWatch navigate to the Rules tab under Events in the left nav

Click Create Rule here

Now click into Schedule instead of Event Pattern under Event Source

You can either change the fixed rate of days to the number of days you want or you can get fancy with Cron expressions

Cron expressions will allow you to set your own custom timing for how often these buy / transfer / sheet updating script runs.

For more info on Cron timings check out Amazon’s Documentation here

Some popular Cron timings:

15th + 30th of each Month: 0 12 15,30 * ? *

Every Friday: 0 12 ? * FRI *

Last day of each Month: 0 12 L * ? *

Once you’ve set your timing add your lambda function as the target on the right side under Targets

Configure details, give it a name, AND YOU’RE DONE!!!

🧠 Final Thoughts 🧠

There are some other little things you’ll need to do for the transfer / google sheets updating scripts

In the transfer script you’ll need to whitelist the address within Gemini in Settings and provide your BTC address(es) in the script – same way we included the public and private keys here earlier

The Google Sheets script is a little more complicated you need to set up your Sheets API – but it is really worthwhile because it will give you ultimate control in knowing how much money you’re actually making with this BTC dollar cost averaging strategy.

Video Walkthrough of the Google Sheets Script setup here

Again none of this is financial advice. This strategy has worked out really well for me, and the automation has been really powerful in allowing me to stop worrying about day to day price fluctuations so I wanted to share this with others.

If you do get this set up, let me know. If you have questions or get stuck feel free to leave them below or on the YouTube video above and I’ll do my best to get back to you A$AP Rocky

Happy Stacking πŸ™‚

Book Review | The Bitcoin Standard by Saifedean Ammous

Get The Bitcoin Standard Free with Audible Premium Plus

The Bitcoin Standard is Saifedean Ammous’s Bitcoin thesis. What makes the book great is that it doesn’t start from Bitcoin and draw conclusions about sound money but, rather, Saifedean reasons from first principles and comes to Bitcoin as the conclusion.

There are a few great takeaways from this book:

1) Low Time Preference

Keeping low time preference is what allows society to exist. Understanding that I (an individual) don’t have to constantly be farming and hunting my food allows me to specialize on other tasks. Which allows the individual to provide disproportionate value to society.

If Steve Jobs spent his whole life hunting food we’d all be a lot worse off.

2) Austrian vs Keynesian Economics

Saifedean dedicates part of this book to his hatred for Keynesian economics. I don’t feel as strongly and don’t know enough but he makes interesting points about how inflationary currency drives high time preference behavior which cheapens culture, art, and society.

This positions Bitcoin as the exit ramp from Keynesian economics. If you have ever wanted to play pure Austrian economics – Bitcoin forces its adopters to play by these rules. It is interesting to view Bitcoin this way – an environment to see how a programatic version of Austrian economics would play out where no central government or authority can change the rules.

I think reading this in tandem with The Deficit Myth by Stephanie Kelton will give you a cursory understanding of the differences between Austrian and Keynesian economics.

3) Bitcoin as Digital Gold

Bitcoin is shown to have all the same properties (durability, portability, divisibility, recognizability, scarcity) that make gold sound money – but with Bitcoin those properties are on steroids. Bitcoin can’t be destroyed, it is much more portable than gold, it is infinitely divisible, it costs much less to verify that what you have is in fact Bitcoin, and as of 2024 Bitcoin will have a higher stock to flow ratio than Gold.

These properties of hard money are important because it stops foreigners (with harder money) from cheaply producing our money and then coming in and buying our country (as happened in Africa when they were using beads as money, and in India and China who were on the silver standard in a world with other nations on the gold standard).

The countries with easy to produce money were easily taken advantage of economically by countries with hard to produce money (this advantage didn’t stop governments with hard to produce money from getting addicted to stimulus – which will forever be politically convenient). In Rome they would lower the % of gold in a coin and today, JPow adds some extra 0’s at the end of a government database.

All of this ties together to present Bitcoin as the digital version of gold that promises to either:

reform the financial system that has been interfered with by governments and Keynesians (however you feel about them aside)


create an entirely separate monetary system where we can see, in real time, whether the tenants of Austrian economics or Keynesian economics are more valuable (based on real market cap figures).

Looking at the USD/BTC chart, it doesn’t look great for the dollar.

Buy Bitcoin Everyday with Coinbase Pro and AWS Lambda Functions

Table of Contents*

*Not financial advice


I got into Bitcoin in 2017 and had a consistent monthly dollar cost averaging schedule set up.

When the price tanked in 2018 so did my interest.

I played all sorts of little psychological games with myself convincing myself why it wasn’t urgent that I make my Bitcoin purchase this month.

There was no hype, and there was very little media attention.

My interest was renewed in 2019 (fueled by the hype of reading Ben Mezrich’s book Bitcoin Billionaires) and I decided that automating my purchases was my best defense against myself and the FUD (fear uncertainty and doubt) circulating around Bitcoin.

I chronicled my first attempt at automation on the blog here:

And on YouTube (in a long complicated video) here:

This original design was difficult to test and update (involved pushing up to git, logging into AWS Lightsail, pulling from git, and hoping nothing broke) and there was a ~$2 a month fee for the Lightsail instance – yuck!

My smarter than me girlfriend was taking an AWS course, stumbled upon lambda functions and Cloudwatch automation (which are free).

This infrastructure also allows for a more modular design that is a lot easier to maintain (and is less coding to get started).

Hold on to your hats, you’re going to be blown away by how elegant this is.

Coinbase Pro API

This is the same as last time. You’ll still need an API passphrase / secret / key to automate trades.

To sign up for Coinbase Pro you’ll need proof of ID, name, email address, phone number and some other info depending on your region.

Full instructions to sign up for Coinbase Pro are here

Once you’ve signed up for Coinbase Pro, you can activate your API.

Click API under your User Name in the top right
Click +New API Key and record your Passphrase

Under Permissions I’ve Selected View Transfer and Trade because:

If you want your Python script to automatically dump the trade details into your Google Sheet you’ll need to check the View box

If you want your Python script to automate withdraws + deposits you’ll need to check the Transfer box

If you want your Python script to automate purchases you’ll need to check the Trade box

Record your API Passphrase (ray0ddnl6j in the screenshot) in a text file, we’ll need that for our Python Script to access your Coinbase information.

*** It is important not to share your API passphrase / secret / key with anyone you don’t trust and consider setting up 2 Factor Authentication to further protect your Coinbase Pro account.***

***The API credentials in these screenshots are just demonstrations of what yours might look like.***

Record your API Secret
HIghlighted Under Default Portfolio above nickname will be your API Key

Google Sheets API

This Google Sheets functionality is a nice to have, it will allow you to pull your transaction data into Google Sheets to understand how much money you’ve made.

I created this template (The Definitive Bitcoin Spreadsheet) based off of the spreadsheet I use that is compatible with the code I’ll be sharing later.

This is also the same as last time. This video does a great job of explaining.

You’ll end up with a .json file with credentials and you’ll need to include in your Lambda Function later on.

AWS Lambda Functions

Here’s where the magic happens: within your AWS console you’ll want to navigate to Lambda

And then before anything else you’ll want to navigate to layers and hit create layer in the top right

Now head over to this Notion link I’ve set up to host the code you’ll need for these Lambda Functions

The first thing we’ll need from Notion is the download

Back in AWS on the create layer screen upload the and name it whatever you want and leave the runtime and license fields empty.

This is going to allow our AWS hosted Lambda function to use the cbpro and gsheets Python packages.

Once you’ve set up the layer you can head over to the functions tab on the side of the AWS Lambda screen and click create function in the top right.

In Author from Scratch, name the function whatever you want, select Python 3.8 in runtime and hit create function in the bottom right.

First, within the function we’re going to add our layer. Click on layer underneath your function name and then add a layer in the bottom right.

Choose Custom Layers and add the layer you created earlier, this will allow our script to use those included Python libraries.

If you want to include other Python libraries here is the tutorial I used to generate

Back in your Lambda Function base you’re going to want to copy and paste the code over from my Notion page into your Lambda Function

Once you’ve copied over the code you’ll want to fill in your key secret and password from the Coinbase Pro API step above

Additionally, in the Sheets updater code you’ll need to include your sheets_creds.json in the package at the same level as the You can do this by right clicking and adding new file at the folder level.

Deploy the code to save the changes and then hit test and enter any name in “event name” you can leave your test event code at the hello-world template. Once you hit create you’ll be able to run the script using the test button


AWS Cloudwatch

Clicking Test will now run your script once, but you want it to run once a day/week/month etc.

Cloudwatch makes this really easy.

Get into CloudWatch from the AWS Management Console and then go to Rules on the left nav

Click the blue (purple? I’m colorblind) Create Rule button

In this section select schedule and you can set either a fixed rate or for more detail you can give it a Cron expression

If you need help configuring your Cron this site is really helpful: (note that Cron expressions from this site are missing the ? parameter that AWS uses before the last * so you’ll need to re-add that ? expression to your Cron if you generate it from this site)

Select your lambda function from the dropdown and click configure details

Name your rule and give it a description and you’re all done!!!!


Let me know in comments here or on YouTube or email me at if you have any questions or get stuck.

The beauty of this is that you can set different scripts to different automated cron schedules very easily through the AWS UI.

Additionally there is basically no programming involved in this whole process, you don’t even need a local environment since all the code is being handled in AWS.

Now you can stop worrying about the Bitcoin price, sit back, relax, and stack sats.

How I Automate My Bitcoin Purchases and Track Profits

Table of Contents


I (like many others) started buying Bitcoin in 2017.

I was buying monthly – in 2017 almost every month included a huge price movement culminating in a $19,000 high in December.

The media noise Bitcoin made every month made it really easy to remember to make my monthly purchase.

As 2018 came around, the speculative bubble popped and the price crashed down to $3,000.

From then on it became incredibly difficult for me to remember to buy monthly because no one was talking about Bitcoin.

That led to me making few investments into Bitcoin in 2018 and missing out on a major opportunity for profit.

Around August 2019 (fueled by the hype of reading Ben Mezrich’s book Bitcoin Billionaires) I finally got serious and automated my Bitcoin purchases with a Python script and Coinbase Pro’s API.

I connected this to my Google Sheet (The Definitive Bitcoin Spreadsheet) that tracks the value of my Bitcoin purchases over time.

I’ve found this spreadsheet to be addictive to look at, but keeping the data in a spreadsheet gives me greater control than any of these silly stock ticker / wallet apps and gives me an ad-free experience.

I hope this article will be user friendly enough that you’ll be able set up the same system quickly and easily.

How to Install Python

Below is a guide to installing Python on Windows/Mac/Linux:

Alternatively: If you have a Mac you can install Python3 using Homebrew detailed instructions here

Now that we’ve installed Python it’s time to get a Coinbase account.

Coinbase Pro API

To sign up for Coinbase Pro you’ll need proof of ID, name, email address, phone number and some other info depending on your region.

Full instructions to sign up for Coinbase Pro are here

Once you’ve signed up for Coinbase Pro, you can activate your API.

Click API under your User Name in the top right
Click +New API Key and record your Passphrase

Under Permissions I’ve Selected View Transfer and Trade because:

If you want your Python script to automatically dump the trade details into your Google Sheet you’ll need to check the View box

If you want your Python script to automate withdraws + deposits you’ll need to check the Transfer box

If you want your Python script to automate purchases you’ll need to check the Trade box

Record your API Passphrase (ray0ddnl6j in the screenshot) in a text file, we’ll need that for our Python Script to access your Coinbase information.

*** It is important not to share your API passphrase / secret / key with anyone you don’t trust and consider setting up 2 Factor Authentication to further protect your Coinbase Pro account.***

***The API credentials in these screenshots are just demonstrations of what yours might look like.***

Record your API Secret
HIghlighted Under Default Portfolio above nickname will be your API Key

That’s all we need from Coinbase so let’s move on to creating the Python script!

Python Scripting

Before we get started you’ll need to install the gspread and cbpro Python libraries. You can do this from the terminal on Mac with ‘pip install gspread’ and ‘pip install cbpro’

Below is the code you’ll use to automate your bank transfers, purchase Bitcoin, and dump the information into your Google Sheet.

import gspread
from oauth2client.service_account import ServiceAccountCredentials
from datetime import date
import calendar
import cbpro

my_key = 'YOUR API KEY'
my_secret = 'YOUR API SECRET'
my_password = 'YOUR API PASSWORD'
bank_id = 'YOUR BANK ID'

#Populate Transaction Data to Add as New Row in GSheet
def _addTransaction(transaction):
transaction_date = str(transaction['created_at'][0:10])
transaction_id = transaction['trade_id']
provider = "Coinbase Pro"
quantity = float(transaction['size'])
btc_price = float(transaction['price'])
fee = float(transaction['fee'])
usd_amount = float(transaction['usd_volume']) + float(fee)
return [transaction_date, transaction_id, provider, quantity, btc_price, usd_amount, fee]

#Access your GSheet
def _authenticateSpreadsheet():
#Set up access to the spreadsheet
scope = ["",
creds = ServiceAccountCredentials.from_json_keyfile_name("Sheets_creds.json", scope)
client = gspread.authorize(creds)
return"The Definitive Bitcoin Sheet").worksheet("BTC Buy Audit File")

def buyAndPopulateBTC(cb_key, cb_secret, cb_password, bank_id):
buy_size = 0
days_in_month = calendar.monthrange(,[1]
auth_client = cbpro.AuthenticatedClient(cb_key, cb_secret, cb_password)


#Deposit if Necessary
if == 15: deposit = auth_client.deposit(buy_size*days_in_month, 'USD', bank_id)

#Open the correct spreadsheet + worksheet
audit_file = _authenticateSpreadsheet() btc_fills = list(auth_client.get_fills(product_id="BTC-USD"))

#Get last transaction ID added to worksheet and get a range of days to pull in
last_transaction = audit_file.get_all_records()[-1]['Transaction ID']

#Reverse btc_fills to get dates into Sheets in descending order
for transaction in btc_fills[::-1]:
if transaction['trade_id'] > last_transaction:
cbpro_row = _addTransaction(transaction)
audit_file.append_row(cbpro_row, value_input_option="USER_ENTERED")

buyAndPopulateBTC(my_key, my_secret, my_password, bank_id)

As it is written, the code above will buy 0 dollars of bitcoin, deposit 0*number of days in the month (October has 31) dollars into your Coinbase account on the 15th of every month, and record the transaction to your Google Sheet Named “The Definitive Bitcoin Sheet” in worksheet “BTC Buy Audit File”.

However, it won’t work as written. You’ll need to fill out your relevant information (API keys + amounts you want to buy + bank info).

You’ll also need to authorize gspread with Google and get a json keyfile (mine is called Sheets_creds.json in the code above)

It will look something like this:


*** Don’t share your credentials with anyone ***

Keep that credentials file in the same directory as your Python script and reference it correctly in the _authenticateSpreadsheet() method.

If you’re stuck, here’s the tutorial I used to get the Google Sheets part working:

Here is a link to the public version of the spreadsheet I built to track transaction data. If you come up with a different format you’ll want to update the _addTransaction method in the Python script so the data comes over cleanly.

Automation: AWS

At this point in the process I was a little out of my depth.

For a while I just woke up everyday and ran the script from my computer.

That got old fast.

I wanted something that would run the script even if I didn’t have access to my computer (if I’m on vacation I still want to be buying Bitcoin)

Luckily I found this great article by Eric Landstein detailing how to automate Python scripts from a Lightsail Ubuntu instance on AWS.

Link to that article here

You can get your code from your machine to the AWS Ubuntu machine using GitHub or any other version control software.

Alternatively, there are probably other ways to automate this Python script. If you Bing “Automate Python Script” you’ll find plenty of resources.

Resources and Considerations

Be careful running the script – once you set it up correctly if you have a few too many 0’s in the buy size you’ll run out of money.

The buy_size in the script above is set to $0 so you can test. If you’re extra paranoid you can comment that line out or test with an API (key/secret/password) that doesn’t allow trading.

Below are some developer resources that were helpful to me when getting this up and running.

If there are any questions feel free to leave them below, email me at, or tweet at me @rhettre

See you on the moon,


Python CBPro Documentation (Helpful for finding out your Bank ID and other misc data if you want to do something different with your script)

Python GSpread Documentation (Helpful if you have a different spreadsheet layout you want to use)

Cron Timing Calculator (Helpful for getting the Ubuntu cron timing right on AWS)

How to Buy Bitcoin for Beginners (2020)

I’ve broken this blog post down into three sections for people with:

  1. No Technical Experience – I am afraid that if I held my own Bitcoin, that I would lose it and don’t bank on my phone
  2. Limited Technical Experience – I am comfortable using mobile devices and I bank on my phone
  3. Technically Proficient – I understand what a private key is

If you have No Technical Experience:

You can get exposure to Bitcoin through your brokerage account through the Grayscale Bitcoin Trust ($GBTC)

The upside of this is that you don’t have to worry about taking custody of your Bitcoin. You don’t need to know what a private key is. You don’t have to worry about misplacing or losing and of your Bitcoin.

The downside of this is that GBTC won’t get you the best price on Bitcoin exposure. You’re paying a premium (in peak times – a large premium) to get exposure to Bitcoin.

However, if you’re very comfortable operating in the traditional “stock” world, you have a brokerage account and you have no interest in doing something different and don’t mind that an outside institution is holding your Bitcoin – GBTC is a good bet.

If you have Limited Technical Experience:

You have a lot of options here.

Really any of the well known exchanges will do the trick in terms of allowing you to purchase Bitcoin. Some popular ones include:

These apps work just like your traditional bank account. You sign in, create an account, link a funding source (checking / savings account / credit card*)

*Buying Bitcoin with a credit card or on margin is baby brain, don’t do it you’re better than that

Most of these exchanges will allow you to keep your coins on the exchange, and if you don’t want to deal with private keys or taking custody of your own Bitcoin you can stop here.

The pros of this is that you won’t have to learn any more and if you are unsure about your ability to keep track of a private key you don’t have to worry about that.

Additionally with some of these services above (like BlockFi) you can earn interest on the Bitcoin that you allow them to custody (like you would with a bank). As of this writing BlockFi is giving 6% interest on Bitcoin and 8.6% interest on stablecoins like USDC and GUSD (crypto tokens that track the price of the US dollar).

I have used BlockFi for almost 6 months now and it has consistently returned 5x the interest of my traditional “high interest” savings account with half the amount of money invested in the BlockFi account (that’s a 10x difference in interest)

If you are interested in BlockFi we both earn crypto when you use this link to sign up:

The cons are that some of these exchanges have higher fees to pay than others, and you are still not taking custody of your own Bitcoin.

There is a common phrase in the Bitcoin community: “Not your keys not your coins”. And there are historical examples of exchanges, like Mt.Gox, going kaput leaving people with all their Bitcoin on the exchange with their hands in their pockets.

The Crypto world was a lot less advanced back then but some are still wary of this risk, so they choose to custody their own Bitcoin (think hiding your gold in a safe at your house rather than having it with a bank somewhere you’ve never seen it).

Like it or not there will always be counterparty risk until you fully custody your own Bitcoin.

If you want to learn about private keys, this is the video that got me into Bitcoin:

Private Keys – the video that got me into Bitcoin

Basically a private key is just a really big number that acts as an address for your Bitcoin. Some wallet apps (like Bread Wallet (BRD) on iOS) generate a private key and allow you to take custody of your Bitcoin on your iPhone.


Basically the private key number is so big that even with every computer working together for the next 1000 years no one will ever recreate that number.

This is the double edged sword that comes with taking custody of your own Bitcoin. Literally no one can ever take it from you – unless you lose the key.

If you are Technically Proficient:

You should be looking to minimize your fees and storing your coins in a hardware wallet or cold storage depending on your risk preference.

I use Coinbase Pro (.5% fees) and their available API to automate trading and dollar cost average everyday. Then once a week I send the Bitcoin out of the exchange into a Ledger Hardware Wallet.

Hardware wallets are basically just small computers that securely generate a private key.

In this case, I am still trusting that Ledger doesn’t somehow know / keep a list of every private key they generate. The counterparty risk still exists it is just lower.

The full Winklevoss Security Systemβ„’ – rolling dice in a blacked out house with no cameras/ technology inside and then scattering copies of private key fragments into safety deposit boxes across the world with your identical twin has just about 0 counterparty risk but there’s a lot of room for failure in the setup, so if you don’t know what you’re doing it’s better to just keep it simple.

It seems like there are some ways to get Bitcoin for 0 fees but I’m not totally up on that, if anyone wants to walk me through it I’d love to chat.

So hopefully now you know how to buy Bitcoin and have figured out what level of security you want for yourself.

If you have any questions feel free to email me or find me on twitter @Rhettre

Below are my results for buying Bitcoin everyday for a year (August 2019 – 2020)

In the video I discuss dollar cost averaging, why bitcoin, BlockFi, how I automated my purchases, and how much money I made.

Book Review | The Price of Tomorrow by Jeff Booth

I’ve been trying to explain this idea to people forever. The idea that this 2% inflation target is not being met because technology was driving the costs of some goods down. Why do phones cost the same every year even though they keep getting better? Why are some goods cheaper than ever on Amazon and Alibaba? Where was the inflation occurring?

This book has the answer I was unable to articulate. Technology is deflationary.

Unfortunately that nugget of good information is contained mostly in the first chapter of the book (with some what should we do about it in the final chapter of the book – hint: bitcoin [duh])

The middle chapters read like Andrew Yang’s The War on Normal People – a scary and exciting picture of things to come from technology painted by a tech entrepreneur who has made his fortune and is now out to make the world a better place.

To be honest, I barely remember any of those middle chapters. I’ve already heard all the theories about AI and job loss and robot workers and how polarized the world is and the rise of populism – it’s exhausting even recounting these ideas.

I was primed to love this book as the author shares my views on inflation and bitcoin (my two favorite things to talk about), but I would have liked more of the author’s opinion and analysis of what to do about it rather than explaining to me how the world is doomed (which seems to be a pretty fashionable thing to talk about).

That being said the timing of this book (published January of 2020) is remarkable. It was pre-trillion(s) dollar stimulus, pre-bitcoin halving, pre-coronavirus (the acceleration of all these futuristic trends). And I’m sure Jeff Booth has many lucrative speaking opportunities and doesn’t care about my 3 star review of his book (that I mostly agree with and really enjoyed some parts of).

C’est la vie.

Book Review | The Deficit Myth by Stephanie Kelton

How I got Here
I picked up this book after watching a friend’s instagram story where he claimed that after reading this book, Joe Biden’s 2 trillion dollar climate plan made a lot of sense. I disagree, and thought I’d read the book because I wanted to experience cognitive dissonance.

The Thesis
The thesis of Modern Monetary Theory (MMT) is that currency issuing countries that hold debt denominated in their own currency can print money at any point to make all the debt go away.

MMTers see (currency issuing) government debt as an irrelevant metric to measure financial stability instead opting to view economic health through the lens of how much inflation a country is experiencing. They’ll argue that we should print as much money as we can before causing a big inflation problem to get massive public works projects underway (employing everyone possible through a federal jobs guarantee) and that taxes are not meant to fund the government, only to reduce the spending power of citizens.

The Good
This book makes great points and, because of the credentials of the author and how well structured the arguments are, is very persuasive.

I agree that this is how the government is operating now (spend and print as much money as you want, the debt doesn’t matter as much as people think because the government is not a currency user it is an issuer).

The Bad
However, I disagree that MMT is a reasonable path forward.

Forgetting the Loserthink that demonizes politicians by reading their inner thoughts like:

“Lawmakers can feign empathy with their constituents while claiming their hands are tied by the deficit. If they couldn’t hide behind the deficit myth what excuse would they use to justify withholding support?”

the real problem with the MMT philosophy is the obvious black swan hyperinflation risk it creates.

Stephanie admits in the book that printing tons of money will eventually lead to inflation (she just thinks that we’re far from that point – we’re a “6 foot man hunched over in a home with 8 foot ceilings”. Which is totally possible – she would know better than I would). What we likely disagree on is the effectiveness of the government or any group of people to appropriately predict what the outcomes of pulling all these different levers (interest rates, printing more money, artificially creating full employment, etc). We’ll only need to get it wrong a few times (with very different people controlling this massive responsibility for the rest of America in time) to really mess things up.

The ultimate irony occurs when Stephanie is railing against the US’s failing infrastructure pointing to a dam (that was recently inspected and given a review noting the fragility to a low probability catastrophic event) burst and killed a man and destroyed his home when that low probability catastrophic event came true.

MMT is the dam. MMTers are the inspectors. And the water coming to flood our homes is hyperinflation.

MMTers will tell you that the chance of hyperinflation is low and that they’ll create robust government systems (paradox?) to avoid it, but by the time we’ve spent hundreds of trillions dollars on projects that don’t need to ROI it will be too late to turn back.

The Bitcoin
*gets on soapbox*

“Well Rhett, if you don’t like how unpredictable the money supply from the US government is that’s too bad, there’s no alternative.” – They

If only there was a way to convert my unknown supply dollars to a fixed supply asset that adds new supply to the system in a programmatic, predictable, public way and doesn’t take decision making advice from lobbyists.

Stay away from They.

*stays on soapbox until the soapbox is on the moon*

The Conclusion

Yuppies who fantasize about one upping their friends with political / economic knowledge at dinner parties should read this book because upcoming policy debates are no doubt going to come down to your feelings on MMT. If nothing else, it will make you think differently about the problems the country faces.

The 2 trillion dollar stimulus (so far) and the proposed 2 trillion dollar climate plan are 4 trillion more reasons to buy bitcoin.

(None of this is financial advice)