Pages:
Author

Topic: deleted - page 3. (Read 14655 times)

full member
Activity: 155
Merit: 100
June 30, 2017, 04:43:19 PM
#84
just to let everyone who might be interested in updates know:

i am looking forward to finish the points listed in "UPCOMING" as soon as im done with my exams (last one at 13.07.2017).


greetings

Good luck with your exams!
thanks man Smiley
sr. member
Activity: 700
Merit: 254
June 30, 2017, 12:22:29 PM
#83
just to let everyone who might be interested in updates know:

i am looking forward to finish the points listed in "UPCOMING" as soon as im done with my exams (last one at 13.07.2017).


greetings

Good luck with your exams!
full member
Activity: 155
Merit: 100
June 30, 2017, 11:19:02 AM
#82
just to let everyone who might be interested in updates know:

i am looking forward to finish the points listed in "UPCOMING" as soon as im done with my exams (last one at 13.07.2017).


greetings
newbie
Activity: 42
Merit: 0
June 30, 2017, 10:55:03 AM
#81
PM'd you dude

Amazing how far this spreadsheet has come, for people who trade on POLO this is absolutely amazing and for me works flawless without any issues
sr. member
Activity: 700
Merit: 254
June 04, 2017, 05:10:56 AM
#80
@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  Grin).








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 Wink


greetings

I am such a noob!
Thanks!
full member
Activity: 155
Merit: 100
June 04, 2017, 04:04:15 AM
#79
@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  Grin).








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 Wink


greetings
sr. member
Activity: 700
Merit: 254
June 03, 2017, 06:05:43 PM
#78
@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  Grin).







sr. member
Activity: 700
Merit: 254
May 20, 2017, 07:07:41 PM
#77
Will do!
Thanks a lot.


Marked on polo.
full member
Activity: 155
Merit: 100
May 20, 2017, 06:28:06 PM
#76
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) Smiley


greetings
sr. member
Activity: 700
Merit: 254
May 20, 2017, 05:39:47 PM
#75
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.
full member
Activity: 155
Merit: 100
May 19, 2017, 06:16:14 AM
#74
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 Wink


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
Ucy
sr. member
Activity: 2576
Merit: 402
May 19, 2017, 06:09:23 AM
#73
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 Wink


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


greetings

Thanks alot. Dont have MS EXCEL 2016 yet. Will install later
full member
Activity: 155
Merit: 100
May 19, 2017, 03:54:33 AM
#72
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 Wink

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


greetings
Ucy
sr. member
Activity: 2576
Merit: 402
May 18, 2017, 08:11:36 PM
#71
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
full member
Activity: 209
Merit: 100
May 18, 2017, 07:58:22 PM
#70
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  Wink)
  • 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
full member
Activity: 155
Merit: 100
May 18, 2017, 02:10:00 PM
#69
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  Wink)
  • 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!
newbie
Activity: 45
Merit: 0
May 17, 2017, 09:43:15 PM
#68
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
full member
Activity: 155
Merit: 100
May 12, 2017, 12:47:27 PM
#67
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
newbie
Activity: 45
Merit: 0
May 12, 2017, 11:42:49 AM
#66
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
full member
Activity: 155
Merit: 100
May 09, 2017, 03:42:06 PM
#65
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
Pages:
Jump to: