Showing posts with label Google Sheets. Show all posts
Showing posts with label Google Sheets. Show all posts

Wednesday, November 7, 2018

Advanced aBOT calculator Google Sheets 7

UPDATE V7 - 7 Nov 2018!! - ABOT AUTOREINVEST TRACKER

Change Log:
* Added the ADVANCED Compound WHAT-IF Calculator
* bugfixes

Open the file, then download to your computer. NO MACROS USED!
Open with excel +2013.
If you don’t have excel:upload to your google drive and open with google sheets
(check the known issues on the documentation tab)

Track active investment, Daily Profits, overall profits, exchange trades, auto reinvest earnings
EUR/USD conversion
ADVANCED LIVE and PREDICTIVE What-if analysis
And much more!

Read the documentation tab for instructions or PM me on telegram.

https://drive.google.com/file/d/1IJ9h-nl6QpakQX8m1yPImCtUGFWbKIxm/view?usp=sharing

Tuesday, October 23, 2018

Advanced aBOT calculator Google Sheets 6 an 6.1 - Daily Compound Interest Calculator

UPDATE V6 - 20 Oct 2018!! - ABOT AUTOREINVEST TRACKER

Change Log:
* bugfixes
* added memberships to exchange sheet
* added reinvest option to abot transactions sheet
* Added formulas in the what if analysis sheet to take into account reinvest earned profits.

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 ( can give formula issues if you use google sheets)

The excel will automatically populate all other cells and show you following information:
Track active investment
Track Daily Profits
Track overal profits
Track buy and sells of ARB
Track auto reinvest and affiliate profits
Complete overview on earnings on a daily basis fo up to 4 years
Track global profits
EUR / USD conversion for our European friends
Average entry to abot price
Average buy and sell price of arbs on the exchange
Keeps track of ABOT withdrawls/deposits on date
Automatic population based on dates
WHAT IF analysis
And much more!

UPDATE V6.1 - 2 Nov 2018!! - ABOT AUTOREINVEST TRACKER

Change Log:
* bugfixes to arb tracker sheet to include multiple abot transactions on 1 day.
* fixed spelling mistakes


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 ( can give formula issues if you use google sheets)

The excel will automatically populate all other cells and show you following information:
Track active investment
Track Daily Profits
Track overal profits
Track buy and sells of ARB
Track auto reinvest and affiliate profits
Complete overview on earnings on a daily basis fo up to 4 years
Track global profits
EUR / USD conversion for our European friends
Average entry to abot price
Average buy and sell price of arbs on the exchange
Keeps track of ABOT withdrawls/deposits on date
Automatic population based on dates
WHAT IF analysis
And much more!

