Skip to content

abhagsain/wazirx-google-sheet-dashboard

Repository files navigation

Wazirx Google Sheet Dashbaord

Use Google Sheet to visualise your WazirX Portfolio

image

All the code is in the Google Sheet itself and also in this repository and if you use the SpreadSheet you own it so there are no privacy concerns.

But make sure you don't share the spreadsheet with your KEYS in it. (VERY IMPORTANT)

🗒 Step by Step Instructions

  • Go to this spreadsheet and make a copy of it. image
  • You would need API Key from your WazirX Account

Here's how you can get one. Visit WazirX Keys Section

image image

⚠️ Word Of Caution [IMPORTANT]

If you want to share the sheet with someone else, make sure you don't leave your API & SECRET_KEY in the sheet. That's why it's better to make a copy of it without your API and SECRET_KEY or Share the original spreadsheet instead

If your API or SECRET KEY gets compromised then the person will get access to your entire account and they can buy or sell any of your coins.

⚠️ If you think your API has been compromised then you can delete it from the WazirX Keys Section.

  • Once you get your API and SECRET_KEY. Paste it in the B2 column like this

image

Go to the hodlings page. (See at the bottom)

image

This showDummyData mean it would show random data for the amount column. Defaults to false i.e your actual amount would show up.

image

And you will see your account data. That is it 🥳.

image

😱 Is this safe?

Yes, it's safe because you own the code as the entire code is in the Google Sheet itself. As long as someone don't have access to your Gmail account or you don't share the Spreadsheet with your API Keys in it. You don't need to worry about it. But make sure your gmail account isn't owned/shared with someone else or not logged into a public computer.

If you want to see the code here's how you would do it.

image

And this is all the code

image

❓ Why I built this

WazirX doesn't have a dashboard to show coin allocation yet and I wanted to visually see in which coin I'm investing in the most (It's MATIC AND ETH btw 😛) with percentages. So I decided to use Google Sheet and build it myself

Why Google Sheet?

Because you can easily draw charts and that's exactly what I wanted.

🌝 Plug - My Side Project Coingaze

If you liked this you might want to checkout my other project ✨ Coingaze ✨.

A Web App where you can create custom price alerts and get notifications using Browser & Telegram. Over 500+ people are using it and there are currently over 700+ active alerts.

image

It also has Chrome Extension so you can create alerts right from the WazirX Website 🚀

extension-flow-coingaze

That's basically it

Liked this or found this useful? Connect with me on Twitter or LinkedIn

Let's have a chat :)

About

Use Google Sheet to Visualise Your WazirX Portfolio

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published