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