LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default calculating moving average

Hello,

I am trying to calculate a moving average for stock quotes. The problem
is that the time interval is not continuous. I get for example at
11.55.33 a stock quote the next one can be at 11.56.21 and the next at
12.00.21. I want to copy the stock quotes at certain time intervals. So
for example copy the stock quote at every 5 minutes. Save them and than
calculate a moving average. Can anybody help me please?

Kind regards,

John

 
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
Moving Average projection? Wild Nerd Excel Worksheet Functions 6 March 21st 06 01:55 PM
Calculating an average based on 2 and 3 criteria craggergirl Excel Worksheet Functions 2 February 24th 06 02:37 PM
30 Day Moving Average Ignoring Blank Cells ethatch Excel Worksheet Functions 2 January 17th 06 09:37 AM
calculating moving average odey1234 Excel Worksheet Functions 2 March 29th 05 02:06 PM
Plotting moving average line on a chart Herbert Chan Charts and Charting in Excel 1 February 26th 05 08:31 PM


All times are GMT +1. The time now is 01:19 PM.

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

About Us

"It's about Microsoft Excel"