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

My antivirus said that http://www.xup.in is potentially dangerous and does not allow downloading the file = (

UPDATE: DOWNLOAD IN OP

• new design with some thought behind it and somewhat of a theme
• new easy sort functionality for each column (just click on the blue text, sorting alternates between ascending and descending)
• re-implemented the graph and also added a red break even line (data of graph gets selected by clicking on the blue text of the pairings in column A)
• trashed / reworked some of the code to make the workbook a little faster
• new formatting to indicate significance of profit / loss (green = 67 quantile, yellow = 33 quantile, red = rest)
• decided to display the traded volume instead of "amount" since the "amount"-value can be misleading for people who deposited/withdrew coins

also to all who got the object / library not found error:
as far as i am informed this error occurs when you have an outdated version of ms excel which further leads to outdated libraries which are needed to execute my code properly
i dont know yet if i cant get my file to work cross-version but i will keep you updated on this.
as for now i can only provide a version for ms excel 2016 (tested it for this version on various computers in my university and it seems to work pretty smoothly)

PREVIEW:




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


greetings!

my pleasure

dont hesitate to ask if something doesnt work properly!


greetings

I've been searching for a tool like this for quite some time now. I actually found some but they are being sold for some BTC. It is actually good that you are providing this for free. I'll definitely try this one out when I get home as I'm currently at work and can't download the excel file. Good job OP for providing this to us, traders. 

nice work, i will try this, thank you.

you think?

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.

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)

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

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

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

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

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

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

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.

thanks, i appreciate that!

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

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)

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

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 !

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

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.

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

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.

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

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?