Thriftinkid - How to Track Your Incognito Rewards Through Google Sheets

If you would like to track your Incognito nodes or your PDEX trading through google sheets, you have come to the right place. Just download the google sheet below and follow the readme instructions.

As always, I added some random data, so you can see what’s going on in all sections of the sheet. Please let me know if you find any errors, or if you would like to see any features added. Below are all the current features. Hope this helps!

From your friendly neighborhood @Thriftinkid

Side note, you now need to click yes in the link below. It is strictly to count downloads. No other information is collected or stored.

INCOGNITO EARNINGS TRACKER V6
Source Code

  1. PDEX Trading - Track your current trading balances on here in USD, EURO, or AUD.

  2. Node Tracking Data - Track up to 20 Nodes at once

    1. Current Node Status (w countdown to next random selection)
      Waiting to be selected
      About to Earn Rewards
      Earning Rewards
      Node Offline
    1. Total Number of Earnings
    1. Average Days Between Earnings
    1. Days Since Last Earning
    1. Earn Total
      PRV Earn Total
      USD Earn Total
    1. Earn Average
      PRV Earn Average
      USD Earn Average
    1. ROI
      ROI Current
      ROI Year Projection
      *8. Total number of nodes on the network
  1. INVESTMENT DATA
    1. Total initial investment
    1. Current accrued interest
    1. Total current investment
    1. ROI
      ROI Current
      ROI Year Projection
  1. Conversion Rates - Current PRV & USD rates for any coin. You can also compare two coins to each other.

  2. Investment Pools - Get the current total liquidity & volume of all pools, or you can select individual pools.

  3. CHARTS

  1. PRV 30 Day Price History & Forecast (Data in 6 hour View)
    This is not intended to be portrayed as financial advice, and I in no way guarantee it’s accuracy. Use at your own risk
  2. Extended PRV Price History & Forecast
    This is not intended to be portrayed as financial advice, and I in no way guarantee it’s accuracy. Use at your own risk.
  3. Weekly Earnings Chart (I added all 20 nodes. Remove if you have less)
  4. Monthly Earnings Chart (I added all 20 nodes. Remove if you have less)
  5. Total Node Weekly Earnings Chart (I added all 20 nodes. Remove if you have less)
  6. Total Node Monthly Earnings Chart (I added all 20 nodes. Remove if you have less)
  1. NODE MONTHLY ROI
  1. Node monthly earn totals
  2. jServer monthly expenses
  3. Monthly ROI
  4. Monthly APY
  5. Total Node ROI Average
  6. Average Monthly PRV Earnings
  7. Average USD Earnings
9 Likes

@Odin A newer version was released, so old copies were removed. You can get it here.

1 Like

it looks promising. But what is this google form? What i have to download and why? I don’t understand

@Bibi, I am trying to get this google sheet added to the builder rewards vote for this month. @Ducky informed me that there needs to be a certain amount of users who use it. The form is simply a way to track how many people are using it, since i can’t track downloads directly from the Google sheet. Nothing more. No data is collected other than the amount of people who clicked yes to view and download the Google sheet.

1 Like

I see. Okay!

IMG_20200914_095519

So We can see Incognito PRV needs Reward? Good Work. :+1:

I’m not sure I understand @Mizan. The 1st image you posted is the 30 day price history and forecast of actual PRV. The second image is the rewards tab from your nodes. They are calculated and show up in the charts below the history chart you posted. If you have any questions or would like to see anything added, please feel free to let me know!

1 Like

Hey all, The earnings tracker made the list for builder rewards this month. If you are enjoying using it, show some love by voting for it here. https://we.incognito.org/t/september-user-poll-a-roll-call-of-the-community-products/6271

September voting is coming to a close soon. If you are currently enjoying using the tracker, please show some love and send your September voting token the trackers way!

The update to the incognito rewards tracker is here! Have you ever wondered if you would’ve earned more in a month if you left your PRV in provide instead of staking your own node? Well now you can find out! There is a new tab called “NODE MONTHLY ROI”. This section will pull your earnings from all nodes you are tracking and show you a month by month return on your investment. Just pop in the number of nodes you are currently running in any given month, and the google sheet will do the rest. You can see if you made over or under the current 28% APY that provide is offering. This section will also show your average APY across all months, average PRV earned, and USD conversion. If you are currently running vnodes with @fitz_fiat and the jServer team, you now have a section to add your weekly expenses on the “DEPOSITS_WITHDRAWLS” tab. The fees will automatically be applied on the “NODE MONTHLY ROI” tab. If you are interested in running a virtual node, I recommend checking out jServers. They just lowered their fees to 2.2 USDC per week, and offer even bigger discounts for running multiple nodes. As always, please feel free to let me know if you find any errors, or if you would like to see a feature added. Sincerely, your friendly neighborhood @Thriftinkid

1 Like

Voting for builder rewards is out for October. If you are enjoying the Node Earnings Tracker, please show some love and vote for it.

2 Likes

Welcome to November everyone! We have 3 changes to the google sheet this month:

  1. There is a new section on the Deposits/Withdrawal tab. If you have a lot of nodes you are tracking, your list might be getting long in your entry columns. Now you can simply choose the node you want, and enter the amount it earned. Then, just hit submit. The sheet will automatically add it to your list with a timestamp. No more need to scroll down to the bottom of the page!

Screen Shot 2020-11-18 at 9.54.30 AM

  1. The new provide APY’s have been updated to reflect the new rates
  2. Cleaned up source code on the back end to help sift through the code.

As always, if you find any errors, or have anything you would like added, please let me know! Sincerely, your friendly neighborhood @Thriftinkid

2 Likes

Hey guys,

November builder’s vote is upon us! Voter tokens have been distributed to Trust Level 3 members only this month. If you are enjoying the Earnings Tracker, please show some love by voting for it here!

2 Likes