Help with FXCM Data Import

Hi,

Wondering if someone can help me with importing some data downloaded from FXCM.  Confused by the bid ask information provided and wondering how to import the date.  Thinking I may have to change the date format in excel and then import.  Date is in format MM/DD/YYYY.  The bid is High Bid, Low Bid, Open Bid, Close Bid and the same values are provided for the ask.  Not sure which one to use for the open and close.  There is also a Total Ticks Column, take it I don’t need that one.   Want to make sure I do it right 🙂

Thanks,

Kevin

Hello,

can you provide a data sample? (at least few lines)

Date             Time OpenBid HighBid LowBid CloseBid”OpenAsk”HighAsk”LowAsk”CloseAsk”Total Ticks

3/27/2016 18:15:00 1.41328 1.41328 1.41189 1.41197 1.41447 1.41447 1.41272 1.41272 2

3/27/2016 18:28:00 1.41197 1.41237 1.41197 1.41237 1.41272 1.41272 1.41272 1.41272 1

3/27/2016 18:29:00 1.41237 1.41237 1.41225 1.41225 1.41272 1.41375 1.41255 1.41255 4

3/27/2016 18:32:00 1.41225 1.41225 1.41188 1.41188 1.41255 1.41292 1.41255 1.41292 1

3/27/2016 18:33:00 1.41188 1.41225 1.41188 1.41225 1.41292 1.41292 1.41255 1.41255 2

Hello,

are this tick data? If you you can import only bid ask prices. Look at the screenshot

File: import1.png

File: import2.png