information from volume graphs to an excel file

[r68cervera]

Hello, good morning, I have been doing a study on volume charts for some time, and I am interested in knowing the buying and selling volume in each candle, for this I use the Buy Sell Volume indicator, and until now I was collecting that information by hand, because That information has to be in real time, otherwise it is lost.

I have been looking and I cannot find a way to do it automatically and have ALL THE INFORMATION OF THE SESSION (approximately from 3:00 p.m. to 5:30 p.m.) collected in a file so that I can later study it. For example, in volume charts of 3000 I would like there to be a column with TIME 11:08:09:812 and VOLUME 1985 (I would only have to collect the sales volume since the purchase volume in this case would always be 3000).

The only thing I've seen so far is StreamWriter, I don't know if I should start there, or is there some other way to do it
Thank you so much
All the best

[NinjaTrader_Jesse]

Hello r68cervera,

A streamwriter is the easiest way to write data to a .csv file which could then be imported to excel by using excels import options. You can also look at the following post however that is an unsupported excel api, that would require more complex development but that can write data directly to an excel file.

https://ninjatrader.com/support/helpGuides/nt8/using_streamwriter_to_write_to.htm

https://ninjatraderecosystem.com/user-app-share-download/excel8/