Pages:
Author

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

legendary
Activity: 1084
Merit: 1003
≡v≡
April 06, 2017, 09:38:33 AM
#24
this looks nice, I have to try it asap
full member
Activity: 155
Merit: 100
April 03, 2017, 01:53:00 PM
#23
THANK YOU!


But..i think i am stupid or the sheet hates me. Huh

I tested it with Libre office and now with the 2013 Excel Version. Both are not working. Which Version did you use? So i can verify if the problem is alone on my end.
didnt think this little file would cause so much problems with so many people  Huh

did you just open it, hit go and it didnt work?

if thats the case the only reason i can think of is that the programs you used dont support the newest excel formats.

here i uploaded a version with the old excel 2003 format

File: http://www.xup.in/dl,11186021/special_for_you.xls/

if it still does not work i really dont know what the prolem is since i works fine on my site.

hope it works now


greetings
newbie
Activity: 7
Merit: 0
April 03, 2017, 09:55:30 AM
#22
THANK YOU!


But..i think i am stupid or the sheet hates me. Huh

I tested it with Libre office and now with the 2013 Excel Version. Both are not working. Which Version did you use? So i can verify if the problem is alone on my end.

full member
Activity: 155
Merit: 100
April 01, 2017, 11:52:12 AM
#21
Thank you for your answer.

Here the image with the error on your suggested site:
looked at your screenshot and it seems that the only problem is the chart implementation

uploaded a version without the chart stuff in case you still want to try it without that feature

File: http://www.xup.in/dl,38149306/special_for_you.xlsm/

And i don't like MS Office very much. For some reasons....but i fully understand your statement with the free ("fake") version.

and i looked into it: Yes, i can get a free copy of the 356 one..... but ohh that pain....maybe i will try something different before i sell my full soul to MS. Wink

I think i have an old version (2010 or so)....let's try this first.
haha well i dont like ms stuff either except excel since i cant find any program offering the depth that excel does


greetings
newbie
Activity: 7
Merit: 0
April 01, 2017, 08:59:33 AM
#20
Thank you for your answer.

Here the image with the error on your suggested site: https://i.imgsafe.org/f9f23eb8ee.jpg

And i don't like MS Office very much. For some reasons....but i fully understand your statement with the free ("fake") version.

and i looked into it: Yes, i can get a free copy of the 356 one..... but ohh that pain....maybe i will try something different before i sell my full soul to MS. Wink

I think i have an old version (2010 or so)....let's try this first.
full member
Activity: 155
Merit: 100
April 01, 2017, 07:06:56 AM
#19
Hi guesswho1234,

thank you very much for your effort on this programm.

Is it mandatory to use MS Office for that? Because i got an error, when i press go. I use LibreOffice 5.3.1.2.
yes

it would be a miracle if any excel fake would be able to do what the original is capable of doing

c/ximg.php?fid=55233911[/img]

No difference with or without the data from polo provided.

Also,i cant set the date right. I can choose year and month, but not the day.
your link somehow got removed. try https://imgsafe.org/ maybe

also i think the reason that it does not work is beacuse you are not using ms excel.

sorry for that i can only provide it for ms excel.

btw. if you are a student you should get a free license for all ms office products from your university.


greetings
full member
Activity: 155
Merit: 100
April 01, 2017, 06:53:38 AM
#18
I think you should revise the XML as it has 3 sheets :
calc
tradeHistory
transactionHistory
the reason for this is so that each data-input is seperate and nothing gets confused

so the calc sheet is the main sheet where all the macro stuff happens while the other 2 sheets are only for data you export from poloniex

