How To Use A Cryptocurrency API With Parabola
Updated: February 15, 2021

How To Use A Cryptocurrency API With Parabola

Tutorial Time: 11 Minutes
Ravinder Deol

Table Of Contents

1. What Is Parabola?

2. What Is Financial Modeling Prep (FMP)?

3. What Is Google Sheets?

4. What You’ll Learn In This (No-Code) Tutorial?

5. Setting Up Your API

6. Filtering Your Data

7. Renaming Your Columns

8. Numerically Format Your Data

9. Exporting Your Data

10. Publishing Your Flow

11. Next Steps

What Is Parabola?

Parabola is a drag-and-drop automation tool. The tool allows you to build custom automation without code. Furthermore, they offer a range of automation templates to help you get started. Parabola can get summarised as assisting you to automate your manual, repetitive data tasks.

What Is Financial Modeling Prep (FMP)?

Financial Modeling Prep is a website that informs you about stock market information. Furthermore, they offer an easy to use API, which provides financial data for every need: earnings calendar, financial statements, etc.

What Is Google Sheets?

Google Sheets is a spreadsheet program part of the Google Docs Editors suite. It’s a powerful, yet often overlooked no-code tool for building without code.

What You’ll Learn In This (No-Code) Tutorial?

By the end of this tutorial, you will have extracted data from an API without code. That knowledge will open up a whole new world of APIs to access

Setting Up Your API

Sign up for an API key at FMP. And, sign up for an account on Parabola.

Log into Parabola and click ‘Add A New Flow’. Title your flow, ‘Bitcoin Tracker’.

Place the ‘Pull From An API’ function onto your canvas.

Open the function and set the ‘Request Type’ to ‘GET’. Then, confirm the ‘API Endpoint URL’ in the documentation (example below): enter it into Parabola.

  • financialmodelingprep.com/api/v3/quotes/BTCUSD?apikey=demo

Click, ‘Show Updated Results’. You should now have access to the API.

Filtering Your Data

Place the ‘Select Columns’ function onto your canvas.

Open the function and ‘Keep’ the following columns:

  • Price (price)

  • Market Cap (marketCap)

  • Year High (yearHigh)

  • Year Low (yearLow)

Click, ‘Show Updated Results’. 

Renaming Your Columns

Place the ‘Rename Columns’ function onto your canvas.

Open the function and rename the columns as follows:

  • Price (price) - ‘1 BTC = USD’

  • Market Cap (marketCap) - ‘Market Cap’

  • Year High (yearHigh) - ‘12 Month High’

  • Year Low (yearLow) - ‘12 Month Low’

Click, ‘Show Updated Results’. 

Numerically Format Your Data

Place the ‘Format Numbers’ function onto your canvas.

Open the function and format every column as follows:

  • Numbers

  • With Comma Grouping

  • Showing 2 Decimal Places

  • Rounded To The Nearest Value

Click, ‘Show Updated Results’.

Exporting Your Data

Place the ‘Send To Google Sheets’ function onto your canvas.

Open the function and authorise Parabola to post to your Google Sheet.

Click ‘File’, and ‘Create A New File’. Title the sheet, ‘Bitcoin Tracker’.

Under the export rule, select ‘Append’.

Click, ‘Show Updated Results’.

Publishing Your Flow

Click, ‘Publish’ to get your Parabola flow live.

Click, ‘Add Rule’ to the following scheduling rules for your flow:

  • Frequency - ‘Once Per Day’

  • Days Of The Week - ‘7 Days Per Week’

  • Run Time - ‘08:00 AM’

  • Time Zone - ‘Europe/London’

Click, ‘Save Rule. Then, ‘Run Flow Now’.

Your flow will now go live. It will query the API, filter your data, numerically format your data, and export it to Google Sheets.

Next Steps

Congratulations on completing this tutorial. Now, why not challenge your capabilities? Try implementing one of the suggestions below. Or try your own.

  • Call a different API Endpoint URL.

  • Include another API in your flow and merge the data.

  • Insert an If/Else Column to check if a price meets a condition.
No-Code Newsletter

Join 2,423 People Building Products Without Code

Hi, I'm Ravinder. Every week, I share a new no-code tutorial. Join 2,423 people building products without code. Oh, and you'll get a list of no-code resources.

You're in! Check your inbox for an email.
Something went wrong. Please try again.
Not convinced? View the tutorials.