Real-Time Charting

[johnson]

Could someone please help me. I have setup my Excel
spreadsheet to obtain real-time stock quotes. I would
like to graph the stock price, especially during the
day . How can this be done since I only have one cell
that is constantly updated, and also is there some way to
show multiple graphs, for instance, intra-day, past 30
days, past year etc. Thanks to everyone.

 

[Tushar Mehta]

I don't believe you can plot data that haven't been saved somewhere.

--
Regards,

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

 

[Tushar Mehta]

You can save a file periodically. It requires some programming. See
the Change event (as in Workbook_SheetChange) or the OnTime method.

For a non-programmatic way to 'propagate' data down a column whenever
something new is entered in a row at the top, see
http://www.bmsltd.co.uk/excel/SBXLPage.asp#WksFuncs -- specifically,
the 'Previous.zip' example. However, be warned. It requires you to
enable iterative calculations, which comes with its own set of baggage.

--
Regards,

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

Is there some means to save the data periodically (every
30 mins?) in a worksheet?