Bitcoin Forum

Table of content:

• Information (#post_information)
• Features (#post_features)
• Upcoming features (#post_WIP)
• Price (#post_price)
• Ordering the spreadsheet (#post_order)
• Tutorial (#post_tutorial)
• Preview (#post_preview)
• Notes (#post_note)

Information:
This spreadsheet was made to work with Poloniex's trading history export (https://poloniex.com/exportTradeHistory). The spreadsheet automatically does all calculations and you only have to input your data export. The rest is done automatic.

---

Features:
Shows 2 different estimated earnings.
 The current price of the market, as a way to display "What would I get if I were to sell everything now"
 The Last Sell Price, which tries to display what you earned on all closed trades.
Sorts the trading stats according to one of the 2 earning types.
Graphs with your earnings over a period with your BTC pairs. This is the same algorithm as Last Sell Price.
Minor stats like, Volume in BTC and the local currency, Bought and Sold of local Altcoin and more.
The sheet can change the interface of the BTC stats to your currency.
All 4 pairs from Poloniex is separated for easy overview.
Data input as raw .csv.
Unlimited data uploads.
No API requirement.
Help page with setup instruktions, including a video and introduktion to the features in detail.
Fast support via Discord or Telegram.

---

Upcoming features:
Portofolio overview.
Deposit and Withdraw history intergration.

---

Price:
One time fee of 0.05 BTC will be paid to buy the spreadsheet source. This includes all future updates.
You can use an Escrow if you decide, but you are responsible for all fees.

---

Ordering the spreadsheet:
Send 0.05 BTC to 1AZ7exdLPDaLrJrYDeTvUzheqQKR5RF6Z. (QR code (http://005.frilledshark.com) & Open Wallet (bitcoin:1AZ7exdLPDaLrJrYDeTvUzheqQKR5RF6Z?amount=0.05)) Mention the transaction ID in a message to me. Otherwise, catch me on Telegram or Discord and we can chat live. (Other contact info)  (https://bitcointalk.org/index.php?action=profile;threads;u=558148)

You will be sent a link to the video for setup and a link where you can get the spreadsheet source from.

---

Preview:

---

Notes:
Selling of the spreadsheet is prohibited, unless allowed by me. If redistributed, you will lose access to all future updates, unless a fee is paid to access it again. This fee is set by FrilledShark

The spreadsheet is updated to version 1.4.1.
This update includes a lot of bug fixes, which was introduced by the seperation of pairs.

If you got any questions, send me a message.

@FrilledShark
Great spreadsheet stats for Gunbot trades!
Any chance of reworking it to download trades via polo API automatically refreshing itself instead of manual download of trading history ? I would be willing to pay the higher price for it, if it supports auto trade downloads via polo API, and I bet other gunbot users would also do so.
Thanks for reply.

I don't think it is possible to make the spreadsheet download the trade history. In a case where it were possible, many people would have to download more then 5000 trades. Something Poloniex isn't happy people doing with their API.

It would also make the API insecure. It could be hidden (Which would make ii unable to access for people without edit access, but if people know very little about Google sheets they could risk sharing their API key and secret. This could be solved with a video tutorial.

If anyone got a solution, I can offer a bounty of 0.05 BTC. Even more if it is an elegant solution.

---

Spreadsheet is version 1.4.2.
Minor bug fix. The dates were 1 trade off, which forgets the first trade ever made.

---

If you want to buy the sheet during the next couple days, contact Gunthar or Henkkaa

Henkkaa
https://bitcointalk.org/index.php?action=profile;u=938374

Gunthar
https://bitcointalk.org/index.php?action=profile;u=817682

Edit:
I'm back

Where is the preview?

The spreadsheet is widely used by buyer of the GunBot. I will therefore quote one of Gunthar's messages:
The above is users of the GunBot group using the spreadsheet in conjunction with their bot. You will be able to preview the spreadsheet there.
Sorry for the lack of previews in the main post.

I'd be interested in this spreadsheet you have.
How much and if you can guide me on how to use this inconjuction with the gunbot then it would be well appreciated and you have got yourself a sale to me. ;D

Sorry for the late reply.
You don't have to do anything other then upload the data. The spreadsheet is 100% compatible with GUNBOT.

---

Update 1.4.5(.1):
Google changed the way 1 function works. Updated the sheet to counteract the change.
(.1)
Excluded Settlements with "Exclude Margin Trades."

This means 1.4.4 does not support timeframes. Use the link provided when you bought the sheet or contact me for a new.

Can the sheet predict future profits if things were to go on like in past? Or could you add such a feature please?

The spreadsheet is not able to do it currently. It can display your past profits/losses with graphs, both on pairs and daily profits.

I can add dumb future estimation with an uncertainty degree.
 If you buy the spreadsheet and find a couple other, then I can add it.
 Or find someone else going to buy the spreadsheet and convince him to buy the spreadsheet if the feature gets added.

Well, this sounds very promising. You did a nice job here!
In potention a money making machine!

Bought it already. :)

Works great, bought it weeks ago and it works just fine for trading. Maybe better than services like cointracking and so forth for actual profit valuation.
Big vouch for OP.

What is the difference between "Total E P/L" and "Withdraw now"?

Could you please add a field "Since"?

Total Estimate Profit/Loss
The estimated profit/loss on closed trades.

Withdraw now
The profit/loss you can withdraw now. It is your current earnings if you were to sell everything.


No, as I can't refer when "Since" begun.
Look at earnings vs time to see the difference between dates.

The date of the very first trade?

Yes, but that would just be the earnings right?

I would find this useful under stats as well. Perhaps by config?

Can this be used on bittrex and kraken with gunbot too?

Only Poloniex right now.
It works excellent with GunBot.

This is still 0.05? $100? I'm definitely interested, but I don't know about at that price

finally found you. i will be saving upfor this baby. i saw it being used by Gunthar and its very impressive. goes very well with his bot.

I like that you can keep exact track of how much your earning on each pair. very nice work.

Brazilman37BTC

Yes, 0.05 BTC. The price hasn't changed from when I posted this thread.


The spreadsheet is specailly designed for Gunbot. The functions has been created together with Gunthar, which makes it possible to promise the best way to show earnings from Gunbot.

There have been multiple changes since the very first versions, as it is also utilized by traders without Gunbot. It therefore makes itself usable for both Gunbot and daytrading.

i was hoping to have the coin to buy the spreadsheet by tomorrow. it looks like it might take me a little longer the alt coins have all taken a serious dive for 2 days now. so just a matter of having patience and i will get my profit.
sorry for the delay,

Brazilman37BTC

Hi mr shark,
ok i have gotten enough coin sold to keep trading with the bot and pay for the spreadsheet. please PM me your btc address so i can send the btc.
Thank you,
Brazilman37BTC

Please PM me your address, I would like to buy.

Thanks

I see alot of people using these with GUNBOT (https://bitcointalk.org/index.php?topic=1987454.0). Well worth the cost in my opinion. Nice work Shark!!

Thank you very much.
It is indeed made in cooperation with Gunthar, the owner and creator of GUNBOT. A test version has been released of the spreadsheet, which works with the data export from Bittrex. Included in the package now.

I have sent a message to both of the people above you with an address.

If anyone is planning to buy the spreadsheet, be advised to contact @henkkaa1 on Telegram.

Buying it with me will result in long waiting times and limited support currently. I will return in 30 days.
(I am back)

Is the last version is 1.5.1 ?? I have it, but don't work fine :(

I wonder if it's been maintained or updated at all since ... 2017.

Would be nice to find config.js or spreadsheets or other predictive analytics tools for Gunbot that apply to uh ... now (July 2018).  If anyone knows someone selling such tools/info can you let me/us know?  Thxs :)