Bitcoin Forum
June 27, 2024, 09:22:13 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Pool Api to CSV tool  (Read 216 times)
dude215p (OP)
Newbie
*
Offline Offline

Activity: 18
Merit: 0


View Profile
January 19, 2018, 10:10:49 AM
 #1

Gets data from mining pools every interval minutes and writes it to CSV file, along with current date and time.

This way, if you keep it running you can have a detailed timeline of your actual income.

I've made a small C# program (as I'm more proficient with that than with powershell) that gets data from pool's apis every 2 minutes. I've made it configurable too so anyone can use it.
You'll have to edit app.config (or PoolApiToCSV.exe.config in debug folder) for it to work for your wallet,(just replace the wallet address at the end of each API address). You can also use it for other APIs, just make sure you correlate measures with api addresses, and refer to each pool's api page (eg. https://www.ahashpool.com/site/api/ )

If you want to open the CSV with Excel and you still have the tool open, make a copy of the CSV file and open that as excel locks the file.

In order to make graphs in Excel, the most useful and easy thing is to select all data and insert a scatter X, Y graph, there you can compare your actual profits made on different pools (or anything else you have configured), by having the DateTime as your X axis, like that, even if you don't keep this tool running all the time or you change the interval, you'll still see relevant data.

Here's a github link:

https://github.com/dude215p/PoolApiToCSV
dude215p (OP)
Newbie
*
Offline Offline

Activity: 18
Merit: 0


View Profile
January 19, 2018, 03:38:14 PM
 #2

I have a 3x1070 Rig. I've run 3 instances of MegaMiner one for each card, pointing to Ahashpool, Zpool and HashRefinery

From this morning, this is what I have until now:
https://i.imgur.com/HK7k1XT.png
Boffinboy24
Newbie
*
Offline Offline

Activity: 24
Merit: 0


View Profile
January 21, 2018, 08:42:40 AM
 #3

I have a 3x1070 Rig. I've run 3 instances of MegaMiner one for each card, pointing to Ahashpool, Zpool and HashRefinery

From this morning, this is what I have until now:
https://i.imgur.com/HK7k1XT.png
Are you continuing your comparison? It is super useful! As a small miner the payout frequency is very low on ahp so I mine on zpool with LTC payout. Understanding the difference is helpful,as need to evaluate also if BTC fees would remove difference.
Boffinboy24
Newbie
*
Offline Offline

Activity: 24
Merit: 0


View Profile
January 24, 2018, 04:14:21 PM
 #4

Been testing this out and it works very nicely! Is there any way you could have it also monitor the running total / paid out total?

I was also still wondering how your comparison is going?
dude215p (OP)
Newbie
*
Offline Offline

Activity: 18
Merit: 0


View Profile
January 30, 2018, 03:18:57 PM
 #5

Quote
Is there any way you could have it also monitor the running total / paid out total?

Yes, just modify the config file like I said in the first post.

Quote
I was also still wondering how your comparison is going?

this was the last time I measured:

https://i.imgur.com/wDFRX0E.jpg

I the comparison once I reached payout thresholds for the pools the other, so I could mine only on ahash.
So Ahashpool seemed to be slightly ahead, by a small margin, but basically I think you can use whichever you like most. I find ahash more responsive, and has more miners than hashrefinery so I still use it.
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!