deleted

[JanpriX]

I've been searching for a tool like this for quite some time now. I actually found some but they are being sold for some BTC. It is actually good that you are providing this for free. I'll definitely try this one out when I get home as I'm currently at work and can't download the excel file. Good job OP for providing this to us, traders. 

[guesswho1234]

I've been searching for a tool like this for quite some time now. I actually found some but they are being sold for some BTC. It is actually good that you are providing this for free. I'll definitely try this one out when I get home as I'm currently at work and can't download the excel file. Good job OP for providing this to us, traders. 

my pleasure

dont hesitate to ask if something doesnt work properly!


greetings

[guesswho1234]

UPDATE: DOWNLOAD IN OP

• new design with some thought behind it and somewhat of a theme
• new easy sort functionality for each column (just click on the blue text, sorting alternates between ascending and descending)
• re-implemented the graph and also added a red break even line (data of graph gets selected by clicking on the blue text of the pairings in column A)
• trashed / reworked some of the code to make the workbook a little faster
• new formatting to indicate significance of profit / loss (green = 67 quantile, yellow = 33 quantile, red = rest)
• decided to display the traded volume instead of "amount" since the "amount"-value can be misleading for people who deposited/withdrew coins

also to all who got the object / library not found error:
as far as i am informed this error occurs when you have an outdated version of ms excel which further leads to outdated libraries which are needed to execute my code properly
i dont know yet if i cant get my file to work cross-version but i will keep you updated on this.
as for now i can only provide a version for ms excel 2016 (tested it for this version on various computers in my university and it seems to work pretty smoothly)

PREVIEW:




i hope you guys like it and i am open for feedback!


greetings!

[imtaurin]

My antivirus said that http://www.xup.in is potentially dangerous and does not allow downloading the file = (

[guesswho1234]

My antivirus said that http://www.xup.in is potentially dangerous and does not allow downloading the file = (

you are the first one to report this problem.

if you like i can send it to you via skype.


greetings

[teknomen]

UPDATE: DOWNLOAD IN OP

• new design with some thought behind it and somewhat of a theme
• new easy sort functionality for each column (just click on the blue text, sorting alternates between ascending and descending)
• re-implemented the graph and also added a red break even line (data of graph gets selected by clicking on the blue text of the pairings in column A)
• trashed / reworked some of the code to make the workbook a little faster
• new formatting to indicate significance of profit / loss (green = 67 quantile, yellow = 33 quantile, red = rest)
• decided to display the traded volume instead of "amount" since the "amount"-value can be misleading for people who deposited/withdrew coins

also to all who got the object / library not found error:
as far as i am informed this error occurs when you have an outdated version of ms excel which further leads to outdated libraries which are needed to execute my code properly
i dont know yet if i cant get my file to work cross-version but i will keep you updated on this.
as for now i can only provide a version for ms excel 2016 (tested it for this version on various computers in my university and it seems to work pretty smoothly)

PREVIEW:
https://i.imgsafe.org/fa06415503.png



i hope you guys like it and i am open for feedback!


greetings!

please can you upload the last version on other server i can't download it from that site

[guesswho1234]

UPDATE: DOWNLOAD IN OP

• new design with some thought behind it and somewhat of a theme
• new easy sort functionality for each column (just click on the blue text, sorting alternates between ascending and descending)
• re-implemented the graph and also added a red break even line (data of graph gets selected by clicking on the blue text of the pairings in column A)
• trashed / reworked some of the code to make the workbook a little faster
• new formatting to indicate significance of profit / loss (green = 67 quantile, yellow = 33 quantile, red = rest)
• decided to display the traded volume instead of "amount" since the "amount"-value can be misleading for people who deposited/withdrew coins

also to all who got the object / library not found error:
as far as i am informed this error occurs when you have an outdated version of ms excel which further leads to outdated libraries which are needed to execute my code properly
i dont know yet if i cant get my file to work cross-version but i will keep you updated on this.
as for now i can only provide a version for ms excel 2016 (tested it for this version on various computers in my university and it seems to work pretty smoothly)

PREVIEW:




i hope you guys like it and i am open for feedback!


greetings!

please can you upload the last version on other server i can't download it from that site

i dont know which server works for you.

you can add me in skype (constraccta) if you want.


greetings

[teknomen]

UPDATE: DOWNLOAD IN OP

• new design with some thought behind it and somewhat of a theme
• new easy sort functionality for each column (just click on the blue text, sorting alternates between ascending and descending)
• re-implemented the graph and also added a red break even line (data of graph gets selected by clicking on the blue text of the pairings in column A)
• trashed / reworked some of the code to make the workbook a little faster
• new formatting to indicate significance of profit / loss (green = 67 quantile, yellow = 33 quantile, red = rest)
• decided to display the traded volume instead of "amount" since the "amount"-value can be misleading for people who deposited/withdrew coins

also to all who got the object / library not found error:
as far as i am informed this error occurs when you have an outdated version of ms excel which further leads to outdated libraries which are needed to execute my code properly
i dont know yet if i cant get my file to work cross-version but i will keep you updated on this.
as for now i can only provide a version for ms excel 2016 (tested it for this version on various computers in my university and it seems to work pretty smoothly)

PREVIEW:
https://i.imgsafe.org/fa06415503.png



i hope you guys like it and i am open for feedback!


greetings!

please can you upload the last version on other server i can't download it from that site

i dont know which server works for you.

you can add me in skype (constraccta) if you want.


greetings

any server like mediafire depositfile thanks

[guesswho1234]

UPDATE: DOWNLOAD IN OP

