deleted

[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

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

[1714102862]

1714102862

[1714102862]

1714102862

[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.
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]

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

[chris330]

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

[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

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

sorry for late reply, i re-download the file, add my tradehistory with all content in the file and this is what i got :



it makes me confuse, what is wrong and i can not found that mistake. or my excel is not compatible with yours?

[guesswho1234]

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

sorry for late reply, i re-download the file, add my tradehistory with all content in the file and this is what i got :

http://i.imgsafe.org/0c43c0a0aa.jpg

it makes me confuse, what is wrong and i can not found that mistake. or my excel is not compatible with yours?

lets see

it seems like you have the version where the chart thingy is still implemented (which is also the part that causes the error in your screenshot).

when you scroll up 2 posts you will see a new version i uploaded on 24.04.2017 where i disabled the chart since the code i needed to implement it caused alot of problems.

so far only 3 or 4 people i know of were able to execute the version with the chart without any problems

and since i dont really know why that is i disabled this feature for the meantime.

if that still does not work but you want it to we can talk on skype and i will edit the file in a way so it works on your pc (already did that once for some guy. took about 5-10 mins)


greetings

[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

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

sorry for late reply, i re-download the file, add my tradehistory with all content in the file and this is what i got :

http://i.imgsafe.org/0c43c0a0aa.jpg

it makes me confuse, what is wrong and i can not found that mistake. or my excel is not compatible with yours?

lets see

it seems like you have the version where the chart thingy is still implemented (which is also the part that causes the error in your screenshot).

when you scroll up 2 posts you will see a new version i uploaded on 24.04.2017 where i disabled the chart since the code i needed to implement it caused alot of problems.

so far only 3 or 4 people i know of were able to execute the version with the chart without any problems

and since i dont really know why that is i disabled this feature for the meantime.

if that still does not work but you want it to we can talk on skype and i will edit the file in a way so it works on your pc (already did that once for some guy. took about 5-10 mins)


greetings

i am trying to download from your post above, open it, enable macro and i am adding my tradehistory again in that file and after that i click "GO" then it show up all my trading history in the past until the last trade. so i am success to use the file but unfortunately, the graphic charts is deleted so i can not see how it looks like but i am fine. thank you very much.

[guesswho1234]

i am trying to download from your post above, open it, enable macro and i am adding my tradehistory again in that file and after that i click "GO" then it show up all my trading history in the past until the last trade. so i am success to use the file but unfortunately, the graphic charts is deleted so i can not see how it looks like but i am fine. thank you very much.

yep i deleted the chart in the latest upload since it caused the file to not work for alot of people.
im trying to find a different solution for this but didnt have time yet

my file is a bit picky with working on other computers. but i tested it at work today and it went perfectly welll there.
so if someone tries it the first time it may be worth to try the second latest upload with the graph still implemented since it might work.

if i have any updates i will, as always, upload it and immediately post it here


greetings


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

[kroongh]

Hello guys,

I have the same problem with your Excel-sheet, but have also found a way to make it work. It seems to have to do with the fact that in my country, the decimal symbol is a comma.
The export from poloniex uses a dot as the decimal symbol and the comma as a separator. So I do the following:

In notepad, I replace all commas (the separators) with a semicolon. For example:

This:

Date,Market,Category,Type,Price,Amount,Total,Fee,Order Number,Base Total Less Fee,Quote Total Less Fee
2017-05-01 20:08:48,BTS/BTC,Exchange,Buy,0.00001085,1843.31747235,0.01999999,0.25%,23264916809,-0.01999999,1838.70917867

Becomes:

Date;Market;Category;Type;Price;Amount;Total;Fee;Order Number;Base Total Less Fee;Quote Total Less Fee
2017-05-01 20:08:48;BTS/BTC;Exchange;Buy;0.00001085;1843.31747235;0.01999999;0.25%;23264916809;-0.01999999;1838.70917867

Now, again in notepad, I replace all dots with a comma.

This:

Date;Market;Category;Type;Price;Amount;Total;Fee;Order Number;Base Total Less Fee;Quote Total Less Fee
2017-05-01 20:08:48;BTS/BTC;Exchange;Buy;0.00001085;1843.31747235;0.01999999;0.25%;23264916809;-0.01999999;1838.70917867

Becomes:

Date;Market;Category;Type;Price;Amount;Total;Fee;Order Number;Base Total Less Fee;Quote Total Less Fee
2017-05-01 20:08:48;BTS/BTC;Exchange;Buy;0,00001085;1843,31747235;0,01999999;0,25%;23264916809;-0,01999999;1838,70917867

Now, i open up calc.xlsm. I do not simply copy the contents of the export file to the 2nd sheet, but use the import function -> Data, from text.

After this I am able to click the go button and everything works as expected, including the graph.

Let me know if this helps anyone else.

[guesswho1234]

Hello guys,

I have the same problem with your Excel-sheet, but have also found a way to make it work. It seems to have to do with the fact that in my country, the decimal symbol is a comma.
The export from poloniex uses a dot as the decimal symbol and the comma as a separator. So I do the following:

In notepad, I replace all commas (the separators) with a semicolon. For example:

This:

Date,Market,Category,Type,Price,Amount,Total,Fee,Order Number,Base Total Less Fee,Quote Total Less Fee
2017-05-01 20:08:48,BTS/BTC,Exchange,Buy,0.00001085,1843.31747235,0.01999999,0.25%,23264916809,-0.01999999,1838.70917867

Becomes:

Date;Market;Category;Type;Price;Amount;Total;Fee;Order Number;Base Total Less Fee;Quote Total Less Fee
2017-05-01 20:08:48;BTS/BTC;Exchange;Buy;0.00001085;1843.31747235;0.01999999;0.25%;23264916809;-0.01999999;1838.70917867

Now, again in notepad, I replace all dots with a comma.

This:

Date;Market;Category;Type;Price;Amount;Total;Fee;Order Number;Base Total Less Fee;Quote Total Less Fee
2017-05-01 20:08:48;BTS/BTC;Exchange;Buy;0.00001085;1843.31747235;0.01999999;0.25%;23264916809;-0.01999999;1838.70917867

Becomes:

Date;Market;Category;Type;Price;Amount;Total;Fee;Order Number;Base Total Less Fee;Quote Total Less Fee
2017-05-01 20:08:48;BTS/BTC;Exchange;Buy;0,00001085;1843,31747235;0,01999999;0,25%;23264916809;-0,01999999;1838,70917867

Now, i open up calc.xlsm. I do not simply copy the contents of the export file to the 2nd sheet, but use the import function -> Data, from text.

After this I am able to click the go button and everything works as expected, including the graph.

Let me know if this helps anyone else.

its also possible to tell excel to convert this by going to file->options->advanced
and then tell excel which characters should seperate decimals and thousands

also if excel is properly set up you shouldnt really need to do any of that since excel is able to handle *.csv files quite well and normally puts every values in its own cell where it is supposed to be if you view the file as a table


greetings

[magictrips]

it looks like a very nice tool 


but i dont can use ist ):

can somebody please help me ?

i get this error "Worksheets(sheetId).Cells(r2, 3).Value = Worksheets(sheetId).Cells(r2, 3).Value + Worksheets(sheetTHId).Cells(r, 7).Value * Worksheets(sheetTHId).Cells(r, .Value"


in my country we use a "," not a "." ..........

and i use a older version of excel, but i think thats not the problem ?

how do i import the poloniex-file ?
under "data" import" "text" ? and ho is it going on ?
to i import the some as in the poloniex-file ? or seperate with a coloum for each thing ?

thank you very much !

[guesswho1234]

it looks like a very nice tool  

thanks, i appreciate that!

in my country we use a "," not a "." ..........

1 post above yours i described how to setup excel regarding the decimal seperator

and i use a older version of excel, but i think thats not the problem ?

i highly recommend to use official ms excel 2016 and it is mandatory to atleast use excel 2007+ (since new file formats were introduced there)

how do i import the poloniex-file ?
under "data" import" "text" ? and ho is it going on ?
to i import the some as in the poloniex-file ? or seperate with a coloum for each thing ?

thank you very much !

you can import the data however you want if the endproduct is correct (i posted a screenshot a while ago which shows how its supposed to look)

but i recomment to open the tradehistory.csv-file with excel since if you have setup excel properly it will open it in exactly the way you need it (as a table).
then you just copy & paste it into my workbook.


greetings

[kroongh]

its also possible to tell excel to convert this by going to file->options->advanced
and then tell excel which characters should seperate decimals and thousands

also if excel is properly set up you shouldnt really need to do any of that since excel is able to handle *.csv files quite well and normally puts every values in its own cell where it is supposed to be if you view the file as a table


greetings

Well, Excel on my computer IS properly set up, I just installed it to test this file. So that's not the problem. The problem is the decimal, which Excel does not change automatically when importing the export.

[guesswho1234]

Well, Excel on my computer IS properly set up, I just installed it to test this file. So that's not the problem. The problem is the decimal, which Excel does not change automatically when importing the export.

there are two solutions for that
#1
set the decimal seperator to "." and from there on can just open the *.csv-file without having to do anything but copy & paste after that

#2
complete import:
https://support.office.com/en-us/article/Text-Import-Wizard-c5b02af6-fda1-4440-899f-f78bafe41857
copy & paste + convert:
https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7

didnt think importing the data could be such a huge problem hope this helps


greetings

[guesswho1234]

INFO:

since this thread is getting longer and a little messy i updated the original post and will from now on keep track of the downloadable files and the current look (as screenshot) on the original post.

so i will still announce all new updates with a new post just like this one but effectively link the file on the first post only.

also just to let you know i will have time to work some more on the file after 12.05.2017 when my essays are done.


greetings

[eXpl0sive]

I also want to try this out. Downloaded the file and now following this thread. Keep up the good work.

[guesswho1234]

I also want to try this out. Downloaded the file and now following this thread. Keep up the good work.

people like you keep me going. thanks for your reply!

if you have any questions make sure to check out the first post in the thread for a little guide.

also if you can spare some BTM to mark me on polo i would really appreciate it so i can get some reputation and people
dont fear to be scammed by me that much


greetings

[magictrips]

sorry, it still doesnt work for me ):

i think i have excel 2007 .............

i have change all "," against ";"
and all "." against "," ......

then i have import it with ";" as seperator.....

if i press "go" then i geht this error:

"Worksheets(sheetId).Cells(r2, 3).Value = Worksheets(sheetId).Cells(r2, 3).Value + Worksheets(sheetTHId).Cells(r, 7).Value * Worksheets(sheetTHId).Cells(r, .Value"



and there is another thing.........

can somebody programm batch ?


whats about an converter to convert
"," against ";"
and all "." against "," ......

automatical ?

i have try this, but iam not good in batch:


@echo off & setlocal enabledelayedexpansion
set "Datei=tradeHistory.txt" 
set "t=temp.tmp" 

set "A=,"
set "B=;"
set "C=."
set "D=,"

if exist "%t%" del "%t%"

for /f "delims=" %%i in ('findstr /n $ "%Datei%"') do set "Line=%%i" & call :ProcessLine
move "%t%" "%Datei%"
goto :W

:ProcessLine

for /f "tokens=1* delims=:" %%a in ("%Line%") do set "L=%%b"
if not defined L >>"%t%" echo\& goto :eof
set WriteLine1=!L:%A%=%B%!
set WriteLine2=!WriteLine1:%C%=%D%!
>>"%t%" echo !WriteLine2!
goto :eof 


:W

[guesswho1234]

sorry, it still doesnt work for me ):