https://drive.google.com/file/d/1IJ9h-nl6QpakQX8m1yPImCtUGFWbKIxm/view?usp=sharing 

    Tuesday, September 4, 2018

    Advanced aBOT calculator Google Sheets 4 (update 4 + 5 )



    UPDATE V5.4 - 18 Sep 2018!! - ABOT AUTOREINVEST TRACKER

    Change Log: bugfixes on abot sheet, expansions arb tracker, more info

    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 ( can give formula issues if you use google sheets)

    The excel will automatically populate all other cells and show you following information:
    Track active investment
    Track Daily Profits
    Track overal profits
    Track buy and sells of ARB
    Track auto reinvest and affiliate profits
    Complete overview on earnings on a daily basis fo up to 4 years
    Track global profits
    EUR / USD conversion for our European friends
    Average entry to abot price
    Average buy and sell price of arbs on the exchange
    Keeps track of ABOT withdrawls/deposits on date
    Automatic population based on dates
    WHAT IF analysis
    And much more!

    https://drive.google.com/file/d/1IJ9h-nl6QpakQX8m1yPImCtUGFWbKIxm/view?usp=sharing
     
     older versions here ..

    UPDATE V4.0 - 03. Sep 2018!! - ABOT AUTOREINVEST TRACKER
    Short tutorial on how to use the Arbitraging Auto Reinvest trackercan be downloaded here:
    https://drive.google.com/file/d/1IJ9h-nl6QpakQX8m1yPImCtUGFWbKIxm/view



    UPDATE V4.0 - 03. Sep 2018!! - ABOT AUTOREINVEST TRACKER
    Advanced abot auto reinvest tracker V4 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, USAGE AND INVESTMENTS ARE YOUR RESPONSIBILITY ONLY!
    Current values in the cells are examples and can be adapted.

    Sheet 1 : a guide and introduction
    Sheet 2 : the actual tracker
    Sheet 3 : Performance Table
    The sheet will the automatically populate all other cells and show you following information:
    Track active investment
    Track Daily Profits
    Track overal profits
    Track buy and sells of ARB
    Track auto reinvest and affiliate profits
    Complete overview on earnings on a daily basis fo up to 4 years
    Track global profits
    EUR / USD conversion for our European friends
    Average entry to abot price
    Average buy and sell price of arbs on the exchange
    Keeps track of ABOT withdrawls/deposits on date
    Automatic population based on dates
    And much more! 


     

    UPDATE V5.0 - 05. Sep 2018!! - ABOT AUTOREINVEST TRACKER - WHAT IF analysis
    Advanced abot auto reinvest tracker V4 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, USAGE AND INVESTMENTS ARE YOUR RESPONSIBILITY ONLY!
    Current values in the cells are examples and can be adapted.

    Sheet 1&2 : a guide and introduction
    Sheet 3 : the actual tracker
    Sheet 4 : Performance Table
    The sheet will the automatically populate all other cells and show you following information:
    Track active investment
    Track Daily Profits
    Track overal profits
    Track buy and sells of ARB
    Track auto reinvest and affiliate profits
    Complete overview on earnings on a daily basis fo up to 4 years
    Track global profits
    EUR / USD conversion for our European friends
    Average entry to abot price
    Average buy and sell price of arbs on the exchange
    Keeps track of ABOT withdrawls/deposits on date
    Automatic population based on dates
    And much more!



    UPDATE V5.3 - 14 Sep 2018!! - ABOT AUTOREINVEST TRACKER

    Change Log: bugfixes, expansions arb tracker, more info

    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 ( can give formula issues if you use google sheets)

    The excel will automatically populate all other cells and show you following information:
    Track active investment
    Track Daily Profits
    Track overal profits
    Track buy and sells of ARB
    Track auto reinvest and affiliate profits
    Complete overview on earnings on a daily basis fo up to 4 years
    Track global profits
    EUR / USD conversion for our European friends
    Average entry to abot price
    Average buy and sell price of arbs on the exchange
    Keeps track of ABOT withdrawls/deposits on date
    Automatic population based on dates
    WHAT IF analysis
    And much more!

    https://drive.google.com/file/d/1IJ9h-nl6QpakQX8m1yPImCtUGFWbKIxm/view?usp=sharing

    Monday, July 30, 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

    Thursday, July 26, 2018

    Advanced aBOT calculator Google Sheets - Daily Compound Interest Calculator 1

    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


     

    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

     

    Monday, July 23, 2018

    Advanced aBOT calculator Google Sheets - Daily Compound Interest Calculator - 2

    [Forwarded from Crypto Shinobi]
    UPDATE !! - ABOT AUTOREINVEST TRACKER
    Advanced abot auto reinvest tracker 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, USAGE AND INVESTMENTS IS YOUR RESPONSIBILITY ONLY!
    Current values in the cells are examples and can be adapted.

    Sheet 1 : a guide and introduction
    Sheet 2 : the actual tracker
    The sheet will the automatically populate all other cells and show you following information:
    Track active investment
    Track Daily Profits
    Track overal profits
    Track buy and sells of ARB
    Track auto reinvest and affiliate profits
    Complete overview on earnings on a daily basis fo up to 2 years
    Track global profits
    EUR / USD conversion for our European friends
    Average entry to abot price
    Average buy and sell price of arbs on the exchange
    and much much more!!

    https://drive.google.com/file/d/1cn5Ig3GwocmwCoOhxUei9z0Fzc0ldC6y/view?usp=sharing


    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

    Wednesday, June 27, 2018

    Advanced aBOT calculator Google Sheets - 3

    UPDATE V3.1 - 13. Aug 2018!! - ABOT AUTOREINVEST TRACKER
    Advanced abot auto reinvest tracker V3 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, USAGE AND INVESTMENTS ARE YOUR RESPONSIBILITY ONLY!
    Current values in the cells are examples and can be adapted.

    Sheet 1 : a guide and introduction
    Sheet 2 : the actual tracker
    The sheet will the automatically populate all other cells and show you following information:
    Track active investment
    Track Daily Profits
    Track overal profits
    Track buy and sells of ARB
    Track auto reinvest and affiliate profits
    Complete overview on earnings on a daily basis fo up to 2 years
    Track global profits
    EUR / USD conversion for our European friends
    Average entry to abot price
    Average buy and sell price of arbs on the exchange
    Keeps track of ABOT withdrawls/deposits on date
    Automatic population based on dates
    And much more!

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