guesswho1234 (OP)
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 01, 2017, 03:52:12 PM |
|
Thank you for your answer. Here the image with the error on your suggested site: ![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgsafe.org%2Ff9f23eb8ee.jpg&t=665&c=gi7Ol18RFFM3lA) 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](https://bitcointalk.org/Smileys/default/wink.gif) 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
Newbie
Offline
Activity: 7
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 03, 2017, 01:55:30 PM |
|
THANK YOU! But..i think i am stupid or the sheet hates me. ![Huh](https://bitcointalk.org/Smileys/default/huh.gif) 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 (OP)
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 03, 2017, 05:53:00 PM |
|
THANK YOU! But..i think i am stupid or the sheet hates me. ![Huh](https://bitcointalk.org/Smileys/default/huh.gif) 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](https://bitcointalk.org/Smileys/default/huh.gif) 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
Legendary
Offline
Activity: 1084
Merit: 1003
≡v≡
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 06, 2017, 01:38:33 PM |
|
this looks nice, I have to try it asap
|
|
|
|
guesswho1234 (OP)
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 06, 2017, 04:46:47 PM Last edit: April 13, 2017, 10:36:55 PM by 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
Newbie
Offline
Activity: 2
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 12, 2017, 07:46:47 PM |
|
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 (OP)
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 13, 2017, 04:17:11 PM |
|
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 ![Cheesy](https://bitcointalk.org/Smileys/default/cheesy.gif) greetings
|
|
|
|
PlasticCogLiquid
Newbie
Offline
Activity: 2
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 13, 2017, 10:28:34 PM |
|
im happy to hear that it works for atleast one person besides me ![Cheesy](https://bitcointalk.org/Smileys/default/cheesy.gif) 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 (OP)
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 13, 2017, 10:31:10 PM |
|
im happy to hear that it works for atleast one person besides me ![Cheesy](https://bitcointalk.org/Smileys/default/cheesy.gif) 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 ![Cheesy](https://bitcointalk.org/Smileys/default/cheesy.gif) 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
Newbie
Offline
Activity: 6
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 14, 2017, 10:23:10 AM Last edit: April 14, 2017, 11:21:59 AM by 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 (OP)
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 14, 2017, 12:01:48 PM |
|
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
Newbie
Offline
Activity: 6
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 14, 2017, 12:53:37 PM |
|
yes i am using excel 2016
|
|
|
|
guesswho1234 (OP)
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 18, 2017, 09:05:23 PM Last edit: April 19, 2017, 12:19:00 PM by 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
Full Member
![*](https://bitcointalk.org/Themes/custom1/images/star.gif) ![*](https://bitcointalk.org/Themes/custom1/images/star.gif)
Offline
Activity: 263
Merit: 101
Authorized Gunbot reseller > gunbot.vip
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 23, 2017, 10:17:39 PM Last edit: April 23, 2017, 11:52:00 PM by dobcrypto |
|
Wow, Thx man! Goin to try it asap. Hm... ![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgsafe.org%2Fd2d88af418.png&t=665&c=KsS3TRi78alDPw) Try to install MS Offis 2016 In 2016 i see Run time error 9 Subscribt out of Range ![Cry](https://bitcointalk.org/Smileys/default/cry.gif)
|
|
|
|
teknomen
Newbie
Offline
Activity: 45
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 23, 2017, 11:35:09 PM |
|
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
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 24, 2017, 03:24:45 AM |
|
hi, i've downloaded the file, try to apply but i've got a problem, here is screenshot : ![](https://ip.bitcointalk.org/?u=http%3A%2F%2Fi.imgsafe.org%2Fd6b6457050.jpg&t=665&c=-Lr2iEgBkfliIQ) 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 ![](https://ip.bitcointalk.org/?u=http%3A%2F%2Fi.imgsafe.org%2Fd6e970155f.jpg&t=665&c=7RKGah3zv1U7cQ)
|
█████████████████████████ ████████▀▀████▀▀█▀▀██████ █████▀████▄▄▄▄██████▀████ ███▀███▄████████▄████▀███ ██▀███████████████████▀██ █████████████████████████ █████████████████████████ █████████████████████████ ██▄███████████████▀▀▄▄███ ███▄███▀████████▀███▄████ █████▄████▀▀▀▀████▄██████ ████████▄▄████▄▄█████████ █████████████████████████ | BitList | | █▀▀▀▀ █ █ █ █ █ █ █ █ █ █ █ █▄▄▄▄ | ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ . REAL-TIME DATA TRACKING CURATED BY THE COMMUNITY . ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | ▀▀▀▀█ █ █ █ █ █ █ █ █ █ █ █ ▄▄▄▄█ | | List #kycfree Websites |
|
|
|
guesswho1234 (OP)
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 24, 2017, 09:00:57 AM Last edit: April 24, 2017, 09:12:51 AM by guesswho1234 |
|
please can you upload it on other server i can't download it from that site
File: http://www.datafilehost.com/d/7a3efd6fdoes 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 Run time error 9 Subscribt out of Range ![Cry](https://bitcointalk.org/Smileys/default/cry.gif) 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 ![Cheesy](https://bitcointalk.org/Smileys/default/cheesy.gif) anyways i think it should be fixed. thank you for your patience! File: http://www.xup.in/dl,14148873/CALC.XLSM/greetings
|
|
|
|
dobcrypto
Full Member
![*](https://bitcointalk.org/Themes/custom1/images/star.gif) ![*](https://bitcointalk.org/Themes/custom1/images/star.gif)
Offline
Activity: 263
Merit: 101
Authorized Gunbot reseller > gunbot.vip
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 24, 2017, 09:32:55 AM |
|
please can you upload it on other server i can't download it from that site
File: http://www.datafilehost.com/d/7a3efd6fdoes 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 Run time error 9 Subscribt out of Range ![Cry](https://bitcointalk.org/Smileys/default/cry.gif) 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 ![Cheesy](https://bitcointalk.org/Smileys/default/cheesy.gif) 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 Run time error 9 Subscribt out of Range
|
|
|
|
guesswho1234 (OP)
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 24, 2017, 09:35:55 AM |
|
It dosn't work for me to =( The same error 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 ![Undecided](https://bitcointalk.org/Smileys/default/undecided.gif) greetings
|
|
|
|
dobcrypto
Full Member
![*](https://bitcointalk.org/Themes/custom1/images/star.gif) ![*](https://bitcointalk.org/Themes/custom1/images/star.gif)
Offline
Activity: 263
Merit: 101
Authorized Gunbot reseller > gunbot.vip
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 24, 2017, 12:32:20 PM Last edit: April 24, 2017, 12:58:38 PM by dobcrypto |
|
It dosn't work for me to =( The same error 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 ![Undecided](https://bitcointalk.org/Smileys/default/undecided.gif) 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. ![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgsafe.org%2Fdefb2233a5.png&t=665&c=So2O0Y5aVlI9vA) 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) ![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgsafe.org%2Fdeff5deff8.png&t=665&c=WhrAvMTlIrTrhg) 4. Go to CALC.XLSM "calc" > GO! > ![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgsafe.org%2Fdf02e85f0b.png&t=665&c=Pc66AEF_WK2n2A)
|
|
|
|
|