Exporting of data

%3CLINGO-SUB%20id%3D%22lingo-sub-2092317%22%20slang%3D%22en-US%22%3EExporting%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2092317%22%20slang%3D%22en-US%22%3EHi%2C%20I%20would%20like%20to%20seek%20assistance%20on%20how%20am%20I%20able%20to%20export%20data%20from%20a%20stock%20market%20trading%20platform%20into%20excel%20and%20have%20the%20data%20sync%20with%20the%20platform%20in%20real%20time.%20Thank%20you!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2092317%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2094189%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2094189%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F940733%22%20target%3D%22_blank%22%3E%40Michael1375%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou've%20had%20a%20lot%20of%20views%20(36%20as%20I%20write%20this)%20and%20no%20replies.%20I'll%20take%20a%20stab%2C%20but%20I%20think%20you%20will%20need%20to%20give%20us%20all%20a%20bit%20more%20info%20on%20what%20it%20is%20you're%20trying%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20export%20data%20from%20Fidelity%2C%20my%20brokerage.%20More%20specifically%2C%20I%20export%20two%20different%20views%20from%20FIdelity's%20Active%20Trader%20Pro%20platform..%20One%20is%20of%20my%20portfolio%20of%20investments%3B%20the%20other%20is%20of%20current%20into%20on%20stocks%20I%20don't%20own%2C%20but%20on%20which%20I%20hold%20Options%20positions%20in%20the%20portfolio.%20Those%20exported%20Excel%20files%20are%20then%20accessed%20by%20my%20own%20tracking%20spreadsheet--which%20mostly%20is%20for%20tracking%20the%20Options%20positions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20the%20export%20part%20is%20easy.%20I'd%20be%20surprised%20if%20it's%20not%20possible%20with%20most%20(if%20not%20all)%20brokerages.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20real-time%20syncing%20is%20another%20matter.%20But%20how%20important%20is%20that%2C%20truly%3F%20The%20export%20takes%20but%20seconds%20to%20complete%20and%20is%20immediately%20accessible.%20If%20you're%20expecting%20to%20monitor%20things%20and%20do%20buying%20and%20selling%20on%20a%20real-time%20basis%2C%20then%20you%20would%20be%20better%20served%20by%20doing%20that%20on%20the%20brokerage%20platform%20itself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20if%20you%20want%20more%20you%20should%20tell%20us%20more....there%20may%20be%20others%20here%20who%20use%20a%20different%20brokerage%20and%20have%20done%20all%20that%20you're%20seeking.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi, I would like to seek assistance on how am I able to export data from a stock market trading platform into excel and have the data sync with the platform in real time. Thank you!
2 Replies

@Michael1375 

 

You've had a lot of views (36 as I write this) and no replies. I'll take a stab, but I think you will need to give us all a bit more info on what it is you're trying to do.

 

I export data from Fidelity, my brokerage. More specifically, I export two different views from FIdelity's Active Trader Pro platform.. One is of my portfolio of investments; the other is of current into on stocks I don't own, but on which I hold Options positions in the portfolio. Those exported Excel files are then accessed by my own tracking spreadsheet--which mostly is for tracking the Options positions.

 

Anyway, the export part is easy. I'd be surprised if it's not possible with most (if not all) brokerages.

 

The real-time syncing is another matter. But how important is that, truly? The export takes but seconds to complete and is immediately accessible. If you're expecting to monitor things and do buying and selling on a real-time basis, then you would be better served by doing that on the brokerage platform itself.

 

Anyway, if you want more you should tell us more....there may be others here who use a different brokerage and have done all that you're seeking.

Hi, thank you for your reply and your response is well taken.