| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summation of last (DD) days
i am tring to create a simple Nasdaq Breadth rati
where the sum of the advancing volume for the past 8 days(including today is divided by the declining volume for the past 8 days (includiny today for anyone interested in the market i would buy when ADR=1.5 and sell when ADR=0.8 this would be updated daily from yahoo DATE AV DATE D 20040331 674931876 20040331 111957091 20040401 1322679760 20040401 44943118 i have the formulae but need to transfer into excel languag Data AV = Nasdaq Advancing Volum DV = Nasdaq Declining Volum Formulae SUM_AV = Summation of last (8) days (including current day) of A SUM_DV = Summation of last (8) days (including current day) of D ADR = SUM_UV / SUM_D TIA, cirius3000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to pull <=14 Days, <=30 Days, 30 Days from a date column | Excel Discussion (Misc queries) | |||
| Summation | Excel Discussion (Misc queries) | |||
| summation | Excel Worksheet Functions | |||
| Summation Operator | Excel Worksheet Functions | |||
| Summation from a to b | Excel Worksheet Functions | |||
Threaded Mode
