can we save and export the tick data to an excel file that is getting streamed live
yes it is possible to save the live streaming data, you have not mentioned which program you are using or where you are getting the live streaming data
If your query is with Excel RTD, streaming with link to excel feature, you have to use Excel macros or VBA to store RTD,
if you are using with any other programming language for live streaming then it is possible to store to database (am not very sure how)
what i am looking at is …can we save the tick data coming from kite or Pi …if this is not possible on these platforms .can you tell me which are best trading platforms on which we can save tick data…
Yes, You can save the each and every tick received on RTD from the Trading Platform to a text file.
The ticks you receive in Trading Platform is much faster than any other data and you will get multiple ticks in a second.
You can use this data for analysis.
You can try this Excel Based Utility