Topic: deleted (Read 14693 times)

Hey wondering if there was a fix for this guy? I am getting the same error. Nice spreadsheet by the way, this thing is dope!

UPDATE: DOWNLOAD IN OP

• bugfix for the bittrex version (its important that you use the fullOrders.csv export from bittrex for the new version of the spreadsheet!)

its always really hard to tell. maybe add me on skype and i see what i can do for you

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:


How can I solve this problem?
The "tradeHistory" sheet is empty aswell.

if you hit start it only shows coins with which you have traded in the selected timeframe

so 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

by default no graphs appear right away

in 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

dont get confused by the looks of the tradehistory sheet

i 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

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.

UPDATE: DOWNLOAD IN OP

• bugfix for the bittrex version

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

NOD is blocking the D/L site

never used onedrive so far so i cant help you there sorry

@all
i am currently pretty busy with university stuff and my other project (https://bitcointalksearch.org/topic/deleted-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

and +1 to adapt it better to bittrex, definitely will keep being the biggest altcoin platform for a long time...

excellent tool too bad i cannot upload it on onedrive for some reason maybe because i dont have a paid suscription to office365?

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

How does the graphics work?

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.

Anyupdate peeps?

Hi, I also have the same issue 'Run-time error '9': Subscript out of range'

Looks really promising!

Perfect, PM me an e-mail address where I can send my file

im not sure but i think they guy never responded to me again.

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

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