I finally got the tick data I need but that's not arranged in a usable format and I can't get the data in another way... The problem is that all data are mixed into one field(Time, volume, price and type) when I copy and paste the data into EXCEL. How can I split the four items into 4 fields so I can apply further analysis with EXCEL. Here is the sample tick data.
I've found the solution from another EXCEL forum Select Data > Text to Columns Choose Delimited as your file type and Click on next Choose Space as your delimiter Choose the appropriate Column Data Format , if applicable Click on Finish