I think maybe the tradeHistory is the deposit history ? or ?
tradeHistory = history from all your trades on poloniex (https://poloniex.com/tradeHistory)
depositHistory = history fromm all your deposits on poloniex (https://poloniex.com/depositHistory)

EDIT:
also, I canțt get this work .. I get an error in the macros :
Method or Data member not found - when I try to select multiple dates. .. the macro is looking for COLUMN L2:
ActiveChart.FullSeriesCollection(1).Values = "=tradeHistory!$L$2:$L$" & r - 1
I think that should be the date, and for example when I export all trade history I have the date in the first column .
i am a little confused with what you are doing.

what do you mean by "select multiple dates"?
afterall you should select a timeframe with the datepicker (from-date, to-date).

also the error you get has nothing to do with the date.
the "L"-Column should be empty when you import your data (it gets filled by the macro and is used for the graph).
it is correct that the first column is the date in the data from poloniex. thats the way it should be

... also the selection is a bit weird .. you are better with CTRL+click on each date... but maybe it should take into account all the data by default .
again i dont know what you are doing with the dates.

this is how it is suppoed to work (which it does on my computer atleast  Tongue) for both dates (from-date, to-date):
-select month and year with the dropdown that opens when you click into the cell
-click on the cells for selecting a day (no dropdown there. it just takes the day you clicked on)
-if you do that the written date in the cell below the datepicker should change respectively (you could change that date manually too but is not recommended since the format needs to be correct. use the datepicker)
-hit go

maybe re-download my file and try this without any data. if that works you can again import your poloniex data as described.


greetings

newbie
Activity: 7
Merit: 0
March 31, 2017, 08:51:36 PM
#17
Hi guesswho1234,

thank you very much for your effort on this programm.

Is it mandatory to use MS Office for that? Because i got an error, when i press go. I use LibreOffice 5.3.1.2.


c/ximg.php?fid=55233911[/img]

No difference with or without the data from polo provided.

Also,i cant set the date right. I can choose year and month, but not the day.

member
Activity: 119
Merit: 101
www.thecryptobot.com
March 31, 2017, 05:37:04 PM
#16
Hi there !

Nice job building this .

I think you should revise the XML as it has 3 sheets :
calc
tradeHistory
transactionHistory


I think maybe the tradeHistory is the deposit history ? or ?

EDIT:
also, I canțt get this work .. I get an error in the macros :
Method or Data member not found - when I try to select multiple dates. .. the macro is looking for COLUMN L2:
ActiveChart.FullSeriesCollection(1).Values = "=tradeHistory!$L$2:$L$" & r - 1
I think that should be the date, and for example when I export all trade history I have the date in the first column .

... also the selection is a bit weird .. you are better with CTRL+click on each date... but maybe it should take into account all the data by default .

I hope you get a working example up soon ! good luck !
full member
Activity: 155
Merit: 100
March 28, 2017, 12:38:07 PM
#15
I cannot get this to work at all  Huh

Get a compile error "cant find project or library"

Virus Total for others for people worried about the file
https://www.virustotal.com/en/file/2edffe063d34a127f2f6d4d5199111faf7241f50bf0a292446e836b557f567b7/analysis/1490696890/
got a screenshot maybe?

also are you using a mac?
sadly it somehow does not work on macs

i can also offer you to add me on skype: constraccta


greetings
newbie
Activity: 42
Merit: 0
March 28, 2017, 05:51:07 AM
#14
I cannot get this to work at all  Huh

Get a compile error "cant find project or library"

Virus Total for others for people worried about the file
https://www.virustotal.com/en/file/2edffe063d34a127f2f6d4d5199111faf7241f50bf0a292446e836b557f567b7/analysis/1490696890/
full member
Activity: 155
Merit: 100
March 23, 2017, 07:06:16 PM
#13
I'm still lost in what could be this one file "Transactionhistory.csv"  poloniex offfers deposit and withdrawl, tradehistory, lendinghistory.. where u get that one?

I'm still lost in what could be this one file "Transactionhistory.csv"  poloniex offfers deposit and withdrawl, tradehistory, lendinghistory.. where u get that one?

+1 still looking for that myself Huh

either they have renamed it or it was wrong the whole time

anyways whats ment is the d & w history

sry for that one  Roll Eyes


Just noticed that people might not exclusively trade / btc which means as soon as you f.e. trade xmr / usdt my workbook could break.

I didnt try what exactly happens if you do so but im sure it will alter the results.

So keep that in mind when you are using my current version.

Im planning to fix this as soon as possible but dont know yet when i have time for that.


greetings!


feel free to donate (btc): 1L1dUy9iuakec4kSDhs3KuMw3gEfwhuqsJ

UPDATE:

+ quick fix for the above problem so that you now get the correct profit/loss BTC value (have not found time yet to implement that you can choose between BTC, USDT, etc. ... it is on my list though)

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


greetings!


File: http://www.xup.in/dl,15547789/calc.xlsm/


feel free to donate (btc): 1L1dUy9iuakec4kSDhs3KuMw3gEfwhuqsJ
brand new
Activity: 0
Merit: 0
March 22, 2017, 11:07:18 PM
#12
I'm still lost in what could be this one file "Transactionhistory.csv"  poloniex offfers deposit and withdrawl, tradehistory, lendinghistory.. where u get that one?
newbie
Activity: 42
Merit: 0
March 23, 2017, 05:02:59 PM
#12
I'm still lost in what could be this one file "Transactionhistory.csv"  poloniex offfers deposit and withdrawl, tradehistory, lendinghistory.. where u get that one?

+1 still looking for that myself Huh
sr. member
Activity: 807
Merit: 423
March 16, 2017, 06:15:21 PM
#11
following
full member
Activity: 155
Merit: 100
October 07, 2016, 11:41:15 AM
#10
UPDATE:

+ improved datepicker


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


greetings!


File: http://www.xup.in/dl,19204092/calc.xlsm/


feel free to donate (btc): 1L1dUy9iuakec4kSDhs3KuMw3gEfwhuqsJ
full member
Activity: 155
Merit: 100
September 19, 2016, 06:28:54 AM
#9
So, you are providing an Excel sheet with macro functionality for free of cost. Nice try bro, keep it up.
But I have not heard any file hosting in the name of xup, so fear to open your links. I like to have any screen shot for excel sheet with data and how to use it effectively if possible.
Doesnt mean the actual file is ok, Im not sure nowadays if excel allows anything really dangerous.  Its microsoft, probably Cheesy
It could be since its possible to execute stuff when opening the file. But i only uploaded the excel-file and no other *.exe that could be executed.

Furthermore you could just follow the instructions from my initial post where i explain how you can prevent macros from being started (renaming the file from *.xlsm to *.xlsx).

I think with all the stuff i provided it should be possible for everyone to test my file savely.

Here some more pictures:






greetings!
STT
legendary
Activity: 4004
Merit: 1428
☠ ☠ ☠ メメ
September 19, 2016, 02:30:40 AM
#8
So, you are providing an Excel sheet with macro functionality for free of cost. Nice try bro, keep it up.
But I have not heard any file hosting in the name of xup, so fear to open your links. I like to have any screen shot for excel sheet with data and how to use it effectively if possible.

There is a general guide to websites, even google can be used roughly to gauge a website.  The worst sites are generally labelled by some service.    Here is one of them and its verdict on this host is good
https://www.mywot.com/en/scorecard/xup.in?utm_source=addon&utm_content=rw-viewsc

Doesnt mean the actual file is ok, Im not sure nowadays if excel allows anything really dangerous.  Its microsoft, probably Cheesy
hero member
Activity: 2128
Merit: 520
September 19, 2016, 01:55:40 AM
#7
I downloaded your excel file and later I shall check how it can help me to analyze poloniex coin data. I hope it will be very useful.
i will wait for your comments mate let me see if its useful i just started to trade as well so im looking for some helpful things to keep my trade updated.
hero member
Activity: 868
Merit: 500
September 18, 2016, 10:55:08 PM
#6
I downloaded your excel file and later I shall check how it can help me to analyze poloniex coin data. I hope it will be very useful.
Pages:
Jump to: