|
Title: deleted Post by: guesswho1234 on July 10, 2016, 09:18:27 PM deleted
Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: el kaka22 on September 18, 2016, 08:34:50 PM So, you are providing an Excel sheet with macro functionality for free of cost. Nice try bro, keep it up.
But I have not heard any file hosting in the name of xup, so fear to open your links. I like to have any screen shot for excel sheet with data and how to use it effectively if possible. Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on September 18, 2016, 08:45:27 PM So, you are providing an Excel sheet with macro functionality for free of cost. Nice try bro, keep it up. Exactly. At first i made it just for me to keep track of my trading but someday i just thought why not share it and here it is. But I have not heard any file hosting in the name of xup, so fear to open your links. I like to have any screen shot for excel sheet with data and how to use it effectively if possible. Well i just typed "one click filehoster" into google this one seemed the easiest one upload some file. This is a screenshot of the version i am currently using (a little bit older than the version i uploaded): https://i.imgsafe.org/f0099efe6b.png But if you still dont trust me you can just tinker it together yourself. All you have to do is: Make a new Excel-File with 3 sheets (first one = main-sheet where you put the code into, second one is where you paste the tradehistory-data and the third one is where you paste the deposithistory-data) Add a button to sheet one with the name CommandButton1 (not the caption; caption can be whatever you want) Paste the code from below into the main-sheet by Right-Click onto the main-sheet (down at the ribbon) -> Show Code -> Paste Save it as <whatever>.xlsm (its important that you choose *.xlsm since you want to use a macro in this file) Voila! The only thing missing is the formatting but otherwise you should get the same result more or less. The code: Code: Private Sub CommandButton1_Click() greetings! Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: Winner on September 18, 2016, 08:55:31 PM It isn't everyday that someone posts a free product in this particular section. Thanks for the Macro, I might see if I can get some use out of this via Excel.
How did you find this? Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on September 18, 2016, 09:01:47 PM It isn't everyday that someone posts a free product in this particular section. Thanks for the Macro, I might see if I can get some use out of this via Excel. Isnt most of crypto stuff open source etc.?Also to make it easier you can just follow the steps from above if you want to implement the code by yourself. Remember though that the formatting will not be the same since i didnt format the "output-table" with the macro. How did you find this? Well i am a parttime softwaredev and wanted to contribute to the cryptoworld. Even if its not much its still something and i found it quite useful for myself so far.So i didnt find it anywhere. I just made it myself. greetings! Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: FaucetRank.com on September 19, 2016, 02:55:08 AM I downloaded your excel file and later I shall check how it can help me to analyze poloniex coin data. I hope it will be very useful.
Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: Golftech on September 19, 2016, 05:55:40 AM I downloaded your excel file and later I shall check how it can help me to analyze poloniex coin data. I hope it will be very useful. i will wait for your comments mate let me see if its useful i just started to trade as well so im looking for some helpful things to keep my trade updated.Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: STT on September 19, 2016, 06:30:40 AM So, you are providing an Excel sheet with macro functionality for free of cost. Nice try bro, keep it up. But I have not heard any file hosting in the name of xup, so fear to open your links. I like to have any screen shot for excel sheet with data and how to use it effectively if possible. There is a general guide to websites, even google can be used roughly to gauge a website. The worst sites are generally labelled by some service. Here is one of them and its verdict on this host is good https://www.mywot.com/en/scorecard/xup.in?utm_source=addon&utm_content=rw-viewsc Doesnt mean the actual file is ok, Im not sure nowadays if excel allows anything really dangerous. Its microsoft, probably :D Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on September 19, 2016, 10:28:54 AM So, you are providing an Excel sheet with macro functionality for free of cost. Nice try bro, keep it up. Doesnt mean the actual file is ok, Im not sure nowadays if excel allows anything really dangerous. Its microsoft, probably :DBut I have not heard any file hosting in the name of xup, so fear to open your links. I like to have any screen shot for excel sheet with data and how to use it effectively if possible. Furthermore you could just follow the instructions from my initial post where i explain how you can prevent macros from being started (renaming the file from *.xlsm to *.xlsx). I think with all the stuff i provided it should be possible for everyone to test my file savely. Here some more pictures: https://i.imgsafe.org/fbd7a049e9.png https://i.imgsafe.org/fbd7ccd62f.png https://i.imgsafe.org/fbd7d9613b.png https://i.imgsafe.org/fbd7ba8a4b.png greetings! Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on October 07, 2016, 03:41:15 PM UPDATE:
+ improved datepicker https://i.imgsafe.org/7c39d2caa5.png I hope you guys like it and i am open for feedback! greetings! File: http://www.xup.in/dl,19204092/calc.xlsm/ feel free to donate (btc): 1L1dUy9iuakec4kSDhs3KuMw3gEfwhuqsJ Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: Millionero on March 16, 2017, 10:15:21 PM following
Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: chris330 on March 23, 2017, 09:02:59 PM I'm still lost in what could be this one file "Transactionhistory.csv" poloniex offfers deposit and withdrawl, tradehistory, lendinghistory.. where u get that one? +1 still looking for that myself ??? Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on March 23, 2017, 11:06:16 PM I'm still lost in what could be this one file "Transactionhistory.csv" poloniex offfers deposit and withdrawl, tradehistory, lendinghistory.. where u get that one? I'm still lost in what could be this one file "Transactionhistory.csv" poloniex offfers deposit and withdrawl, tradehistory, lendinghistory.. where u get that one? +1 still looking for that myself ??? either they have renamed it or it was wrong the whole time anyways whats ment is the d & w history sry for that one ::) Just noticed that people might not exclusively trade <altcoin> / btc which means as soon as you f.e. trade xmr / usdt my workbook could break. I didnt try what exactly happens if you do so but im sure it will alter the results. So keep that in mind when you are using my current version. Im planning to fix this as soon as possible but dont know yet when i have time for that. greetings! feel free to donate (btc): 1L1dUy9iuakec4kSDhs3KuMw3gEfwhuqsJ UPDATE: + quick fix for the above problem so that you now get the correct profit/loss BTC value (have not found time yet to implement that you can choose between BTC, USDT, etc. ... it is on my list though) I hope you guys like it and i am open for feedback! greetings! File: http://www.xup.in/dl,15547789/calc.xlsm/ feel free to donate (btc): 1L1dUy9iuakec4kSDhs3KuMw3gEfwhuqsJ Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: chris330 on March 28, 2017, 09:51:07 AM I cannot get this to work at all ???
Get a compile error "cant find project or library" Virus Total for others for people worried about the file https://www.virustotal.com/en/file/2edffe063d34a127f2f6d4d5199111faf7241f50bf0a292446e836b557f567b7/analysis/1490696890/ Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on March 28, 2017, 04:38:07 PM I cannot get this to work at all ??? got a screenshot maybe? Get a compile error "cant find project or library" Virus Total for others for people worried about the file https://www.virustotal.com/en/file/2edffe063d34a127f2f6d4d5199111faf7241f50bf0a292446e836b557f567b7/analysis/1490696890/ also are you using a mac? sadly it somehow does not work on macs i can also offer you to add me on skype: constraccta greetings Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: hanisnl on March 31, 2017, 09:37:04 PM Hi there !
Nice job building this . I think you should revise the XML as it has 3 sheets : calc tradeHistory transactionHistory I think maybe the tradeHistory is the deposit history ? or ? EDIT: also, I canțt get this work .. I get an error in the macros : Method or Data member not found - when I try to select multiple dates. .. the macro is looking for COLUMN L2: ActiveChart.FullSeriesCollection(1).Values = "=tradeHistory!$L$2:$L$" & r - 1 I think that should be the date, and for example when I export all trade history I have the date in the first column . ... also the selection is a bit weird .. you are better with CTRL+click on each date... but maybe it should take into account all the data by default . I hope you get a working example up soon ! good luck ! Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: Klon522 on April 01, 2017, 12:51:36 AM Hi guesswho1234,
thank you very much for your effort on this programm. Is it mandatory to use MS Office for that? Because i got an error, when i press go. I use LibreOffice 5.3.1.2. c/ximg.php?fid=55233911[/img] (http://http[Suspicious link removed) No difference with or without the data from polo provided. Also,i cant set the date right. I can choose year and month, but not the day. Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 01, 2017, 10:53:38 AM I think you should revise the XML as it has 3 sheets : the reason for this is so that each data-input is seperate and nothing gets confusedcalc tradeHistory transactionHistory so the calc sheet is the main sheet where all the macro stuff happens while the other 2 sheets are only for data you export from poloniex I think maybe the tradeHistory is the deposit history ? or ? tradeHistory = history from all your trades on poloniex (https://poloniex.com/tradeHistory)depositHistory = history fromm all your deposits on poloniex (https://poloniex.com/depositHistory) EDIT: i am a little confused with what you are doing. also, I canțt get this work .. I get an error in the macros : Method or Data member not found - when I try to select multiple dates. .. the macro is looking for COLUMN L2: ActiveChart.FullSeriesCollection(1).Values = "=tradeHistory!$L$2:$L$" & r - 1 I think that should be the date, and for example when I export all trade history I have the date in the first column . what do you mean by "select multiple dates"? afterall you should select a timeframe with the datepicker (from-date, to-date). also the error you get has nothing to do with the date. the "L"-Column should be empty when you import your data (it gets filled by the macro and is used for the graph). it is correct that the first column is the date in the data from poloniex. thats the way it should be ... also the selection is a bit weird .. you are better with CTRL+click on each date... but maybe it should take into account all the data by default . again i dont know what you are doing with the dates.this is how it is suppoed to work (which it does on my computer atleast :P) for both dates (from-date, to-date): -select month and year with the dropdown that opens when you click into the cell -click on the cells for selecting a day (no dropdown there. it just takes the day you clicked on) -if you do that the written date in the cell below the datepicker should change respectively (you could change that date manually too but is not recommended since the format needs to be correct. use the datepicker) -hit go maybe re-download my file and try this without any data. if that works you can again import your poloniex data as described. greetings Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 01, 2017, 11:06:56 AM Hi guesswho1234, yesthank you very much for your effort on this programm. Is it mandatory to use MS Office for that? Because i got an error, when i press go. I use LibreOffice 5.3.1.2. it would be a miracle if any excel fake would be able to do what the original is capable of doing c/ximg.php?fid=55233911[/img] (http://http[Suspicious link removed) your link somehow got removed. try https://imgsafe.org/ maybeNo difference with or without the data from polo provided. Also,i cant set the date right. I can choose year and month, but not the day. also i think the reason that it does not work is beacuse you are not using ms excel. sorry for that i can only provide it for ms excel. btw. if you are a student you should get a free license for all ms office products from your university. greetings Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: Klon522 on April 01, 2017, 12:59:33 PM Thank you for your answer.
Here the image with the error on your suggested site: https://i.imgsafe.org/f9f23eb8ee.jpg 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. Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 01, 2017, 03:52:12 PM Thank you for your answer. looked at your screenshot and it seems that the only problem is the chart implementationHere the image with the error on your suggested site: https://i.imgsafe.org/f9f23eb8ee.jpg 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. haha well i dont like ms stuff either except excel since i cant find any program offering the depth that excel doesand 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. greetings Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: Klon522 on April 03, 2017, 01:55:30 PM 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. Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 03, 2017, 05:53:00 PM THANK YOU! didnt think this little file would cause so much problems with so many people ???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. 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: mettalmag on April 06, 2017, 01:38:33 PM this looks nice, I have to try it asap
Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 06, 2017, 04:46:47 PM 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! Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: PlasticCogLiquid on 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. Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 13, 2017, 04:17:11 PM Thanks! Worked in Excel 2016 for me, everything else failed. im happy to hear that it works for atleast one person besides me :DThis 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. greetings Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: PlasticCogLiquid on April 13, 2017, 10:28:34 PM im happy to hear that it works for atleast one person besides me :D 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! Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 13, 2017, 10:31:10 PM im happy to hear that it works for atleast one person besides me :D 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! 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: shady225 on April 14, 2017, 10: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" Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 14, 2017, 12:01:48 PM how can i insert the deposit history and trading history in the sheet? are you using ms excel 2016? 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" 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: shady225 on April 14, 2017, 12:53:37 PM yes i am using excel 2016
Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 18, 2017, 09: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 <amount> feel free to donate (btc): 1L1dUy9iuakec4kSDhs3KuMw3gEfwhuqsJ Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: dobcrypto on April 23, 2017, 10:17:39 PM Wow, Thx man!
Goin to try it asap. Hm... https://i.imgsafe.org/d2d88af418.png Try to install MS Offis 2016 In 2016 i see Code: Run time error 9 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: teknomen on 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: maydna on 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 : http://i.imgsafe.org/d6b6457050.jpg 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 http://i.imgsafe.org/d6e970155f.jpg Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 24, 2017, 09:00:57 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 Code: Run time error 9 hi, for some reason i deleted the declaration of the variable r2. dunno why it worked on my side because it really shouldnt have :Di'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 anyways i think it should be fixed. thank you for your patience! File: http://www.xup.in/dl,14148873/CALC.XLSM/ greetings Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: dobcrypto on 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 Code: Run time error 9 hi, for some reason i deleted the declaration of the variable r2. dunno why it worked on my side because it really shouldnt have :Di'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 anyways i think it should be fixed. thank you for your patience! File: http://www.xup.in/dl,14148873/CALC.XLSM/ greetings The same error Code: Run time error 9 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 24, 2017, 09:35:55 AM It dosn't work for me to =( may i ask what steps exactly you took?The same error Code: Run time error 9 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: dobcrypto on April 24, 2017, 12:32:20 PM It dosn't work for me to =( may i ask what steps exactly you took?The same error Code: Run time error 9 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 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 24, 2017, 01:36:41 PM It dosn't work for me to =( may i ask what steps exactly you took?The same error Code: Run time error 9 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 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 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: https://i.imgsafe.org/e01294b7ec.png big sorry for not giving that info! greetings Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: dobcrypto on April 24, 2017, 01:52:20 PM It dosn't work for me to =( may i ask what steps exactly you took?The same error Code: Run time error 9 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 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 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: https://i.imgsafe.org/e01294b7ec.png big sorry for not giving that info! greetings 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... Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 24, 2017, 02:53:32 PM 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: chris330 on April 25, 2017, 05:44:00 PM 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 8) Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: maydna on April 26, 2017, 04:02:09 PM hi, for some reason i deleted the declaration of the variable r2. dunno why it worked on my side because it really shouldnt have :Di'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 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? Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 26, 2017, 07:39:06 PM hi, for some reason i deleted the declaration of the variable r2. dunno why it worked on my side because it really shouldnt have :Di'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 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? 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: maydna on April 27, 2017, 02:43:39 AM hi, for some reason i deleted the declaration of the variable r2. dunno why it worked on my side because it really shouldnt have :Di'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 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? 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. Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on April 27, 2017, 04:29:51 PM 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: kroongh on May 01, 2017, 08:28:58 PM 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. Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on May 01, 2017, 09:53:07 PM Hello guys, its also possible to tell excel to convert this by going to file->options->advancedI 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. 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: magictrips on May 02, 2017, 12:33:38 AM 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, 8).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 ! Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on May 02, 2017, 07:05:10 AM 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 seperatorand 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 ? 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)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 ! 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: kroongh on May 02, 2017, 11:26:38 AM 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. Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on May 02, 2017, 12:20:44 PM 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 (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 (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 :D hope this helps greetings Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on May 02, 2017, 12:53:37 PM 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: eXpl0sive on May 02, 2017, 12:54:55 PM I also want to try this out. Downloaded the file and now following this thread. Keep up the good work.
Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on May 02, 2017, 05:33:54 PM 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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: magictrips on May 03, 2017, 01:12:03 AM 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, 8).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 Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on May 03, 2017, 07:14:27 AM sorry, it still doesnt work for me ): you think? :Di think i have excel 2007 ............. i have change all "," against ";" you dont need to do that if you just import the data correctly.and all "." against "," ...... then i have import it with ";" as seperator..... 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: this is not an error but only a piece of code :S"Worksheets(sheetId).Cells(r2, 3).Value = Worksheets(sheetId).Cells(r2, 3).Value + Worksheets(sheetTHId).Cells(r, 7).Value * Worksheets(sheetTHId).Cells(r, 8).Value" 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......... 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.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 greetings Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: ofergul on May 05, 2017, 01:42:11 PM nice work, i will try this, thank you.
Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: JanpriX on May 05, 2017, 05:36:04 PM 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. ;D
Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on May 05, 2017, 06:42:29 PM 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. ;D my pleasuredont hesitate to ask if something doesnt work properly! greetings Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on May 05, 2017, 09:08:06 PM UPDATE: DOWNLOAD IN OP
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: https://i.imgsafe.org/fa06415503.png i hope you guys like it and i am open for feedback! greetings! Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: imtaurin on May 09, 2017, 07:31:02 PM My antivirus said that http://www.xup.in is potentially dangerous and does not allow downloading the file = (
Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on May 09, 2017, 07:42:06 PM My antivirus said that http://www.xup.in is potentially dangerous and does not allow downloading the file = ( you are the first one to report this problem.if you like i can send it to you via skype. greetings Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: teknomen on May 12, 2017, 03:42:49 PM UPDATE: DOWNLOAD IN OP
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: https://i.imgsafe.org/fa06415503.png i hope you guys like it and i am open for feedback! greetings! please can you upload the last version on other server i can't download it from that site Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: guesswho1234 on May 12, 2017, 04:47:27 PM UPDATE: DOWNLOAD IN OP
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: https://i.imgsafe.org/fa06415503.png i hope you guys like it and i am open for feedback! greetings! please can you upload the last version on other server i can't download it from that site you can add me in skype (constraccta) if you want. greetings Title: Re: excel-sheet for the tradehistory.csv export from poloniex Post by: teknomen on May 18, 2017, 01:43:15 AM UPDATE: DOWNLOAD IN OP
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: https://i.imgsafe.org/fa06415503.png i hope you guys like it and i am open for feedback! greetings! please can you upload the last version on other server i can't download it from that site you can add me in skype (constraccta) if you want. greetings any server like mediafire depositfile thanks Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on May 18, 2017, 06:10:00 PM UPDATE: DOWNLOAD IN OP
PREVIEW: http://i68.tinypic.com/313m4b9.png i hope you guys like it and i am open for feedback! greetings! Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: ofergul on May 18, 2017, 11:58:22 PM UPDATE: DOWNLOAD IN OP
PREVIEW: http://i68.tinypic.com/313m4b9.png i hope you guys like it and i am open for feedback! greetings! thanks for the update, works great Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: Ucy on May 19, 2017, 12:11:36 AM Please can anyone help explain it uses. Being seeing this thread ever since I joined Bitcointalk still don't understand the use of its Spreadsheet. Looks like something I will need as a Trader
Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on May 19, 2017, 07:54:33 AM Please can anyone help explain it uses. Being seeing this thread ever since I joined Bitcointalk still don't understand the use of its Spreadsheet. Looks like something I will need as a Trader you might want to check the first post in the thread again since i update it whenever i put new version out.in case you already did that let me try it this way. the use of the spreadsheet is to evaluate your trades on poloniex.com from the past. for example it lists you all the profits/losses you made with each coin you traded. furthermore you can take a closer look at each single coin too. it is nothing you need at all, it is just a tool i initially made for myself to keep everthing in check. you also could just use the trade analysis tool which poloniex offers but this might get a little frustrating if you have traded alot since its very minimalistic. but i think its best to just try it for yourself ;) in case you have more questions about it let me know. greetings Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: Ucy on May 19, 2017, 10:09:23 AM Please can anyone help explain it uses. Being seeing this thread ever since I joined Bitcointalk still don't understand the use of its Spreadsheet. Looks like something I will need as a Trader you might want to check the first post in the thread again since i update it whenever i put new version out.in case you already did that let me try it this way. the use of the spreadsheet is to evaluate your trades on poloniex.com from the past. for example it lists you all the profits/losses you made with each coin you traded. furthermore you can take a closer look at each single coin too. it is nothing you need at all, it is just a tool i initially made for myself to keep everthing in check. you also could just use the trade analysis tool which poloniex offers but this might get a little frustrating if you have traded alot since its very minimalistic. but i think its best to just try it for yourself ;) in case you have more questions about it let me know. greetings Thanks alot. Dont have MS EXCEL 2016 yet. Will install later Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on May 19, 2017, 10:16:14 AM Please can anyone help explain it uses. Being seeing this thread ever since I joined Bitcointalk still don't understand the use of its Spreadsheet. Looks like something I will need as a Trader you might want to check the first post in the thread again since i update it whenever i put new version out.in case you already did that let me try it this way. the use of the spreadsheet is to evaluate your trades on poloniex.com from the past. for example it lists you all the profits/losses you made with each coin you traded. furthermore you can take a closer look at each single coin too. it is nothing you need at all, it is just a tool i initially made for myself to keep everthing in check. you also could just use the trade analysis tool which poloniex offers but this might get a little frustrating if you have traded alot since its very minimalistic. but i think its best to just try it for yourself ;) in case you have more questions about it let me know. greetings Thanks alot. Dont have MS EXCEL 2016 yet. Will install later Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: p3ppymon on May 20, 2017, 09:39:47 PM I have downloaded the latest version. However, I cannot run the macro. Error: Method or data member not found Please help Working! I updated the Office package to the newest version. Thanks for your prompt reply. Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on May 20, 2017, 10:28:06 PM I have downloaded the latest version. However, I cannot run the macro. Error: Method or data member not found Please help Working! I updated the Office package to the newest version. Thanks for your prompt reply. you imported the poloniex-data with the import-wizard? also have you read the HOWTO from the OP in this thread? greetings no problem, im glad it works now! if you have more questions feel free to ask. also if you like my work i would really appreciate it if you could mark me on polo (only costs you a few cents) :) greetings Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: p3ppymon on May 20, 2017, 11:07:41 PM Thanks a lot. Marked on polo. Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: p3ppymon on June 03, 2017, 10:05:43 PM @OP,
I can see some discrepancies between what I can see on Poloniex stats and what is tabulated and plotted in your sheet. Let's consider the BCN/BTC pair. Your tabulated results is negative, whilst the graph and the outcome from Poloniex analysis seems to match (and positive at least ;D). https://i.imgur.com/h4sWsQ0.jpg https://i.imgur.com/zmYqmh5.jpg https://i.imgur.com/yq25cJf.jpg Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on June 04, 2017, 08:04:15 AM @OP, the reason for the difference is that the tabulated value always gets displayed for your selected timeframe (the part of the graph thats in a brighter blue)I can see some discrepancies between what I can see on Poloniex stats and what is tabulated and plotted in your sheet. Let's consider the BCN/BTC pair. Your tabulated results is negative, whilst the graph and the outcome from Poloniex analysis seems to match (and positive at least ;D). https://i.imgur.com/h4sWsQ0.jpg https://i.imgur.com/zmYqmh5.jpg https://i.imgur.com/yq25cJf.jpg if you expand your timeframe to include all your trades it should match polo again ;) greetings Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: p3ppymon on June 04, 2017, 09:10:56 AM @OP, the reason for the difference is that the tabulated value always gets displayed for your selected timeframe (the part of the graph thats in a brighter blue)I can see some discrepancies between what I can see on Poloniex stats and what is tabulated and plotted in your sheet. Let's consider the BCN/BTC pair. Your tabulated results is negative, whilst the graph and the outcome from Poloniex analysis seems to match (and positive at least ;D). https://i.imgur.com/h4sWsQ0.jpg https://i.imgur.com/zmYqmh5.jpg https://i.imgur.com/yq25cJf.jpg if you expand your timeframe to include all your trades it should match polo again ;) greetings I am such a noob! Thanks! Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: chris330 on June 30, 2017, 02:55:03 PM PM'd you dude
Amazing how far this spreadsheet has come, for people who trade on POLO this is absolutely amazing and for me works flawless without any issues Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on June 30, 2017, 03:19:02 PM just to let everyone who might be interested in updates know:
i am looking forward to finish the points listed in "UPCOMING" as soon as im done with my exams (last one at 13.07.2017). greetings Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: p3ppymon on June 30, 2017, 04:22:29 PM just to let everyone who might be interested in updates know: i am looking forward to finish the points listed in "UPCOMING" as soon as im done with my exams (last one at 13.07.2017). greetings Good luck with your exams! Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on June 30, 2017, 08:43:19 PM just to let everyone who might be interested in updates know: i am looking forward to finish the points listed in "UPCOMING" as soon as im done with my exams (last one at 13.07.2017). greetings Good luck with your exams! Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: eddied316 on July 05, 2017, 07:37:39 PM You should make one for Bittrex. I'll donate a quick 0.01 BTC
Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on July 05, 2017, 08:43:57 PM You should make one for Bittrex. I'll donate a quick 0.01 BTC if you can send me an example of the export data from bittrex i can do that for you no probem ;)greetings Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: eddied316 on July 05, 2017, 08:48:56 PM You should make one for Bittrex. I'll donate a quick 0.01 BTC if you can send me an example of the export data from bittrex i can do that for you no probem ;)greetings Sent. Check your inbox :) Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on July 05, 2017, 08:52:22 PM You should make one for Bittrex. I'll donate a quick 0.01 BTC if you can send me an example of the export data from bittrex i can do that for you no probem ;)greetings Sent. Check your inbox :) i will try to get it done as fast as possible allthought i cant promise anything before 13.07.2017 will keep you posted greetings Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: eddied316 on July 05, 2017, 08:56:05 PM You should make one for Bittrex. I'll donate a quick 0.01 BTC if you can send me an example of the export data from bittrex i can do that for you no probem ;)greetings Sent. Check your inbox :) i will try to get it done as fast as possible allthought i cant promise anything before 13.07.2017 will keep you posted greetings No Problem. Should be fairly easy as a lot of the columns are the same. Title: Re: Poloniex Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on July 05, 2017, 09:02:48 PM You should make one for Bittrex. I'll donate a quick 0.01 BTC if you can send me an example of the export data from bittrex i can do that for you no probem ;)greetings Sent. Check your inbox :) i will try to get it done as fast as possible allthought i cant promise anything before 13.07.2017 will keep you posted greetings No Problem. Should be fairly easy as a lot of the columns are the same. greetings Title: Re: Poloniex (and Bittrec [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on July 09, 2017, 02:56:19 PM UPDATE: DOWNLOAD IN OP
Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: Yusufmet on July 15, 2017, 01:08:27 PM Hi, Spreadsheet works except detail graph. When I click coin name it gives runtime error 13 in line 404:
Sheets(2).Range("$A:$K").AutoFilter Field:=1, Criteria1:=">=" & ActiveSheet.Cells(1, 22).Value, Operator:=xlAnd, Criteria2:="<=" & ActiveSheet.Cells(1, 29).Value I have win 7, excel pro 2013 plus. Any comments? Title: Re: Poloniex (and Bittrec [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: ofergul on July 15, 2017, 03:31:30 PM UPDATE: DOWNLOAD IN OP
great man, keep up the good work. Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: p3ppymon on July 15, 2017, 05:22:45 PM Hi, Spreadsheet works except detail graph. When I click coin name it gives runtime error 13 in line 404: Sheets(2).Range("$A:$K").AutoFilter Field:=1, Criteria1:=">=" & ActiveSheet.Cells(1, 22).Value, Operator:=xlAnd, Criteria2:="<=" & ActiveSheet.Cells(1, 29).Value I have win 7, excel pro 2013 plus. Any comments? you should upgrade the office package to a more recent version. Otherwise it won't work! Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on July 16, 2017, 02:59:58 PM Hi, Spreadsheet works except detail graph. When I click coin name it gives runtime error 13 in line 404: i would go with p3ppymons response.Sheets(2).Range("$A:$K").AutoFilter Field:=1, Criteria1:=">=" & ActiveSheet.Cells(1, 22).Value, Operator:=xlAnd, Criteria2:="<=" & ActiveSheet.Cells(1, 29).Value I have win 7, excel pro 2013 plus. Any comments? i cant really tell for sure since i dont use excel pro 2013 but i think you indeed need a more recent version. i always recommend to use the most recent version if possible! win 7 isnt the problem since i use that too. UPDATE: DOWNLOAD IN OP
great man, keep up the good work. greetings Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: CreativeHitez on July 23, 2017, 06:23:50 PM I was able to upload my order history on Bittrex and upon pressing start I received an error:
Code: Run-time error '9': Subscript out of range Code: While r_next I admire your generosity, doing this for free... Thank you. Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on July 23, 2017, 08:08:20 PM I was able to upload my order history on Bittrex and upon pressing start I received an error: hmm hard to pin point what went wrong here.Code: Run-time error '9': Subscript out of range Code: While r_next if you dont mind me seeing your data you can send it do me and i will see what i can do for you. otherwise i can offer skype / teamviewer. just pmme ;) I admire your generosity, doing this for free... Thank you. my pleasure! the more people profit from it the better!greetings Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: utdrmac on August 03, 2017, 07:30:11 PM Any chance of this ever working with Google Sheets? I don't have MSExcel.
Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: p3ppymon on August 04, 2017, 10:13:18 AM Any chance of this ever working with Google Sheets? I don't have MSExcel. I do not think so as the online version is quite limited. Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on August 04, 2017, 10:48:10 AM Any chance of this ever working with Google Sheets? I don't have MSExcel. i already tried that with no good outcome tho.im sorry greetings Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: dobcrypto on August 10, 2017, 08:18:19 AM Wery cool Spreadsheet, many thx!
Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: jkminkov on August 16, 2017, 02:22:12 PM can you expand to do list with prossessing lendingHistory.csv with some stats?
Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on August 16, 2017, 05:20:25 PM can you expand to do list with prossessing lendingHistory.csv with some stats? i will think about it ;)if you can send me some sample data that would be nice since i dont do lending on poloniex. greetings Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: jkminkov on August 16, 2017, 08:58:39 PM Code: Currency,Rate,Amount,Duration,Interest,Fee,Earned,Open,Close Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: mycho on August 25, 2017, 08:50:06 PM I was able to upload my order history on Bittrex and upon pressing start I received an error: hmm hard to pin point what went wrong here.Code: Run-time error '9': Subscript out of range Code: While r_next if you dont mind me seeing your data you can send it do me and i will see what i can do for you. otherwise i can offer skype / teamviewer. just pmme ;) I admire your generosity, doing this for free... Thank you. my pleasure! the more people profit from it the better!greetings Hi ! Have you been able to fix this issue ? I have the same problem when I click start after selecting the BIttrex CSV file Thanks Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on August 25, 2017, 10:05:25 PM I was able to upload my order history on Bittrex and upon pressing start I received an error: hmm hard to pin point what went wrong here.Code: Run-time error '9': Subscript out of range Code: While r_next if you dont mind me seeing your data you can send it do me and i will see what i can do for you. otherwise i can offer skype / teamviewer. just pmme ;) I admire your generosity, doing this for free... Thank you. my pleasure! the more people profit from it the better!greetings Hi ! Have you been able to fix this issue ? I have the same problem when I click start after selecting the BIttrex CSV file Thanks if you dont mind sending me the data with which you tried it i will try to debug it for you. you can add me on skype (constraccta) or pmme here. greetings Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: mycho on August 27, 2017, 09:27:19 PM I was able to upload my order history on Bittrex and upon pressing start I received an error: hmm hard to pin point what went wrong here.Code: Run-time error '9': Subscript out of range Code: While r_next if you dont mind me seeing your data you can send it do me and i will see what i can do for you. otherwise i can offer skype / teamviewer. just pmme ;) I admire your generosity, doing this for free... Thank you. my pleasure! the more people profit from it the better!greetings Hi ! Have you been able to fix this issue ? I have the same problem when I click start after selecting the BIttrex CSV file Thanks if you dont mind sending me the data with which you tried it i will try to debug it for you. you can add me on skype (constraccta) or pmme here. greetings Perfect, PM me an e-mail address where I can send my file Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: toomeke on August 28, 2017, 07:40:43 PM I was able to upload my order history on Bittrex and upon pressing start I received an error: hmm hard to pin point what went wrong here.Code: Run-time error '9': Subscript out of range Code: While r_next if you dont mind me seeing your data you can send it do me and i will see what i can do for you. otherwise i can offer skype / teamviewer. just pmme ;) I admire your generosity, doing this for free... Thank you. my pleasure! the more people profit from it the better!greetings Hi ! Have you been able to fix this issue ? I have the same problem when I click start after selecting the BIttrex CSV file Thanks Hi, I also have the same issue 'Run-time error '9': Subscript out of range' Looks really promising! Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: toomeke on August 31, 2017, 11:15:29 AM I was able to upload my order history on Bittrex and upon pressing start I received an error: hmm hard to pin point what went wrong here.Code: Run-time error '9': Subscript out of range Code: While r_next if you dont mind me seeing your data you can send it do me and i will see what i can do for you. otherwise i can offer skype / teamviewer. just pmme ;) I admire your generosity, doing this for free... Thank you. my pleasure! the more people profit from it the better!greetings Hi ! Have you been able to fix this issue ? I have the same problem when I click start after selecting the BIttrex CSV file Thanks Hi, I also have the same issue 'Run-time error '9': Subscript out of range' Looks really promising! Anyupdate peeps? Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: BryanC on September 08, 2017, 04:36:08 AM The source of the problem appears to be that the data exported from Bittrex does not match what the spreadsheet is expecting to see. There are definitely fewer fields coming from Bittrex than there are columns that expect data in the spreadsheet.
I was able to upload my order history on Bittrex and upon pressing start I received an error: hmm hard to pin point what went wrong here.Code: Run-time error '9': Subscript out of range Code: While r_next if you dont mind me seeing your data you can send it do me and i will see what i can do for you. otherwise i can offer skype / teamviewer. just pmme ;) I admire your generosity, doing this for free... Thank you. my pleasure! the more people profit from it the better!greetings Hi ! Have you been able to fix this issue ? I have the same problem when I click start after selecting the BIttrex CSV file Thanks Hi, I also have the same issue 'Run-time error '9': Subscript out of range' Looks really promising! Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: vit05 on September 09, 2017, 06:45:56 PM How does the graphics work?
Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: atorrealba on October 03, 2017, 01:02:46 AM I was able to upload my order history on Bittrex and upon pressing start I received an error: Code: Run-time error '9': Subscript out of range Code: While r_next I admire your generosity, doing this for free... Thank you. I have noticed this same issue, it seems like the code's formulas are not matching with the spreadsheet's data. For instance it would reference D2 as the Limit Type but that value should reference C2 as D2 is actually the column for the Quantity. There are cell referencing issues on the Bittrex .xlms file that need to be addressed/fixed because importing the data is not the issue at hand but rather the CSV file's format/layout is lost in translation from the Excel sheet's correct referencing , while the Poloniex .xlms file works properly on MS2013 and MS2016. If there is any way you can debug the script which I have tried however it seems to give me another error for a value of some sort. But mainly the Bittrex file is not 100% up-to par and able to work correctly. I'm unsure if it could be whether Bittrex changed the CSV layout or if the column numbers were simply readjusted and based on Poloniex's order history CSV file which I believe is the case. If OP could please address this issue and re-script the Bittrex file to match with the Bittrex order CSV, that would be appreciated Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: filtr0w on October 29, 2017, 12:02:42 PM excellent tool too bad i cannot upload it on onedrive for some reason :( maybe because i dont have a paid suscription to office365?
Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: filtr0w on October 29, 2017, 12:14:23 PM and +1 to adapt it better to bittrex, definitely will keep being the biggest altcoin platform for a long time...
Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on October 30, 2017, 10:09:01 PM excellent tool too bad i cannot upload it on onedrive for some reason :( maybe because i dont have a paid suscription to office365? never used onedrive so far so i cant help you there sorry :P@all i am currently pretty busy with university stuff and my other project (https://bitcointalk.org/index.php?topic=1958068) and therefore am a little behind on support for this project. when i eventually have some more freetime again i will catch up with everything i planned to do. happy trading ;) Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: majorlee on November 07, 2017, 01:54:29 AM NOD is blocking the D/L site
Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on November 12, 2017, 11:31:08 PM NOD is blocking the D/L site sorry to ask but what is NOD?if you want you can just add me on skype and i send it to that way (skype: constraccta) greetings Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on November 12, 2017, 11:34:48 PM UPDATE: DOWNLOAD IN OP
Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: davemanet on November 14, 2017, 04:15:37 PM UPDATE: DOWNLOAD IN OP
Cool Excel op. I just tried it with Bittrex but it doesn't appear to work. - Some but not all coins appear on the left - No graphs on the right appear When I click Trade History it appears blank. Are there supposed to be filled cells there? Is there a manual method to copy and paste the data? I'm guessing there's something going wrong with the import feature. Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on November 14, 2017, 04:34:45 PM - Some but not all coins appear on the left if you hit start it only shows coins with which you have traded in the selected timeframeso if you traded monero in 2016 but selected a timeframe starting at 2017 it wont display the coin on the right the same applies for when you traded them in a different basemarket which you can select at the settings as well if your missing coin fullfills all that criteria there might indeed be a mistake otherwise try altering the settings ;) - No graphs on the right appear by default no graphs appear right awayin order to display something in the graph you need to click on a coin on the left (most text that is written in blue is clickable with some kind of effect) if you click on the coin and you get an error or nothing gets displayed there again might be a mistake otherwise everything works as intended When I click Trade History it appears blank. Are there supposed to be filled cells there? Is there a manual method to copy and paste the data? I'm guessing there's something going wrong with the import feature. dont get confused by the looks of the tradehistory sheeti dont recommend to do any manual altering of that sheet since its easy to mess something up the coded manages this sheet entirely on its own which may result in it looking empty even though it really is not so far i would say that it works fine since you were able to import and hit start without any errors which was so far the only part where something went wrong if you still have problems even after checking what i just explained feel free to contact me here or on skype! greetings Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: mgkha on December 14, 2017, 12:37:41 PM Hey,
first.. Thank you very much for this awesome sheet! I've been looking quite a while for something like this to track my trades easily. I'm using the Bittrex version and there seems to be an error. I can import the data file but when I click on the blue USDT-BTC at the left to show the graph an error appaears with "Runtime error 13. Type mismatch" When clicking on debug it sends me to this line of code: Quote Sheets(2).Range("$A:$K").AutoFilter Field:=1, Criteria1:=">=" & ActiveSheet.Cells(1, 22).Value, Operator:=xlAnd, Criteria2:="<=" & ActiveSheet.Cells(1, 29).Value How can I solve this problem? The "tradeHistory" sheet is empty aswell. Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on December 14, 2017, 05:18:47 PM Hey, its always really hard to tell. maybe add me on skype and i see what i can do for you ;)first.. Thank you very much for this awesome sheet! I've been looking quite a while for something like this to track my trades easily. I'm using the Bittrex version and there seems to be an error. I can import the data file but when I click on the blue USDT-BTC at the left to show the graph an error appaears with "Runtime error 13. Type mismatch" When clicking on debug it sends me to this line of code: Quote Sheets(2).Range("$A:$K").AutoFilter Field:=1, Criteria1:=">=" & ActiveSheet.Cells(1, 22).Value, Operator:=xlAnd, Criteria2:="<=" & ActiveSheet.Cells(1, 29).Value How can I solve this problem? The "tradeHistory" sheet is empty aswell. Title: Re: Poloniex (and Bittrex [beta]) Trading-Analysis Spreadsheet for MS EXCEL Post by: guesswho1234 on December 19, 2017, 08:28:14 PM UPDATE: DOWNLOAD IN OP
|
