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

this looks nice, I have to try it asap

didnt think this little file would cause so much problems with so many people 

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

THANK YOU!


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

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.

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/

haha well i dont like ms stuff either except excel since i cant find any program offering the depth that excel does


greetings

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.

I think i have an old version (2010 or so)....let's try this first.

yes

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

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

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

tradeHistory = history from all your trades on poloniex (https://poloniex.com/tradeHistory)
depositHistory = history fromm all your deposits on poloniex (https://poloniex.com/depositHistory)

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

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  ) 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

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.

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 !

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

I cannot get this to work at all  

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/

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

anyways whats ment is the d & w history

sry for that one  



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

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

following

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

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!

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

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.

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.