>
>
How To Use A Cryptocurrency API With Parabola
Updated:
March 30, 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.

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

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.

Setting Up Your API (Step One)

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

Setting Up Your API (Step Two)

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

Filtering Your Data

Place the ‘Select Columns’ function onto your canvas.

Filtering Your Data‍ (Step One)

Open the function and ‘Keep’ the following columns:

  • Price (price)

  • Market Cap (marketCap)

  • Year High (yearHigh)

  • Year Low (yearLow)

Filtering Your Data‍ (Step Two)

Click, ‘Show Updated Results’. 

Renaming Your Columns

Place the ‘Rename Columns’ function onto your canvas.

Renaming Your Columns‍ (Step One)

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’

Renaming Your Columns‍ (Step Two)

Click, ‘Show Updated Results’. 

Numerically Format Your Data

Place the ‘Format Numbers’ function onto your canvas.

Numerically Format Your Data‍ (Step One)

Open the function and format every column as follows:

  • Numbers

  • With Comma Grouping

  • Showing 2 Decimal Places

  • Rounded To The Nearest Value

Numerically Format Your Data‍ (Step Two)

Click, ‘Show Updated Results’.

Exporting Your Data

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

Exporting Your Data‍ (Step One)

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’.

Exporting Your Data‍ (Step Two)

Click, ‘Show Updated Results’.

Publishing Your Flow

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

Publishing Your Flow‍ (Step One)

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’

Publishing Your Flow‍ (Step Two)

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

Publishing Your Flow‍ (Step Three)

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.