I am aware that tools such as this one and this one exist to calculate estimated mining profits. I would like to essentially recreate these in Excel (with perhaps a few additional features).

Fileds to use: Hash rate, power, power cost, difficulty, block reward, pool rejects, pool fees, XMR/fiat, and hardware costs.

Ideally, I would then use this information to estimate mining profits in the future (6 months, 1 year, 2 years, 3 years, etc) using the reward curve and projecting a difficulty over time. It would also be cool to mess around with the price of Monero over time, for example assuming the price will increase 5% a month on average or something like that. I want to be able to manipulate the variables to compare profit possibilities.

Does anyone have any thoughts of how to do this? I can make an Excel document, but I do not know what calculations to put into Excel.

2 Answers 2


I would do this in a couple parts:

1.) First of all review how you would integrate an API feed into Excel:

2.) You'll need access to a real-time API that has the current traded value of the currency.

3.) Finally you'll just need to calculate the the hash rate to XMR conversion.


Specific to Monero, I came across this Google Sheets based solution you may find as an alternate or base for ideas.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.