Excel DDE / Data Analysis Newbie Question

M

mryanfla

Hello,
I have searched the FAQ and can find nothing, please help or
advise....

I have a spreadsheet of 200 stocks that I need to monitor on a
daily basis. I receive the data and it goes into a spreadsheet via
DDE. Taking daily trading in 30 minute increments we have 13 thirty
minute periods(9:30-4pm). If a stock normally trades 100,000 shares
per 30 minutes I need a way to flag the stock(via highlighting or cell
change?) if the stock suddenly goes above it's 30 minute average. Can
Open Office Calc do this? Any help is greatly appreciated.

Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need help with running totals 1
total running balance 1
Advice needed for setting up a Windows 2000 DDE server for feeding data to Excel. 0
OnTime Application Newbie Question 1
charting a single changing DDE cell 2
Binding to RTD data in Excel 0
Excel Boffins please help ! ! ! 4
Excel Boffins help please ! ! ! 2

Top