| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving Average projection?
I have a column of numbers in which I created 2 different Moving Average time frames. Now I want to know: How to write the formula: What number is needed today for the moving averages to cross each other? For instance, if a shorter moving average is 108 and a longer one is 123, What number is needed today for the shorter average to be larger than the longer average? Keep in mind, I have to drop the oldest time frame price. -- Wild Nerd ------------------------------------------------------------------------ Wild Nerd's Profile: http://www.excelforum.com/member.php...o&userid=32633 View this thread: http://www.excelforum.com/showthread...hreadid=524434 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 30 Day Moving Average Ignoring Blank Cells | Excel Worksheet Functions | |||
| how do I extract the moving average trendline point data? | Charts and Charting in Excel | |||
| 24hr moving average | Excel Discussion (Misc queries) | |||
| Moving average | Excel Worksheet Functions | |||
| Plotting moving average line on a chart | Charts and Charting in Excel | |||
Threaded Mode
