Something somebody recommends a dapps to you, which at first sight is great but it is hard to find use case for it. But suddenly it dawns to you how the tool can be a great addition to the tool set I am using.

# Steemdetective
![p0l0k847ea.png](https://img.esteem.ws/p0l0k847ea.png)

[Steemdetective](https://steemdetective.com/) does allow you to have a detailed look at some info at the steem blockchain.
From their website: Steemdetective is a site which allows you to download all your transactions made on the Steem blockchain and process them. 
For the moment the max number of transaction which for a user can be downloaded is capped at 100K.

# MagicDice
I have been playing some [Magic Dice](https://magic-dice.com/?ref=fullcoverbetting) and I am often asked I am making a profit or not.
Steemdetective can be used to get this answer!

Go the to the website of steemdetictive and fill in your user name at the upper left corner!
![luj1w6juhq.png](https://img.esteem.ws/luj1w6juhq.png)

And click on the red button. A few moments later you will see how many transaction your account has made on the steem blockchain. And click on Ok.

For me this is around 72128.

![mzj248ho5z.png](https://img.esteem.ws/mzj248ho5z.png)
The next thing is to click on the tables in the left menu.

Next select transfer from the table list.
![v750z49tfm.png](https://img.esteem.ws/v750z49tfm.png)

And download the selected data.

Now you have all the data about Steem and SBD transfer in an excel sheet.
Now it is time to add a filter to the excel sheet.

## Outgoing transfers
To have an overview to all your outgoing transfers to Magic Dice, you will have to select in the From filter your username, in the To filter the account of Magic Dice.
Now you do have an overview of all your outgoing transfers to Magic Dice.
But we are not there yet!
Copy all the information from the filter into a new tab and add a new column if you were using both Steem and SBD.

## Incoming transfers
These could be multiple things. Information about winning or losing bets. Delegation rewards, referral rewards and so on.

So change in the filter to From field into @Magicdice.
Also copy the results of this filter in the same tab as the outgoing transfer beside the outgoing transfers.

## Collecting the results
Now we do have a tab in excel in which. The problem we still have is that if you have both bet with Steem and SBD.

![n0ixbsmdf9.png](https://img.esteem.ws/n0ixbsmdf9.png)


So we have to some magic. You will have to extract this information and put it into a new cell.


I did use the following formula in column Steem/SBC
=if(right(C2;3)="eem";"Steem";"SBD")
If you run this you will have to copy the result column and past it again as values. We will remove the Steem and SBD from the amount column to be able to add it up!

# The results

![l3ubsi0aox.png](https://img.esteem.ws/l3ubsi0aox.png)


I could do the same for Steemmonsters, but I am too afraid for the results there :) I do know that at steemmonster I am running at a big loss.

Feel free to use my referral ID if you want to try out [MagicDice](https://magic-dice.com/?ref=fullcoverbetting). 

Or just click on the banner :)

<center>
<a href="https://magic-dice.com/?ref=fullcoverbetting"><img src=" https://steemitimages.com/0x0/https://cdn.steemitimages.com/DQmardXbmhqGedq6vtJStwsxwgm7XvAy6DeSxpJXRhDieXa/magic-dice-header.png "></a></center>

Also don't forget that you will earn 25 Magic for each steem wagered. When they paid out their dividens to the magic holders, you will get some dosh back!

Cheers,
Peter

<center>
<b>Sports Bettors On Steemit Unite and Join the SBC !</b><a href="https://steemit.com/@sbcbot"><img src="https://steemitimages.com/DQmUQ4UnjJjsiWZFVP93FD6vEDdmSnRx1kK6MV1T5Mx6qt6/banner.jpg"></a></center>
 
<center>![PHC-Footer-05.gif](https://cdn.steemitimages.com/DQmZMTckzqpfBShZSELLFNotjm43vJfjg79Ynz4ndB3i86a/PHC-Footer-05.gif)</center>