Data Store price lookup

How To
1

I have a task to do the following, but struggling to extract the prices array which I think is needed from the get go. Plus is there any chances this could run into large operation use?

  1. Fetch Bitcoin price data
    • Use the following CoinGecko API endpoint:
    https://api.coingecko.com/api/v3/coins/bitcoin/market_chart?vs_currency=eur&days=2
    • This returns an array of prices, where each item is:
    [timestamp, price]

  2. Extract the highest price of today
    • Use only the prices array
    • Filter out values where the timestamp is before today’s midnight
    • From the remaining data, determine the highest price of the day so far

  3. Compare to stored reference price
    • The reference price is stored in a Make Data Store:
    • Data store name: btc_reference
    • Key: btc_eur
    • Value: e.g. 75000
    • Logic:
    If highest_price - reference_price = or higher than 1250, continue

  4. If condition is met
    • Send an email via Microsoft 365 connection:
    • Subject: Bitcoin price has increased!
    • Body:
    “Bitcoin has risen to € highest_price. That is € more than the previous threshold of € reference_price .”

  5. Update the reference price
    • Save the new highest_price as the updated reference in the same Data Store key: btc_eur

2

Welcome to the Make community!

Assuming your “today’s midnight” is local time,

Yes, that is possible. You’ll need a minimum of six modules:
Screenshot_2025-04-20_190402

This is just an example. Your final solution may or may not look like this depending on your requirements.

Minimum of 4 operations per run; maximum of 6 if price changed.

It is possible to reduce further by one operation if you are using a JavaScript module.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

4

Hey there,

Thanks for taking the time to map out a scenario! I struggled trying to extract the prices array and somehow couldn’t figure it out.

Is it possible to share that blueprint? Would be keen to know how you solved this.

5

I would suggest completing the Make Academy before jumping into building a complete scenario. If you need specific assistance when you are building a scenario it’s easier to help you then. Otherwise, you can also hire a professional by posting a request in the Hire a Pro category.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

You can also use the Hire a Pro category to request for private 1-to-1 assistance via video call/screenshare/private messaging/etc. This may help you get your issue resolved faster especially if it is urgent or contain sensitive information. It is important to post your request in the Hire a Pro category, as forum members are not allowed to advertise their services in other categories like here (even if it’s free/unpaid). Posting in the Hire a Pro category will allow other members to assist you over other forms of communication.

Alternatively, you can use the private messaging feature to directly reach out to other forum members. To do this, go to your profile, and click on the “New Message” button:

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.