Making Candlestick Charts from real-time data imported live into Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2276537%22%20slang%3D%22en-US%22%3EMaking%20Candlestick%20Charts%20from%20real-time%20data%20imported%20live%20into%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2276537%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20wondering%20if%20anyone%20knows%20how%20to%20set%20up%20Microsoft%20365%20Excel%20so%20that%20I%20can%26nbsp%3B%3C%2FP%3E%3CP%3Etake%20some%20real-time%20financial%20data%20that%20is%20constantly%20updating%20second%20by%20second%20in%20one%20Excel%20cell%26nbsp%3B%3CSPAN%3Eand%20I%20want%20to%20make%20a%20candlestick%20chart%20of%20that%20data%20with%20each%20candlestick%20representing%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eone%20minute%20of%20data%20changes.%20Is%20it%20possible%20to%20do%20this%3F%20I%20am%20importing%20the%20live%20data%20into%20Excel%26nbsp%3B%3C%2FP%3E%3CP%3Efrom%20Thinkorswim.%20Any%20help%20would%20be%20greatly%20appreciated.%20Thank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2276537%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, 

I am wondering if anyone knows how to set up Microsoft 365 Excel so that I can 

take some real-time financial data that is constantly updating second by second in one Excel cell and I want to make a candlestick chart of that data with each candlestick representing

one minute of data changes. Is it possible to do this? I am importing the live data into Excel 

from Thinkorswim. Any help would be greatly appreciated. Thank you. 

0 Replies