deleted

[guesswho1234]

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.

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

[Klon522]

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.

[guesswho1234]

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.

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

[mettalmag]

this looks nice, I have to try it asap

[guesswho1234]

UPDATE:

+ bugfix for chart getting f* up after changing input data
+ bugfix for displaying wrong amount of altcoins when you trade in different base currencies (f.e. btc and usdt)

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


greetings!


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


feel free to donate (btc): 1L1dUy9iuakec4kSDhs3KuMw3gEfwhuqsJ

EDIT: ITS MANDATORY TO USE THE LATEST AND OFFICIAL MS EXCEL VERSION (2016) FOR MY MAKRO TO WORK PROPERLY!

[PlasticCogLiquid]

Thanks! Worked in Excel 2016 for me, everything else failed.

This is all I wanted though, I can see all my coins at once and whether they are in the red or green. Not sure why polo doesn't have an option for that.

[guesswho1234]

Thanks! Worked in Excel 2016 for me, everything else failed.

This is all I wanted though, I can see all my coins at once and whether they are in the red or green. Not sure why polo doesn't have an option for that.

im happy to hear that it works for atleast one person besides me


greetings

[PlasticCogLiquid]

im happy to hear that it works for atleast one person besides me


greetings

I went through some pain and suffering first :] Libreoffice = fail, updated it = still fail, Excel 2010 = fail, excel 2016 = finally win! Thanks for sharing!

[guesswho1234]

im happy to hear that it works for atleast one person besides me


greetings

I went through some pain and suffering first :] Libreoffice = fail, updated it = still fail, Excel 2010 = fail, excel 2016 = finally win! Thanks for sharing!

wow you really wanted it to work

didnt think this could cause so much problems. i mean if it wont work in some free-excel-fake i get that, but not even on 2010. thats weird.

since you are someone who can use it now... if you have any suggestions or alike dont hesitate to share them. if i get time i will always try to improve it.


greetings

[shady225]

how can i insert the deposit history and trading history in the sheet?
if i just copy and paste it its not working, because all the text is just in the first field.

if i click on "Go" it says "Run time error 9 - Subscribt out of Range"

[guesswho1234]

how can i insert the deposit history and trading history in the sheet?
if i just copy and paste it its not working, because all the text is just in the first field.

if i click on "Go" it says "Run time error 9 - Subscribt out of Range"

are you using ms excel 2016?

if you are it should be no problem to copy the data from one excel to another by selecting the data with your mouse -> STRG+C -> click into cell A1 -> STRG+V.

if you are not using ms excel 2016 the program wont work anyways sadly


greetings

[shady225]

yes i am using excel 2016

[guesswho1234]

UPDATE:

+ corrected the "fees-paid"-calculation (it only took into account the fees you paid when you sold coins)
+ altered the "amount"-column so it doesnt take into account the coins you deposited (this made the break-even-price calculation to be wrong)
+ removed the the "depositHistory"-sheet (you dont need it anymore beacuse of the point above)
+ added the possibility to select a basemarket so you can view your profit/loss not only for BTC as basemarket but also for ETH,XMR,USDT

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


greetings!


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


mark me on poloniex (btm): /mark cryptoexchange <amount>
feel free to donate (btc): 1L1dUy9iuakec4kSDhs3KuMw3gEfwhuqsJ

[dobcrypto]

Wow, Thx man!
Goin to try it asap.

Hm...


Try to install MS Offis 2016
In 2016 i see

Code:

Run time error 9 
Subscribt out of Range 

 

[teknomen]

UPDATE:

+ corrected the "fees-paid"-calculation (it only took into account the fees you paid when you sold coins)
+ altered the "amount"-column so it doesnt take into account the coins you deposited (this made the break-even-price calculation to be wrong)
+ removed the the "depositHistory"-sheet (you dont need it anymore beacuse of the point above)
+ added the possibility to select a basemarket so you can view your profit/loss not only for BTC as basemarket but also for ETH,XMR,USDT

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


greetings!


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


mark me on poloniex (btm): /mark cryptoexchange <amount>
feel free to donate (btc): 1L1dUy9iuakec4kSDhs3KuMw3gEfwhuqsJ

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

[maydna]

hi,

i've downloaded the file, try to apply but i've got a problem, here is screenshot :



i am using excel 2017 ( i don't know if its right version or not ). i am trying to using 2003 version that you've upload but its failed too, after i enabled macro, i think its crash or something like that.

here is what i've got with 2003 version

[guesswho1234]

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

File: http://www.datafilehost.com/d/7a3efd6f

does that one work for you?

if not you can add me on skype: constraccta

Wow, Thx man!
Goin to try it asap.

Hm...

Try to install MS Offis 2016
In 2016 i see

Code:

Run time error 9 
Subscribt out of Range 

 

hi,

i've downloaded the file, try to apply but i've got a problem, here is screenshot :


i am using excel 2017 ( i don't know if its right version or not ). i am trying to using 2003 version that you've upload but its failed too, after i enabled macro, i think its crash or something like that.

here is what i've got with 2003 version

for some reason i deleted the declaration of the variable r2. dunno why it worked on my side because it really shouldnt have

anyways i think it should be fixed.

thank you for your patience!

File: http://www.xup.in/dl,14148873/CALC.XLSM/


greetings

[dobcrypto]

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

File: http://www.datafilehost.com/d/7a3efd6f
does that one work for you?
if not you can add me on skype: constraccta

Wow, Thx man!
Goin to try it asap.
Hm...
Try to install MS Offis 2016
In 2016 i see

Code:

Run time error 9 
Subscribt out of Range 

 

hi,

i've downloaded the file, try to apply but i've got a problem, here is screenshot :

i am using excel 2017 ( i don't know if its right version or not ). i am trying to using 2003 version that you've upload but its failed too, after i enabled macro, i think its crash or something like that.

here is what i've got with 2003 version

for some reason i deleted the declaration of the variable r2. dunno why it worked on my side because it really shouldnt have

anyways i think it should be fixed.

thank you for your patience!

File: http://www.xup.in/dl,14148873/CALC.XLSM/
greetings

It dosn't work for me to =(
The same error

Code:

Run time error 9 
Subscribt out of Range 

[guesswho1234]

It dosn't work for me to =(
The same error

Code:

Run time error 9 
Subscribt out of Range 

may i ask what steps exactly you took?
which excel version did you use?
did you import data?
if yes did you fill it into the tradehistory sheet so that only the first row are headers and the rest is data?

im really confused that it works on my computer  


greetings

[dobcrypto]

It dosn't work for me to =(
The same error

Code:

Run time error 9 
Subscribt out of Range 

may i ask what steps exactly you took?
which excel version did you use?
did you import data?
if yes did you fill it into the tradehistory sheet so that only the first row are headers and the rest is data?

im really confused that it works on my computer 
greetings

excel/Microsoft Office 2016 VL x64
1. Open last CALC.XLSM, get it permission to run all scripts.
2. Open tradeHistory.csv and copy all of strings.


3. Go to CALC.XLSM "tradeHistory" tab and past all of strings from tradeHistory.csv
(did try delete 1st string with "Date,Market,Category,Type,Price,Amount,Total,Fee,Order Number,Base Total Less Fee,Quote Total Less Fee", exact same error)


4. Go to CALC.XLSM "calc" > GO! >