Creating a chart from LIVE stock market data

Hello,

Let me start off by saying I am not a programmer and I am not very advanced in Excel, so it may be a little hard for me to keep up with you guys, so please be patient with me . Hopefully I can explain what I need.

I have an Excel Spreadsheet that receives LIVE data from TD Ameitrade's Think or Swim application (also known as TOS). I believe TOS and Excell are connected through a DDE (Dynamic Data Exchange).

On my Excel Spreadsheet I have LIVE stock prices showing that get updated in real-time. So right now I am looking at my Excel Spreadsheet and I am seeing a stock price of 1140. As I continue to watch that price, it will automatically update/refresh when a new prices comes along. Now, the price just changed to 1141. Throughout the day, this price changes hundreds of times (every time there is a change in the price, a new price replaces the old price). All of this is happening in the same cell, it's just one cell that is being automatically refreshed all the time.

What I am trying to do is to make a CHART of the prices that are being displayed within that one cell. What I would like to do is once EVERY 1 minute, SAVE the current value displayed in that cell and STORE that somewhere. If I understand correctly, I would be storing that in an array (remember, I am not a programmer, so I don't really know what I am talking about).

Then I would like to have a chart that could read that array and display the last "N" data points on the chart (say the last 50 data points). I need the chart to be a LIVE chart (update and refresh automatically).

So my 1st question is: Can this even be done in Excel ?
Question 2 is: If it can be done, how hard will it be for me to do (would I be able to do it with my limited programming skills)

Any help or insight would be greatly appreciated !!

Thank You

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread in CS subforum.

Thread Closed.