data feed

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

i have a data feed into my excel spreadsheet.

the feed is to one cell that changes continuously in real
time. there is no historical record of the path taken by
the numbers displayed - only the most current number is
displayed.

I would like to record these numbers at periodic intervals
so as to create a historical record of the numbers
appearing in the data feed cell and make a chart depicting
the history of the data.

is ther a way to do such a thing in excel??
...
 
[This followup was posted to microsoft.public.excel.charting with an
email copy to paul.
Please use the newsgroup for further discussion.]

You can develop a log of the real-time changes programmatically.
Depending on your comfort level with VBA programming...check out the
Worksheet Change event and/or the Application OnTime method.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top