i think i have excel 2007 .............

you think?

i have change all "," against ";"
and all "." against "," ......

then i have import it with ";" as seperator.....

you dont need to do that if you just import the data correctly.
please read the other recent posts or the first post of the thread to avoid redundancies.

if i press "go" then i geht this error:

"Worksheets(sheetId).Cells(r2, 3).Value = Worksheets(sheetId).Cells(r2, 3).Value + Worksheets(sheetTHId).Cells(r, 7).Value * Worksheets(sheetTHId).Cells(r, .Value"

this is not an error but only a piece of code :S

to better help you i need a screenshot of your tradehistory sheet and the actual error-message.
you can also add me on skype for this so we dont spam the thread with stuff nobody needs.
also we can talk in german in skype (i assume you are a native german)

and there is another thing.........

can somebody programm batch ?


whats about an converter to convert
"," against ";"
and all "." against "," ......

automatical ?

i have try this, but iam not good in batch:

Code:

@echo off & setlocal enabledelayedexpansion 
set "Datei=tradeHistory.txt"  
set "t=temp.tmp"  

set "A=," 
set "B=;" 
set "C=." 
set "D=,"

if exist "%t%" del "%t%" 

for /f "delims=" %%i in ('findstr /n $ "%Datei%"') do set "Line=%%i" & call :ProcessLine 
move "%t%" "%Datei%" 
goto :W 

:ProcessLine 

for /f "tokens=1* delims=:" %%a in ("%Line%") do set "L=%%b" 
if not defined L >>"%t%" echo\& goto :eof 
set WriteLine1=!L:%A%=%B%! 
set WriteLine2=!WriteLine1:%C%=%D%! 
>>"%t%" echo !WriteLine2! 
goto :eof  


:W

this is completelly off-topic and not needed if you, again, import the data correctly. please dont post such walls of text which are off-topic while not even using the code-formatting the forum offers. thanks.


greetings

[ofergul]

nice work, i will try this, thank you.