• design update
• new in-detail coin evaluation for the set timeframe (represents the stats of the graph that are in bright blue)
• new graph which shows full history in dark blue and selected timeframe in bright blue (dates below the graph indicate first and last trade)
• import-"wizard" which helpts you to import the poloniex data so nothing goes wrong anymore (respects your local settings regarding delimiters, should work for everyone now  )
• new setting to define how many decimals should be displayed
• changes in settings will immediately change the output (not for basemarket though)

PREVIEW:




i hope you guys like it and i am open for feedback!


greetings!

[ofergul]

UPDATE: DOWNLOAD IN OP

• design update
• new in-detail coin evaluation for the set timeframe (represents the stats of the graph that are in bright blue)
• new graph which shows full history in dark blue and selected timeframe in bright blue (dates below the graph indicate first and last trade)
• import-"wizard" which helpts you to import the poloniex data so nothing goes wrong anymore (respects your local settings regarding delimiters, should work for everyone now  )
• new setting to define how many decimals should be displayed
• changes in settings will immediately change the output (not for basemarket though)

PREVIEW:




i hope you guys like it and i am open for feedback!


greetings!

thanks for the update, works great

[Ucy]

Please can anyone help explain it uses. Being seeing this thread ever since I joined Bitcointalk still don't understand the use of its Spreadsheet. Looks like something I will need as a Trader

[guesswho1234]

Please can anyone help explain it uses. Being seeing this thread ever since I joined Bitcointalk still don't understand the use of its Spreadsheet. Looks like something I will need as a Trader

you might want to check the first post in the thread again since i update it whenever i put new version out.

in case you already did that let me try it this way.

the use of the spreadsheet is to evaluate your trades on poloniex.com from the past.
for example it lists you all the profits/losses you made with each coin you traded.

furthermore you can take a closer look at each single coin too.

it is nothing you need at all, it is just a tool i initially made for myself to keep everthing in check.

you also could just use the trade analysis tool which poloniex offers but this might get a little frustrating if you have traded alot since its very minimalistic.


but i think its best to just try it for yourself

in case you have more questions about it let me know.


greetings

[Ucy]

Please can anyone help explain it uses. Being seeing this thread ever since I joined Bitcointalk still don't understand the use of its Spreadsheet. Looks like something I will need as a Trader

you might want to check the first post in the thread again since i update it whenever i put new version out.

in case you already did that let me try it this way.

the use of the spreadsheet is to evaluate your trades on poloniex.com from the past.
for example it lists you all the profits/losses you made with each coin you traded.

furthermore you can take a closer look at each single coin too.

it is nothing you need at all, it is just a tool i initially made for myself to keep everthing in check.

you also could just use the trade analysis tool which poloniex offers but this might get a little frustrating if you have traded alot since its very minimalistic.


but i think its best to just try it for yourself


in case you have more questions about it let me know.


greetings

Thanks alot. Dont have MS EXCEL 2016 yet. Will install later

[guesswho1234]

Please can anyone help explain it uses. Being seeing this thread ever since I joined Bitcointalk still don't understand the use of its Spreadsheet. Looks like something I will need as a Trader

you might want to check the first post in the thread again since i update it whenever i put new version out.

in case you already did that let me try it this way.

the use of the spreadsheet is to evaluate your trades on poloniex.com from the past.
for example it lists you all the profits/losses you made with each coin you traded.

furthermore you can take a closer look at each single coin too.

it is nothing you need at all, it is just a tool i initially made for myself to keep everthing in check.

you also could just use the trade analysis tool which poloniex offers but this might get a little frustrating if you have traded alot since its very minimalistic.


but i think its best to just try it for yourself


in case you have more questions about it let me know.


greetings

Thanks alot. Dont have MS EXCEL 2016 yet. Will install later

if you are a student chances are high that you can get it for free from your university

[p3ppymon]

Hi,

I have downloaded the latest version. However, I cannot run the macro.
Error: Method or data member not found

Please help

Working! I updated the Office package to the newest version.
Thanks for your prompt reply.

[guesswho1234]

Hi,

I have downloaded the latest version. However, I cannot run the macro.
Error: Method or data member not found

Please help

Working! I updated the Office package to the newest version.
Thanks for your prompt reply.

you have excel 2016?
you imported the poloniex-data with the import-wizard?
also have you read the HOWTO from the OP in this thread?

greetings

no problem, im glad it works now!

if you have more questions feel free to ask.

also if you like my work i would really appreciate it if you could mark me on polo (only costs you a few cents)


greetings

[p3ppymon]

Will do!
Thanks a lot.

Marked on polo.

[p3ppymon]

@OP,

I can see some discrepancies between what I can see on Poloniex stats and what is tabulated and plotted in your sheet.
Let's consider the BCN/BTC pair. Your tabulated results is negative, whilst the graph and the outcome from Poloniex analysis seems to match (and positive at least  ).

[guesswho1234]

@OP,

I can see some discrepancies between what I can see on Poloniex stats and what is tabulated and plotted in your sheet.
Let's consider the BCN/BTC pair. Your tabulated results is negative, whilst the graph and the outcome from Poloniex analysis seems to match (and positive at least  ).

the reason for the difference is that the tabulated value always gets displayed for your selected timeframe (the part of the graph thats in a brighter blue)

if you expand your timeframe to include all your trades it should match polo again


greetings

[p3ppymon]

@OP,

I can see some discrepancies between what I can see on Poloniex stats and what is tabulated and plotted in your sheet.
Let's consider the BCN/BTC pair. Your tabulated results is negative, whilst the graph and the outcome from Poloniex analysis seems to match (and positive at least  ).

the reason for the difference is that the tabulated value always gets displayed for your selected timeframe (the part of the graph thats in a brighter blue)

if you expand your timeframe to include all your trades it should match polo again


greetings

I am such a noob!
Thanks!