LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 15th 04, 10:18 PM
Posts: n/a
Default Running Data Table using an input that triggers DDE linked data

I'm posting this again because I'm really hoping to get an answer.

I have a spreadsheet that is set up to pull up historical stock prices
dde links that is driven by the stock's ticker - e.g. MSFT

Once the prices are pulled into the spreadsheet, it calculates some
values -
to keep it simple, let's say it calculates a 5d, 20d and 50d moving

I want to create a data table that will use all the tickers I want to
at in the column on the left, and the three moving average periods in
row, looking something like this:
Moving Average Period (days)
A1 5 20 50
Stock MSFT
Ticker IBM

A1 is the cell reference to the formula that calculates the moving
Another cell, let's say B1 contains the current ticker, MSFT, and that
is the
column reference for the stock tickers in the table, and, let's say C1
contains the current moving average period, 5 (days).

When I build the data table, even though I can see the spreadsheet
through the motions of "calculating" for each row and column in the
table, only the current ticker is used by the data table. The row
(moving average period) works fine.

But I end up with a data table that has the first row (in this
because it is the same as the current value in the Ticker cell B1) of
correct, but just repeated all the way down for each ticker. That is,
remaining tickers show the MSFT calculations in their rows.

I've got a reasonable amount of experience, and I know (and have
that my data table settings are fine.

Is it possible to do this? Because the calculations done on the stock
prices are really not this simple, and involve alot of data through
the DDE,
I don't want to have to build a repeated calculation model for each
(because we're talking alot more than three).

Hope this explains what I'm trying to do. I wondered if it was the
DDE link
that causes the problem (works fine for the current link, and I can
see it
"resetting" through every iteration of the data tabel calculation). I
thought it may be that data tables will only accept numerical inputs.

Any suggestions would be hugely appreciated.


  #2   Report Post  
Old December 16th 04, 11:56 AM
Jim Rech
Posts: n/a

I have never used DDE. Are you saying that at any point in time there is
only the raw data for one company in the worksheet? If so, are you hoping
that the DT will re-run a series of queries and each time calculate the
appropriate moving averages? I have no idea whether Excel will do that. It
seems to me though that, if this is happening, then the data for the last
company in the list (HP in your example) will be in the sheet. Is it?

Jim Rech
Excel MVP

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Colors of columns after sorting data in the supporting table Booger_Boy Charts and Charting in Excel 6 January 24th 05 02:41 PM
changing proportion of chart and data table Dawn Parks Charts and Charting in Excel 3 January 6th 05 01:18 AM
multiple or changing colours in a data table on an excel chart fo. Kerri Buxton Charts and Charting in Excel 2 December 23rd 04 07:39 PM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM
Data Table - Does it work with DDE links and stock tickers? Post Tenebras Lux Excel Discussion (Misc queries) 0 December 1st 04 05:15 PM

All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017