Thursday, July 26, 2018

Advanced aBOT calculator Google Sheets - Daily Compound Interest Calculator

Advanced aBOT calculator released :) you can download here and use freely.
Open the file, then download to your computer. NO MACROS USED, safe to use!
Open with excel 2013 or 2016. If you don’t have excel you can upload the file to your own google drive and open with google sheets to convert it.
THIS IS NOT INVESTMENT ADVICE NOR ARE THESE 100% CORRECT, IT JUST GIVES AN INDICATION ON HOW TO PROCEED AND IS BASED ON THE AVERAGE PROFIT OF ABOT, IT CAN FLUCTUATE DAILY
Current values in the cells are examples and can be adapted.


INSTRUCTIONS:
Fill in the grey cells/tables:
F7 “ARB IN WALLET”: current amount of ARBS in your wallet
K63 table “ARB BUYS” : fill in column 1 and 2: tokens bought from the exchange
K43 table “ARB SELLS TO ETH”: fill in column 1 and 2: tokens sold from the exchange
K11 table “INVESTMENTS ABOT”: fill in column 2,3,4 and 5. For withdrawls column 2 and 3 need to be NEGATIVE.
Column ‘action’ can be: 1 (deposit to abot), 2 (withdraw from abot to wallet), 0 (withdraw profits to arb wallet)
Column ‘active’ van be: 1 if that row is active in abot, put this to 0 if you stop your investment and withdraw them to wallet
G5 “PROFIT LAST 30 DAYS”: fill in profit last 30 days from the abot page
I5 “ETH VALUE”: fill in current ETH rate in USD
H7 “DOL TO EUR”: fill in current dollar to euro rate for our European friends
I7 “ARB ABOT PRICE”: fill in current abot arb price in USD
M7 “TAKEOUT PERCENTAGE”: fill in the amount of profits you wish to take out opposed to what you want to compound.

The sheet will the automatically populate all other cells and show you following information:
On which day to take out your profits based on the takeoutpercentage and when to reinvest
Shows you total profits and compounding over 2 years.
Shows you how many arbs you have in total
Shows your total eth value based on all available input
Shows you the average rate off all deposits to abot in dollar value
Shows you the amount of tokens you’ll receive when you stop abot ( DON’T GAME THE SYSTEM! Use the exchange if you want to swing trade)
And much much more…

https://drive.google.com/file/d/1yUAETn4rRiTQoDqN8pP0Z7smV1Ga2Stl/view


TIP: buy with your ETH or BTC ARB from Exchange and put them in aBOT, enable AUTO REINVEST and check here the profits: Daily Compound Interest Calculator

See also

 

No comments:

Post a Comment