LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 19th 18, 09:56 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: May 2018
Posts: 1
Default Need help with finding a function

Hello there,
I have been working on a google sheet in which I compare different bitcoin (cloud) mining offerings. In the sheet I try to make use of compound growth rates to make estimations of an expected yield in the future. I have been looking for a formula/function that automates this process but I have been unable to do it for a very long time I have 25 usd in cryptocurrencies available for the person that helps me with the function.

The comparisons can be found in this google sheet:

To give a bit of context information: When you buy a bitcoin mining contract, you essentially buy mining power which is expressed in Hashrate per second. If you open the sheet and go to "cloudmining advanced" you find that the price of 1 Terrahash per second (1TH/S) is 80 usd which is 0.017 bitcoin(G10) at the time of writing. The current daily returns for this 1TH/S is about 0.00002 btc per day (G11) which gives you a break even point of 539 days (G12).

The problem is that this 0.00002 btc per day will decrease with an x percentage per day. I calculated/estimated this daily compound growth rate, which can be found in cell B21. From row 32 downwards you can find my calculations of future daily incomes using this percentage with a compound growth rate calculation (=G$11*(1+'Diff vs Price'!$D$7)^$B32).

I used these numbers again to calculate the total profit after 365 (G23) and 730 (G24) days. As you can see, currently non of the cloudmining companies will ever give you a break even point according to my calculations.

However at some point when btc price goes up they will give you a break even point (they did until around February). Currently, to find the break even point I would fill in a total amount of days using a sum if function, and keep changing this amount of days until the total profit after this amount of days is higher than the investment (Cell g20). However this requires me to manually do this for all the different contracts. As the prices and difficulty keeps changing, this would be a lot of work.

There must be a function that automates this process. I know it has probably something to do with the SIGMA sign. However I am no pro in maths nor know how to use the sigma sign in google sheets. If anybody knows the function I am looking for or knows how to solve this problem (perhaps I don't even need the tables below the calculations) you would help me a lot! I also have 25 usd available for the person that helps me, send in cryptocurrency of choice haha.
If anything is unclear please ask so i can further explain.

Thanks alot!

  #2   Report Post  
Old May 21st 18, 12:59 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,015
Default Need help with finding a function

You do realize that Google Sheets IS NOT EXCEL, right?

Therefore, the built-in features/functions it supports are entirely generic to
the spreadsheet control Google Sheets uses. Luckily, though, it does have a
very comprehensive userguide where you can lookup its inherent functions along
with how to use them. Start there...


Free usenet access at
Classic VB Users Regroup!

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Having trouble finding the right function g New Users to Excel 2 June 4th 06 11:37 AM
Offset function with nested match function not finding host ss. MKunert Excel Worksheet Functions 1 March 21st 06 10:46 PM
function for finding a value! Simon Lloyd Excel Worksheet Functions 5 September 9th 05 02:44 PM
Finding the right most cell as a function Andrew[_40_] Excel Programming 3 January 11th 05 07:27 AM
Finding Function Tony Excel Programming 2 October 31st 03 08:10 PM

All times are GMT +1. The time now is 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017