Poloniex Trading Spreadsheet - Best with Bots!

[FrilledShark]

Poloniex Trading Spreadsheet

Current version: 1.4.5(.1). Version on above picture: 1.2

Table of content:

• Information
• Features
• Upcoming features
• Price
• Ordering the spreadsheet
• Tutorial
• Preview
• Notes

Information:
This spreadsheet was made to work with Poloniex's trading history export. 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 & Open Wallet) Mention the transaction ID in a message to me. Otherwise, catch me on Telegram or Discord and we can chat live. (Other contact info)

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


Preview:

Hello Gunther want to ask is there somewhere statistics with the most profitable currency trading with GUNBOT there shared information about it?

We dont have an official statistic but we have FrilledShark excel spreadsheet with user's generated stats using GUNBOT, here are some refs (you can find all these users here on forum or on Telegram group or at our home https://gunthy.org )

https://docs.google.com/spreadsheets/d/1SEKRi4pIUcwIweUrcdotXuxVgPgSE5DBQRTyoHfWEAY/pubhtml

https://docs.google.com/spreadsheets/d/12FDQv9wGsdYgGHh35l0mN8dLo-H-CZZrJhRd96uppps/pubhtml

https://docs.google.com/spreadsheets/d/1upDYz4_BwLliNoYeVH974U13eogGb4QWp6GkP-JTYag/pubhtml

https://docs.google.com/spreadsheets/d/1DCqmyhNPlF4S446SrSCDBvJJvPtqgFMdbrI5NVOFgtQ/pubhtml

https://docs.google.com/spreadsheets/d/1yjhny1U1lKMEkTAnJ1dORSF0Df7cF-oflPDsb5gt6mg/pubhtml

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

[1715040981]

1715040981

[1715040981]

1715040981

[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.

[joel_]

@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.

[FrilledShark]

@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

[Yannick4u]

Where is the preview?

[FrilledShark]

Where is the preview?

The spreadsheet is widely used by buyer of the GunBot. I will therefore quote one of Gunthar's messages:

Hello Gunther want to ask is there somewhere statistics with the most profitable currency trading with GUNBOT there shared information about it?

We dont have an official statistic but we have FrilledShark excel spreadsheet with user's generated stats using GUNBOT, here are some refs (you can find all these users here on forum or on Telegram group or at our home https://gunthy.org )

https://docs.google.com/spreadsheets/d/1SEKRi4pIUcwIweUrcdotXuxVgPgSE5DBQRTyoHfWEAY/pubhtml

https://docs.google.com/spreadsheets/d/12FDQv9wGsdYgGHh35l0mN8dLo-H-CZZrJhRd96uppps/pubhtml

https://docs.google.com/spreadsheets/d/1upDYz4_BwLliNoYeVH974U13eogGb4QWp6GkP-JTYag/pubhtml

https://docs.google.com/spreadsheets/d/1DCqmyhNPlF4S446SrSCDBvJJvPtqgFMdbrI5NVOFgtQ/pubhtml

https://docs.google.com/spreadsheets/d/1yjhny1U1lKMEkTAnJ1dORSF0Df7cF-oflPDsb5gt6mg/pubhtml

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.

[minero1]

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.

[FrilledShark]

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.

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.

[someone111]

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

[FrilledShark]

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.

[KeyGenKing]

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

[someone111]

If you buy the spreadsheet and find a couple other, then I can add it.

Bought it already.

[scox]

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.

[someone111]

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

[someone111]

Could you please add a field "Since"?

[FrilledShark]

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

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.

Could you please add a field "Since"?

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

[someone111]

No, as I can't refer when "Since" begun.

The date of the very first trade?

[FrilledShark]

No, as I can't refer when "Since" begun.

The date of the very first trade?

Yes, but that would just be the earnings right?

[someone111]

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

[Zimmsquad]

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