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

Copper Contributor

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