deleted - page 5. | Bitcointalksearch.org

chris330

newbie

Activity: 42

Merit: 0

Quote from: guesswho1234 on April 24, 2017, 09:53:32 AM

INFO:

re-uploaded a version without the graph-feature since it causes some problems i dont fully understand yet.

so if you had problems with the latest versions even though you imported the data correctly (see the post above regarding copy & paste from the *.csv-file) you might try this version

i know it is a little messy but i try to fix this as soon as i find time for it

greetings

File: http://www.xup.in/dl,17230408/calc_no_graph.xlsm/

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

Think this one works, well it has put all my trade history into the first page. Will have a look now but looks good so far Cool

guesswho1234

full member

Activity: 155

Merit: 100

INFO:

re-uploaded a version without the graph-feature since it causes some problems i dont fully understand yet.

so if you had problems with the latest versions even though you imported the data correctly (see the post above regarding copy & paste from the *.csv-file) you might try this version

i know it is a little messy but i try to fix this as soon as i find time for it

greetings

File: http://www.xup.in/dl,17230408/calc_no_graph.xlsm/

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

dobcrypto

full member

Activity: 263

Merit: 101

Authorized Gunbot reseller > gunbot.vip

Quote from: guesswho1234 on April 24, 2017, 08:36:41 AM

Quote from: dobcrypto on April 24, 2017, 07:32:20 AM

Quote from: guesswho1234 on April 24, 2017, 04:35:55 AM

Quote from: dobcrypto on April 24, 2017, 04:32:55 AM

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 Undecided

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://i.imgsafe.org/defb2233a5.png

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://i.imgsafe.org/deff5deff8.png

4. Go to CALC.XLSM "calc" > GO! >
https://i.imgsafe.org/df02e85f0b.png

Oh damn i know whats happening.
the file you get from poloniex is a *.csv-file which probably gets openend by a different program on everyones computer.
the thing is that you need to open it with excel so when you copy & paste the data each entry is in its own cell
Never thought about this since i have set excel as my standard program to open *.csv files.
so all you need to do is right-click on the tradehistory.csv and open it with excel, then copy & paste the date into my workbook.

also you do not need to alter the data from the *.csv-file. you can leave the headers if they are in the first row.

it should look like this in the end:

big sorry for not giving that info!
greetings

Of course I open *.csv-file with excel too =)
But I see that it only detaches it in column A, and does not distribute the values in columns.
And then i past it to your sheets, its not distribute the values in columns...
Well see...

guesswho1234

full member

Activity: 155

Merit: 100

Quote from: dobcrypto on April 24, 2017, 07:32:20 AM

Quote from: guesswho1234 on April 24, 2017, 04:35:55 AM

Quote from: dobcrypto on April 24, 2017, 04:32:55 AM

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 Undecided

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://i.imgsafe.org/defb2233a5.png

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://i.imgsafe.org/deff5deff8.png

4. Go to CALC.XLSM "calc" > GO! >
https://i.imgsafe.org/df02e85f0b.png

Oh damn i know whats happening.

the file you get from poloniex is a *.csv-file which probably gets openend by a different program on everyones computer.

the thing is that you need to open it with excel so when you copy & paste the data each entry is in its own cell

Never thought about this since i have set excel as my standard program to open *.csv files.

so all you need to do is right-click on the tradehistory.csv and open it with excel, then copy & paste the date into my workbook.

also you do not need to alter the data from the *.csv-file. you can leave the headers if they are in the first row.

it should look like this in the end:

big sorry for not giving that info!

greetings

dobcrypto

full member

Activity: 263

Merit: 101

Authorized Gunbot reseller > gunbot.vip

Quote from: guesswho1234 on April 24, 2017, 04:35:55 AM

Quote from: dobcrypto on April 24, 2017, 04:32:55 AM

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 Undecided

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

guesswho1234

full member

Activity: 155

Merit: 100

Quote from: dobcrypto on April 24, 2017, 04:32:55 AM

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 Undecided

greetings

dobcrypto

full member

Activity: 263

Merit: 101

Authorized Gunbot reseller > gunbot.vip

Quote from: guesswho1234 on April 24, 2017, 04:00:57 AM

Quote from: teknomen on April 23, 2017, 06:35:09 PM

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

Quote from: dobcrypto on April 23, 2017, 05:17:39 PM

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

Quote from: maydna on April 23, 2017, 10:24:45 PM

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

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

full member

Activity: 155

Merit: 100

Quote from: teknomen on April 23, 2017, 06:35:09 PM

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

Quote from: dobcrypto on April 23, 2017, 05:17:39 PM

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

Quote from: maydna on April 23, 2017, 10:24:45 PM

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

anyways i think it should be fixed.

thank you for your patience!

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

greetings

maydna

hero member

Activity: 2912

Merit: 556

Enterapp Pre-Sale Live - bit.ly/3UrMCWI

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

teknomen

newbie

Activity: 45

Merit: 0

Quote from: guesswho1234 on April 18, 2017, 04:05:23 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
feel free to donate (btc): 1L1dUy9iuakec4kSDhs3KuMw3gEfwhuqsJ

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

dobcrypto

full member

Activity: 263

Merit: 101

Authorized Gunbot reseller > gunbot.vip

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

guesswho1234

full member

Activity: 155

Merit: 100

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
feel free to donate (btc): 1L1dUy9iuakec4kSDhs3KuMw3gEfwhuqsJ

shady225

newbie

Activity: 6

Merit: 0

yes i am using excel 2016

guesswho1234

full member

Activity: 155

Merit: 100

Quote from: shady225 on April 14, 2017, 05:23:10 AM

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

Activity: 6

Merit: 0

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

full member

Activity: 155

Merit: 100

Quote from: PlasticCogLiquid on April 13, 2017, 05:28:34 PM

Quote from: guesswho1234 on April 13, 2017, 11:17:11 AM

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

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

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

PlasticCogLiquid

newbie

Activity: 2

Merit: 0

Quote from: guesswho1234 on April 13, 2017, 11:17:11 AM

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

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

full member

Activity: 155

Merit: 100

Quote from: PlasticCogLiquid on April 12, 2017, 02: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.

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

greetings

PlasticCogLiquid

newbie

Activity: 2

Merit: 0

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

full member

Activity: 155

Merit: 100

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!

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