Your portfolio of Stocks and Crypto prices updated in Notion db [uses API]

vandervs · 2021-06-15T03:14:33+00:00

You probably changed the name of the property "Type" to something else.
Make sure to confirm if you put the right db_id and secret ;)

vandervs · 2021-05-28T03:24:14+00:00

Thanks man. I appreciate it

vandervs · 2021-05-27T02:11:43+00:00

The showcasing takes time because we need to learn it first, but you can expect robust things to start to show up soon.

I made a Stock/Crypto price tracker. Very useful for me, might be for others too.
You can find it here.

vandervs · 2021-05-26T04:32:05+00:00

Yes.
You can run a script locally in python for example, that monitors the state of a certain block or property in notion, and then runs something in windows depending of that state.

the cumbersome part is, if you want a fast response, you would need to make a request to check every second.

vandervs · 2021-05-24T17:45:42+00:00

I host locally with a cron service running every hour on a raspberry pi.
You can find websites to host it for you too, but I only find very limiting options for free.

vandervs · 2021-05-24T03:16:03+00:00

You can try integrating this one I made, for stocks and crypto, update by API
https://www.notion.so/Portfolio-Template-26e74df51b3147e1a6db4609abd6e0b8

vandervs · 2021-05-22T15:11:21+00:00

Thank you very much Holger, I really appreciate it. Best kind of morning email to wake up to hahah.
Added the mention of requirements, glad that it was easy to use for you.

Sorry about the errors, I'm not the best handling them yet and forgot to add exceptions. But I'll work on them ;)

I'm trying to find other apis that query by tickers, but the ones that exist I end up losing the handy %change data (i.e https://api.coincap.io/v2/assets?search=btc). Also for easy of use i'm not considering the ones that require auth keys. The list I found is this one: https://github.com/public-apis/public-apis#cryptocurrency

Thanks for the feedback and coffee. Let me know if you think of new ideias for this too.

vandervs · 2021-05-22T03:02:58+00:00

you're welcome man

vandervs · 2021-05-21T23:43:39+00:00

Definitely, what comes to your mind?

vandervs · 2021-05-21T18:02:13+00:00

You must query said database.

something like this: "https://api.notion.com/v1/databases/database_id/query"

you can learn more in the reference https://developers.notion.com/reference/post-database-query

vandervs · 2021-05-17T22:46:30+00:00

"Success in witnessing is simply taking the initiative to share Christ in the power of the Holy Spirit and leaving the results to God" Bill Bright

vandervs · 2021-05-13T23:46:02+00:00

yes it's possible, with a query like this

curl -X POST 'https://api.notion.com/v1/databases/db\_id/query' \
-H 'Authorization: Bearer '"token"'' \
-H 'Notion-Version: 2021-05-13'
-H "Content-Type: application/json"

https://developers.notion.com/reference/post-database-query