Transaction data in excel

August 24th, 2019, 02:11 PM

Hi, i was wonder if it is possible to get transaction data in excel from broker? Sorry if it stupid question but i'm new and i want to chceck something

August 25th, 2019, 07:34 AM

Directly from your broker I don't know as I have never asked. But all the trading platforms that I have used have allowed trade data to be downloaded from them, from their trades or positions tables, and that data has usually been in an Excel compliant format so I could load it in to my own spreadsheets.
If you have a trading platform in mind that might allow somebody to give a more accurate answer.

August 26th, 2019, 06:34 PM

Thanks a lot. Did you have to pay for those data?

August 27th, 2019, 04:06 AM

Tomson00

Thanks a lot. Did you have to pay for those data?

If you have a live brokerage account you need to pay for CME data (if that is the exchange you want to use), but that is only about $5 per exchange. The ES, NQ, YM equity futures are a different exchange to Crude oil for instance. But all the CME owned are only about $15 a month. I am not sure of the exact figure but it is around that sort of price.

Or if their is a trading platform you like the look of and want to try, almost all companies provide two week simulator/demo accounts. Ninjatrader is popular for instance and that is available from Ninjatrader Brokerage. That was you can test trade in sim then download the trade data for those trades and test the format for uploading in excel.

Transaction data in excel

Discussion in Traders Hideout

Transaction data in excel