jgulick48 / nicehashprofitabilitycalculator

A quick GUI to monitor your profitability on NiceHash and store numbers in an sqlite db

Website for News!

Head over to https://www.hashstats.org/ for my blog with news on what I'm working on and more details about the releases.

NiceHashProfitabilityCalculator

A quick GUI to monitor your profitability on NiceHash and store numbers in an sqlite db

NiceHashWorkerMonitor

This is a logger program that interfaces with Excavator on each miner and saves the data to an sqlite database. I'm working on another app that is used to read this data and generate reports that you can export or view graphcs.

NiceHashStatsViewer

This is a graphing tool to see the logs that you have generated. I have 4 reports currenly each the Card and Rig levels and am working on adding more reports. Feel free to put in requests for what you would like to see and I'll try to prioritize various things based on demand.

Quick How To:

1. Download the files from the release at https://github.com/jgulick48/NiceHashProfitabilityCalculator/releases/

2. Extract them to where ever you want on each miner.

3. Have NiceHash v2+ running.

4. Run the NiceHashWorkderMonitor.exe on each miner and put in your Wallet Address and a nickname for the miner (doesn't have to be the same as on NiceHash)

5. Press the Start Button on the Monitor.

6. From any machine you can now run the NiceHashStatsViewer.exe to run various reports using your Wallet Address. You will want to change the default time that is listed to be able to view recent stats. Best to let the monitor log for 10-20 minutes first just so you have stuff to view.

7. Feel free open and issue if you find problems or want to see some features added. Issues will be moved/tracked at https://jira.threegm.com/projects/NPC/issues/

Donation Addresses:

BTC: 1DnD4an89ixaaG8HC5jnh4x6W3ttoZv2R1

LTC: LM4pgHRovVgnyQrtjyE28aysvgeqMTobyR

ETH: 0x21d91C3D033b3C428bae69b628d83B974C0B2B5A

nicehashprofitabilitycalculator's Issues

Unable to update from Viewer

As you can see the Viewer notifies me that there is a new update ready.
When I click the link, the Updater opens and the Viewer closes down. I just get an error message that it can't update because the Viewer is still running even it is closed.

Error #47

Viewer app froze and got error #47.

[ER] Add electricity cost calculations

In wide parts of the world electricity is not as cheap as in the US or even free.

For instance where I live I have to pay 0.02611 Euro cent per kWh.

Hence it is important for me to know, if it is more efficient to limit the GPU TDP to 65% and get a decrease in hashing power, or if it is better at 85% with increased power consumption (and electricity bill) and hash rate.

I thought of having the ability to enter the costs per kWh somewhere (or just set them in a config file for the beginning) and that the Live views of Rig Stats and of course the Exports contain calculations. In addition I need to be able to add the consumption of the rest of the mining rig (i.e. my computer has a power consumption of about 80W when running in idle modus. When I am mining with both cards and 65% TDP on each, the cards are having a consumption of 223W. But my computer in total has a consumption of 305W. Hence I need to take the 305W into calculation about efficiency.

In the live view I can see my estimated earnings and the power consumption of the cards. There it could be possible to add information about power consumption per day and costs per day.

Error when pressing the run report button (happens with both MySql and sqlite)

MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '94987 and TimeRecorded <= 1515440305,92982 group by R.WorkerName, ROUND(cs.TimeR' at line 1
bij MySql.Data.MySqlClient.MySqlStream.ReadPacket()
bij MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
bij MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
bij MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
bij MySql.Data.MySqlClient.MySqlDataReader.NextResult()
bij MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
bij MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
bij System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
bij System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
bij System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
bij System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
bij NiceHashStatsViewer.DataHelper.MySQLHandler.GetDataTableFromSQL(String sql) in C:\Users\jeremy.gulick\Documents\NiceHashProfitabilityCalculator\NiceHash Profitability Tracker\NiceHashStatsViewer\DataHelper\MySQLHelper.cs:regel 20
bij NiceHashStatsViewer.DataHelper.DataBaseHandler.GetDataTableFromSQL(String sql) in C:\Users\jeremy.gulick\Documents\NiceHashProfitabilityCalculator\NiceHash Profitability Tracker\NiceHashStatsViewer\DataHelper\DataBaseHelper.cs:regel 18
bij NiceHashStatsViewer.Reports.RigReports.RunRigStatReport(String stat, String WalletAddress, DateTime start, DateTime end, Int32 resolution, Boolean sum) in C:\Users\jeremy.gulick\Documents\NiceHashProfitabilityCalculator\NiceHash Profitability Tracker\NiceHashStatsViewer\Reports\RigReports.cs:regel 57
bij NiceHashStatsViewer.Reports.RigReports.RunRigStatAndGenerateChart(String WalletAddress, DateTime start, DateTime end, Int32 resolution, CartesianChart chart, String MetricColumn, String YKey, String LegendColumn, Boolean sum, String numberFormat) in C:\Users\jeremy.gulick\Documents\NiceHashProfitabilityCalculator\NiceHash Profitability Tracker\NiceHashStatsViewer\Reports\RigReports.cs:regel 20
bij NiceHashStatsViewer.NicehashStatsViewer.RunRigStatReport(Int32 resolution) in C:\Users\jeremy.gulick\Documents\NiceHashProfitabilityCalculator\NiceHash Profitability Tracker\NiceHashStatsViewer\NicehashStatsViewer.cs:regel 53

[BUG] Graph not showing up with remote access

I used your tool a few days ago, when I was still at home and I could see the graph in the Rig Stats and Card Stats normally.

Now I am on vacation, want to occasionally check how it is going.

For remote access I used TeamViwer and also Google Chrome Remote Access.
With both applications I get the same result.

I start a Graphs view. The windows stays empty, but when I mouse over the window, I see the little info pop ups (the same I asked on Reddit to show information about the algorithm)

For better understanding, here a screenshot showing what I mean:

Not sure where exactly this is coming from, as it was working fine when sitting directly in front of the computer.

[ER] Monitor App auto loads settings and starts

Hi,

I would like to propose an enhancement request.

The Monitor should save the settings and does not ask for wallet address, worker name and storage type everytime. In addition the monitor should automatically start monitoring once it started.

Reason: I would like to put the monitor app into the autostart. So when my PC is started it automatically starts the application with the saved settings and starts monitoring.
Otherwise everytime the computer is booted up, I have to manually start the app, chose sotrage type and start monitoring.
This is especially helpful for rigs in remote destinations.

Maybe store this information in a simple config file or the monitoring app capable of dealing with command line variables?

Is there a difference for us users between SQLite and MySQL storage?

[ER] App starts up again after update

I think it would be great if the app started back up after you run the updater from the link in the monitor or viewer.
Maybe even add that the app updates automatically?

.net framework issue

https://imgur.com/a/UYQTq

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at Monitor.Monitor.UpdateCardStatsView(Boolean UpdateFriendlyName) in C:\Jenkins\workspace\NiceHashProfitabilityCalculator_Beta_Build\NiceHash Profitability Tracker\Monitor\Monitor.cs:line 179
at Monitor.Monitor.bgwCardStatsRefresh_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e) in C:\Jenkins\workspace\NiceHashProfitabilityCalculator_Beta_Build\NiceHash Profitability Tracker\Monitor\Monitor.cs:line 141
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2115.0 built by: NET47REL1LAST
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

Monitor
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Users/Seth/Downloads/NiceHashStatsCalculatorDownloader-1.0.0.69/Monitor.exe

System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2110.0 built by: NET47REL1LAST
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2110.0 built by: NET47REL1LAST
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2046.0 built by: NET47REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2046.0 built by: NET47REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2117.0 built by: NET47REL1LAST
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2612.0 built by: NET471REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

MySql.Data
Assembly Version: 6.10.5.0
Win32 Version: 6.10.5.0
CodeBase: file:///C:/Users/Seth/Downloads/NiceHashStatsCalculatorDownloader-1.0.0.69/MySql.Data.DLL

System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2102.0 built by: NET47REL1LAST
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll

System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2046.0 built by: NET47REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll

System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2046.0 built by: NET47REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll

System.Management
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2102.0 built by: NET47REL1LAST
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Management/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Management.dll

Microsoft.CSharp
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2046.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.CSharp/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.CSharp.dll

Newtonsoft.Json
Assembly Version: 10.0.0.0
Win32 Version: 10.0.3.21018
CodeBase: file:///C:/Users/Seth/Downloads/NiceHashStatsCalculatorDownloader-1.0.0.69/Newtonsoft.Json.DLL

System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2046.0 built by: NET47REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll

Anonymously Hosted DynamicMethods Assembly
Assembly Version: 0.0.0.0
Win32 Version: 4.7.2115.0 built by: NET47REL1LAST
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll

System.Dynamic
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2046.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Dynamic/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Dynamic.dll

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

ER Implement an avarage value for the different reports

I have noticed that the earnings, and other values, have some spikes and changes every day.
Would it not be a more acurate number if we had avarage earnings and watts per 12 or 24 hour?

[BUG] Live View of Rig and Cards has wrong Wallet address

Hi,

The live view of the Rig Stats and the Card Stats has the wrong wallet address filled in by default. I assume it is your own? It is filled with 37s2ZBNJ64sa1bkYh3HWAkncJSxcXoBzvn, although the Graphs section has my correct wallet address filled in.

Steps to replicate issue:

• Start monitoring app. Put in any other wallet address except 37s2ZBNJ64sa1bkYh3HWAkncJSxcXoBzvn.
• Start the Monitor
• Start the Viewer app. The Graphs section of Rig Stats and Card Stats do have the correct wallet

Expected behaviour: Live section also shows the entered wallet address.

Actual behaviour: Live view of wallet address 37s2ZBNJ64sa1bkYh3HWAkncJSxcXoBzvn is shown. Has to be changed manually

How to completely removed data?

I would like to completely reset settings and collected data.

I tried delete the Data folder. Did not work
I completely removed the NH Stats folder, redownloaded the latest version. Did not work.

Is there a way for me as a user to remove data and settings?

Error in SQL Syntax

Hi,
I tried using this StatsViewer but I can't get it to work.
I got the Monitor to start. I got a few errors here too, but it worked eventually.
When I try to start the StatViewer, I am getting an error I don't understand.

Some of the text are in norwegian..
Is this because the monitor haven't run for long enough?
I have tried it both on the mining computer, and on an external computer.

[Bug] Monitor App: Edit Rig not working

The "Edit Rig" Button in the monitor app is not working. Clicking on it, does nothing.

Do I remember correctly that this button opened a little window, where wallet address and workername could be edited?

The reason for #43 is: Some days ago, I renamed the worker. And now in the Exports both workers (the old name of the worker and the new name) show up with the same data.

not refreshing !

Nothing is changed !
I'm running it since when its downloaded ! and all what I see is some "double" numbers