Skip to content

Latest commit

 

History

History
62 lines (42 loc) · 2.36 KB

README.md

File metadata and controls

62 lines (42 loc) · 2.36 KB
Raw

Notion API - Crypto Prices

Based on the original repository from Broto/Notion-API-Currencies

This repo is an update to the latest integration for Notion API totally made in JavaScript.

Breaking Changes / Change log

  • Removed the "updateCurrencyConversions" method cause it's not needed for me.
  • Changed all the process to obtain the current cryptos from the Notion DB and then update them.
  • Got available cryptos standalone to avoid repeated updates.
  • Changed DB column name from "USD" to "Current" cause I want to obtain current value for each crypto instead of it's value on USD.

Why I made this?

I want to get noticed for the all value changes on my crypto investments. First i created my own Notion DB and then I started to search a method to update the current prices in my local currency (EUR)

I found this repo and I started to make changes to fit them to my DB and i ended with this solution.

This fork is for persons who follow an DCA investment strategy and don't want to waste time updating values from a table.

Current DB

I leave here an image of my current DB

screenshot image

DB Formulas

As you can see I setted a lot of formulas in my DB. I leave them below:

  • "Status" (to see if you get gain or loss)
    • (prop("Gain EUR") >= 0 or prop("Crypto") == "USDT") ? "🟢" : "🔴"
  • "Real Amount" (real amount obtained of the crypto at the moment of the investment)
    • toNumber(slice(format(prop("Coin Amount") * prop("Coin Price")), 0, 5))
  • "% Gain" (Percentage of your gain/loss)
    • toNumber(slice(format((prop("Current") / prop("Coin Price") - 1) * 100), 0, 4)) / 100
  • "Gain EUR" (Gain/loss in EUR)
    • prop("% Gain") * prop("Real Amount") + prop("Real Amount") - prop("Invested")

NOTE: I used EUR, but you can put your local currency in all the formulas and fields.

Important fields

  • Crypto_ID: ID of the crypto to query on CoinGecko API
  • Current: Field used to update the current value of each crypto on your local currency

Project Description:

Medium Post

Setup:

Notion Credentials

Create a .env file with the content of the .env_dist file with your own.

Install

yarn install

Run:

yarn start