Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Real-time charting of DDE links
Is it possible to chart DDE links in real-time in Excel? Could someone
please point me in the right direction to find out how this can be done. Thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Real-time charting of DDE links
Could you provide a few more details about what you need? I've dabbled in
this area just a bit. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "andy" wrote in message ... Is it possible to chart DDE links in real-time in Excel? Could someone please point me in the right direction to find out how this can be done. Thanks! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Real-time charting of DDE links
I have DDE links for my stock analysis. All the cells below are dynamically
updating and I would like the chart (in real-time) the number "-86.1%" from below. I would like to chart 1-minute candle stick charts that show the open-high-low-close for each candle. Do you possiblly know of any programs that could do this for me? Thanks! HIGH LOW LAST Range DD 48.33 46.97 47.15 -86.8% DOW 44.33 43.53 43.70 -78.7% AA 38.36 37.31 37.40 -91.4% MON 96.50 94.26 94.56 -86.6% FCX 114.24 107.19 108.10 -87.1% -86.1% =SUM(F2:FF6)/5 =(Last-High)/(High-Low) "Jon Peltier" wrote: Could you provide a few more details about what you need? I've dabbled in this area just a bit. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "andy" wrote in message ... Is it possible to chart DDE links in real-time in Excel? Could someone please point me in the right direction to find out how this can be done. Thanks! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Real-time charting of DDE links
How frequently is the data updated? Are the candlesticks the way you want to
show the average range calculation? Basically you need a way to capture the data each time it changes. Probably you will archive the data to another sheet, along with a time stamp. Since the new values lead to a recalculation of the average range each time they are updated, you could probably get away with using Worksheet_Calculate to fire the archiving of data. I'd list the data in one range, then use formulas to compute the minute by minute OHLC. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "andy" wrote in message ... I have DDE links for my stock analysis. All the cells below are dynamically updating and I would like the chart (in real-time) the number "-86.1%" from below. I would like to chart 1-minute candle stick charts that show the open-high-low-close for each candle. Do you possiblly know of any programs that could do this for me? Thanks! HIGH LOW LAST Range DD 48.33 46.97 47.15 -86.8% DOW 44.33 43.53 43.70 -78.7% AA 38.36 37.31 37.40 -91.4% MON 96.50 94.26 94.56 -86.6% FCX 114.24 107.19 108.10 -87.1% -86.1% =SUM(F2:FF6)/5 =(Last-High)/(High-Low) "Jon Peltier" wrote: Could you provide a few more details about what you need? I've dabbled in this area just a bit. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "andy" wrote in message ... Is it possible to chart DDE links in real-time in Excel? Could someone please point me in the right direction to find out how this can be done. Thanks! |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Real-time charting of DDE links
The data is changing at a rapid fire speed because 5 stocks are linked to the
one number that I would like to chart. For the chart, I think a high-low-close chart would be fine instead of the candlesticks. I just want to see if the number moves really big in that 1-minute interval. I am unfamiliar with "Worksteet_Calculate"...I will have to study this. Thanks Jon! "Jon Peltier" wrote: How frequently is the data updated? Are the candlesticks the way you want to show the average range calculation? Basically you need a way to capture the data each time it changes. Probably you will archive the data to another sheet, along with a time stamp. Since the new values lead to a recalculation of the average range each time they are updated, you could probably get away with using Worksheet_Calculate to fire the archiving of data. I'd list the data in one range, then use formulas to compute the minute by minute OHLC. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "andy" wrote in message ... I have DDE links for my stock analysis. All the cells below are dynamically updating and I would like the chart (in real-time) the number "-86.1%" from below. I would like to chart 1-minute candle stick charts that show the open-high-low-close for each candle. Do you possiblly know of any programs that could do this for me? Thanks! HIGH LOW LAST Range DD 48.33 46.97 47.15 -86.8% DOW 44.33 43.53 43.70 -78.7% AA 38.36 37.31 37.40 -91.4% MON 96.50 94.26 94.56 -86.6% FCX 114.24 107.19 108.10 -87.1% -86.1% =SUM(F2:FF6)/5 =(Last-High)/(High-Low) "Jon Peltier" wrote: Could you provide a few more details about what you need? I've dabbled in this area just a bit. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "andy" wrote in message ... Is it possible to chart DDE links in real-time in Excel? Could someone please point me in the right direction to find out how this can be done. Thanks! |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Real-time charting of DDE links
How rapid is rapid-fire? Once per second?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "andy" wrote in message ... The data is changing at a rapid fire speed because 5 stocks are linked to the one number that I would like to chart. For the chart, I think a high-low-close chart would be fine instead of the candlesticks. I just want to see if the number moves really big in that 1-minute interval. I am unfamiliar with "Worksteet_Calculate"...I will have to study this. Thanks Jon! "Jon Peltier" wrote: How frequently is the data updated? Are the candlesticks the way you want to show the average range calculation? Basically you need a way to capture the data each time it changes. Probably you will archive the data to another sheet, along with a time stamp. Since the new values lead to a recalculation of the average range each time they are updated, you could probably get away with using Worksheet_Calculate to fire the archiving of data. I'd list the data in one range, then use formulas to compute the minute by minute OHLC. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "andy" wrote in message ... I have DDE links for my stock analysis. All the cells below are dynamically updating and I would like the chart (in real-time) the number "-86.1%" from below. I would like to chart 1-minute candle stick charts that show the open-high-low-close for each candle. Do you possiblly know of any programs that could do this for me? Thanks! HIGH LOW LAST Range DD 48.33 46.97 47.15 -86.8% DOW 44.33 43.53 43.70 -78.7% AA 38.36 37.31 37.40 -91.4% MON 96.50 94.26 94.56 -86.6% FCX 114.24 107.19 108.10 -87.1% -86.1% =SUM(F2:FF6)/5 =(Last-High)/(High-Low) "Jon Peltier" wrote: Could you provide a few more details about what you need? I've dabbled in this area just a bit. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "andy" wrote in message ... Is it possible to chart DDE links in real-time in Excel? Could someone please point me in the right direction to find out how this can be done. Thanks! |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Real-time charting of DDE links
A couple of times per second. The stocks linked to the value I would like to
chart are very active stocks. They have active periods in the day and somewhat inactive periods as well so it can vary. "Jon Peltier" wrote: How rapid is rapid-fire? Once per second? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "andy" wrote in message ... The data is changing at a rapid fire speed because 5 stocks are linked to the one number that I would like to chart. For the chart, I think a high-low-close chart would be fine instead of the candlesticks. I just want to see if the number moves really big in that 1-minute interval. I am unfamiliar with "Worksteet_Calculate"...I will have to study this. Thanks Jon! "Jon Peltier" wrote: How frequently is the data updated? Are the candlesticks the way you want to show the average range calculation? Basically you need a way to capture the data each time it changes. Probably you will archive the data to another sheet, along with a time stamp. Since the new values lead to a recalculation of the average range each time they are updated, you could probably get away with using Worksheet_Calculate to fire the archiving of data. I'd list the data in one range, then use formulas to compute the minute by minute OHLC. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "andy" wrote in message ... I have DDE links for my stock analysis. All the cells below are dynamically updating and I would like the chart (in real-time) the number "-86.1%" from below. I would like to chart 1-minute candle stick charts that show the open-high-low-close for each candle. Do you possiblly know of any programs that could do this for me? Thanks! HIGH LOW LAST Range DD 48.33 46.97 47.15 -86.8% DOW 44.33 43.53 43.70 -78.7% AA 38.36 37.31 37.40 -91.4% MON 96.50 94.26 94.56 -86.6% FCX 114.24 107.19 108.10 -87.1% -86.1% =SUM(F2:FF6)/5 =(Last-High)/(High-Low) "Jon Peltier" wrote: Could you provide a few more details about what you need? I've dabbled in this area just a bit. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "andy" wrote in message ... Is it possible to chart DDE links in real-time in Excel? Could someone please point me in the right direction to find out how this can be done. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Collaborating in real time | Excel Discussion (Misc queries) | |||
Real Time Charting | Excel Worksheet Functions | |||
Real Time Charting | Charts and Charting in Excel | |||
real-time countdown | Excel Worksheet Functions | |||
real time charting.... | Charts and Charting in Excel |