Hi everyone, here's what might be a bit of a challenge for you. Or maybe not so much.
I have live market data coming in to excel through DDE, my question is how do I graph this data since the cell is constantly updating?
Thank you in advance, from an excel newbie
Adam
Hello Adam
Have a look at John Peltiers content on dynamic charts here: http://peltiertech.com/Excel/Charts/ChartIndex.html#D
Regards
Jon (Excel 2003, 2007, 2010, 2013)
Thank you, I see that all these charts involve a range, so I guess then my question would be how do I record the changing values of a single cell into a row that can then be charted?
Hello again Adam
How is the data refreshed? Do you manually trigger the refresh or do you have some code to fetch it? If you provide a little more info in terms of where the data sits (ranges and sheet name) then perhaps I can construct a little macro for you to maintain a history.
How often do you refresh the data and how much history do you need for your charts?
The data comes from 3rd party software & is refreshed automatically every 250 milliseconds
So the cell value is constantly updating, but i wonder if I can probe the cell every x number of seconds or milliseconds, record the value in a separate column, & then chart it. I would like to capture all data but maybe display the last 1000 data points on the chart.
Your help is immensely appreciated
And all this is done in Excel?Originally Posted by Adamo
The data comes from 3rd party software & is refreshed automatically every 250 millisecondsI think a macro to trigger every few seconds is going to cause some problems. Effectively it means taking the data at that point and loading it to an append table. Any macro I supply is going to freeze your Excel for a second or so and therefore make it nigh on impossible to do any actual work with the application. I was expecting every hour or so, or once a day. Working with seconds is another story (for me at least)...
Fair enough, how would the macro look like if we assumed once every hour?
Hi Adam
It would depend on the construct of the query table (the ranges and how the data is laied out e.g. columnular or row oriented). I would also need to know the names of the sheets. What constritutes 1000 data points? Rows? Here is an example of how I would do it to trigger say every 15 seconds:
Please Login or Register to view this content.
thank you very much, i will try this code when I get home tonight!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks