Historical Volatility & Volatility Ratio

Message 14941 by tedclimo
Need help with TC2000 Historic Volatility formula
(described as follows):
1) Divide today’s close by yesterdays close.
2) Take natural log of #1
3) Take the standard deviation of #2 for 50 days
4) Multiply #3 by 100
5) Multiply #4 by the square root of the # of trading days in a year (256).

Message 14974
Calculating Historical Volatility
Let Length = length of volatility to be calculated
ln = natural logarithm
Historical Volatility(length) = standard
deviation(ln(close/yesterday’s close),length) * 100 *
square root (256)


HISTORICAL VOLATILITY PCFs

Suggestions: COPY and PASTE the formulas.
For testing, remove ALL spaces including carriage returns.
During the FIRST [Update All Criteria], let the PCF
editor insert spaces into the ‘spaceless’ PCF (reduces logic errors).

6-day Historical Volatility PCF
(((SQR((6*((LOG(C/C1))*(LOG(C/C1))+(LOG(C1/C2))*
(LOG(C1/C2))+(LOG(C2/C3))*(LOG(C2/C3))+(LOG(C3/C4))*
(LOG(C3/C4))+(LOG(C4/C5))*(LOG(C4/C5))+(LOG(C5/C6))*
(LOG(C5/C6)))-((LOG(C/C1))+(LOG(C1/C2))+(LOG(C2/C3))+
(LOG(C3/C4))+(LOG(C4/C5))+(LOG(C5/C6)))*((LOG(C/C1))+
(LOG(C1/C2))+(LOG(C2/C3))+(LOG(C3/C4))+(LOG(C4/C5))+
(LOG(C5/C6))))/(6*6))))*100*16.1245)


Message 15042 by sammy_4_1

10-day Historical Volatility PCF

(((SQR((10*((LOG(C/C1))*(LOG(C/C1))+(LOG(C1/C2))*
(LOG(C1/C2))+(LOG(C2/C3))*(LOG(C2/C3))+(LOG(C3/C4))*
(LOG(C3/C4))+(LOG(C4/C5))*(LOG(C4/C5))+(LOG(C5/C6))*
(LOG(C5/C6))+(LOG(C6/C7))*(LOG(C6/C7))+(LOG(C7/C8))*
(LOG(C7/C8))+(LOG(C8/C9))*(LOG(C8/C9))+(LOG(C9/C10))*
(LOG(C9/C10)))-((LOG(C/C1))+(LOG(C1/C2))+(LOG(C2/C3))+
(LOG(C3/C4))+(LOG(C4/C5))+(LOG(C5/C6))+(LOG(C6/C7))+
(LOG(C7/C8))+(LOG(C8/C9))+(LOG(C9/C10)))*((LOG(C/C1))+
(LOG(C1/C2))+(LOG(C2/C3))+(LOG(C3/C4))+(LOG(C4/C5))+
(LOG(C5/C6))+(LOG(C6/C7))+(LOG(C7/C8))+(LOG(C8/C9))+
(LOG(C9/C10))))/(10*10))))*100*16.1245)


50-day Historical Volatility PCF
(((SQR((50*((LOG(C/C1))*(LOG(C/C1))+(LOG(C1/C2))*
(LOG(C1/C2))+(LOG(C2/C3))*(LOG(C2/C3))+(LOG(C3/C4))*
(LOG(C3/C4))+(LOG(C4/C5))*(LOG(C4/C5))+(LOG(C5/C6))*
(LOG(C5/C6))+(LOG(C6/C7))*(LOG(C6/C7))+(LOG(C7/C8))*
(LOG(C7/C8))+(LOG(C8/C9))*(LOG(C8/C9))+(LOG(C9/C10))*
(LOG(C9/C10))+(LOG(C10/C11))*(LOG(C10/C11))+(LOG(C11/C12))*
(LOG(C11/C12))+(LOG(C12/C13))*(LOG(C12/C13))+(LOG(C13/C14))*
(LOG(C13/C14))+(LOG(C14/C15))*(LOG(C14/C15))+(LOG(C15/C16))*
(LOG(C15/C16))+(LOG(C16/C17))*(LOG(C16/C17))+(LOG(C17/C18))*
(LOG(C17/C18))+(LOG(C18/C19))*(LOG(C18/C19))+(LOG(C19/C20))*
(LOG(C19/C20))+(LOG(C20/C21))*(LOG(C20/C21))+(LOG(C21/C22))*
(LOG(C21/C22))+(LOG(C22/C23))*(LOG(C22/C23))+(LOG(C23/C24))*
(LOG(C23/C24))+(LOG(C24/C25))*(LOG(C24/C25))+(LOG(C25/C26))*
(LOG(C25/C26))+(LOG(C26/C27))*(LOG(C26/C27))+(LOG(C27/C28))*
(LOG(C27/C28))+(LOG(C28/C29))*(LOG(C28/C29))+(LOG(C29/C30))*
(LOG(C29/C30))+(LOG(C30/C31))*(LOG(C30/C31))+(LOG(C31/C32))*
(LOG(C31/C32))+(LOG(C32/C33))*(LOG(C32/C33))+(LOG(C33/C34))*
(LOG(C33/C34))+(LOG(C34/C35))*(LOG(C34/C35))+(LOG(C35/C36))*
(LOG(C35/C36))+(LOG(C36/C37))*(LOG(C36/C37))+(LOG(C37/C38))*
(LOG(C37/C38))+(LOG(C38/C39))*(LOG(C38/C39))+(LOG(C39/C40))*
(LOG(C39/C40))+(LOG(C40/C41))*(LOG(C40/C41))+(LOG(C41/C42))*
(LOG(C41/C42))+(LOG(C42/C43))*(LOG(C42/C43))+(LOG(C43/C44))*
(LOG(C43/C44))+(LOG(C44/C45))*(LOG(C44/C45))+(LOG(C45/C46))*
(LOG(C45/C46))+(LOG(C46/C47))*(LOG(C46/C47))+(LOG(C47/C48))*
(LOG(C47/C48))+(LOG(C48/C49))*(LOG(C48/C49))+(LOG(C49/C50))*
(LOG(C49/C50)))-((LOG(C/C1))+(LOG(C1/C2))+(LOG(C2/C3))+
(LOG(C3/C4))+(LOG(C4/C5))+(LOG(C5/C6))+(LOG(C6/C7))+(LOG(C7/C8))+
(LOG(C8/C9))+(LOG(C9/C10))+(LOG(C10/C11))+(LOG(C11/C12))+
(LOG(C12/C13))+(LOG(C13/C14))+(LOG(C14/C15))+(LOG(C15/C16))+
(LOG(C16/C17))+(LOG(C17/C18))+(LOG(C18/C19))+(LOG(C19/C20))+
(LOG(C20/C21))+(LOG(C21/C22))+(LOG(C22/C23))+(LOG(C23/C24))+
(LOG(C24/C25))+(LOG(C25/C26))+(LOG(C26/C27))+(LOG(C27/C28))+
(LOG(C28/C29))+(LOG(C29/C30))+(LOG(C30/C31))+(LOG(C31/C32))+
(LOG(C32/C33))+(LOG(C33/C34))+(LOG(C34/C35))+(LOG(C35/C36))+
(LOG(C36/C37))+(LOG(C37/C38))+(LOG(C38/C39))+(LOG(C39/C40))+
(LOG(C40/C41))+(LOG(C41/C42))+(LOG(C42/C43))+(LOG(C43/C44))+
(LOG(C44/C45))+(LOG(C45/C46))+(LOG(C46/C47))+(LOG(C47/C48))+
(LOG(C48/C49))+(LOG(C49/C50)))*((LOG(C/C1))+(LOG(C1/C2))+
(LOG(C2/C3))+(LOG(C3/C4))+(LOG(C4/C5))+(LOG(C5/C6))+
(LOG(C6/C7))+(LOG(C7/C8))+(LOG(C8/C9))+(LOG(C9/C10))+
(LOG(C10/C11))+(LOG(C11/C12))+(LOG(C12/C13))+(LOG(C13/C14))+
(LOG(C14/C15))+(LOG(C15/C16))+(LOG(C16/C17))+(LOG(C17/C18))+
(LOG(C18/C19))+(LOG(C19/C20))+(LOG(C20/C21))+(LOG(C21/C22))+
(LOG(C22/C23))+(LOG(C23/C24))+(LOG(C24/C25))+(LOG(C25/C26))+
(LOG(C26/C27))+(LOG(C27/C28))+(LOG(C28/C29))+(LOG(C29/C30))+
(LOG(C30/C31))+(LOG(C31/C32))+(LOG(C32/C33))+(LOG(C33/C34))+
(LOG(C34/C35))+(LOG(C35/C36))+(LOG(C36/C37))+(LOG(C37/C38))+
(LOG(C38/C39))+(LOG(C39/C40))+(LOG(C40/C41))+(LOG(C41/C42))+
(LOG(C42/C43))+(LOG(C43/C44))+(LOG(C44/C45))+(LOG(C45/C46))+
(LOG(C46/C47))+(LOG(C47/C48))+(LOG(C48/C49))+(LOG(C49/C50))))/
(50*50))))*100*16.1245)


100-day Historical Volatility PCF
(((SQR((100*((LOG(C/C1))*(LOG(C/C1))+(LOG(C1/C2))*
(LOG(C1/C2))+(LOG(C2/C3))*(LOG(C2/C3))+(LOG(C3/C4))*
(LOG(C3/C4))+(LOG(C4/C5))*(LOG(C4/C5))+(LOG(C5/C6))*
(LOG(C5/C6))+(LOG(C6/C7))*(LOG(C6/C7))+(LOG(C7/C8))*
(LOG(C7/C8))+(LOG(C8/C9))*(LOG(C8/C9))+(LOG(C9/C10))*
(LOG(C9/C10))+(LOG(C10/C11))*(LOG(C10/C11))+(LOG(C11/C12))*
(LOG(C11/C12))+(LOG(C12/C13))*(LOG(C12/C13))+(LOG(C13/C14))*
(LOG(C13/C14))+(LOG(C14/C15))*(LOG(C14/C15))+(LOG(C15/C16))*
(LOG(C15/C16))+(LOG(C16/C17))*(LOG(C16/C17))+(LOG(C17/C18))*
(LOG(C17/C18))+(LOG(C18/C19))*(LOG(C18/C19))+(LOG(C19/C20))*
(LOG(C19/C20))+(LOG(C20/C21))*(LOG(C20/C21))+(LOG(C21/C22))*
(LOG(C21/C22))+(LOG(C22/C23))*(LOG(C22/C23))+(LOG(C23/C24))*
(LOG(C23/C24))+(LOG(C24/C25))*(LOG(C24/C25))+(LOG(C25/C26))*
(LOG(C25/C26))+(LOG(C26/C27))*(LOG(C26/C27))+(LOG(C27/C28))*
(LOG(C27/C28))+(LOG(C28/C29))*(LOG(C28/C29))+(LOG(C29/C30))*
(LOG(C29/C30))+(LOG(C30/C31))*(LOG(C30/C31))+(LOG(C31/C32))*
(LOG(C31/C32))+(LOG(C32/C33))*(LOG(C32/C33))+(LOG(C33/C34))*
(LOG(C33/C34))+(LOG(C34/C35))*(LOG(C34/C35))+(LOG(C35/C36))*
(LOG(C35/C36))+(LOG(C36/C37))*(LOG(C36/C37))+(LOG(C37/C38))*
(LOG(C37/C38))+(LOG(C38/C39))*(LOG(C38/C39))+(LOG(C39/C40))*
(LOG(C39/C40))+(LOG(C40/C41))*(LOG(C40/C41))+(LOG(C41/C42))*
(LOG(C41/C42))+(LOG(C42/C43))*(LOG(C42/C43))+(LOG(C43/C44))*
(LOG(C43/C44))+(LOG(C44/C45))*(LOG(C44/C45))+(LOG(C45/C46))*
(LOG(C45/C46))+(LOG(C46/C47))*(LOG(C46/C47))+(LOG(C47/C48))*
(LOG(C47/C48))+(LOG(C48/C49))*(LOG(C48/C49))+(LOG(C49/C50))*
(LOG(C49/C50))+(LOG(C50/C51))*(LOG(C50/C51))+(LOG(C51/C52))*
(LOG(C51/C52))+(LOG(C52/C53))*(LOG(C52/C53))+(LOG(C53/C54))*
(LOG(C53/C54))+(LOG(C54/C55))*(LOG(C54/C55))+(LOG(C55/C56))*
(LOG(C55/C56))+(LOG(C56/C57))*(LOG(C56/C57))+(LOG(C57/C58))*
(LOG(C57/C58))+(LOG(C58/C59))*(LOG(C58/C59))+(LOG(C59/C60))*
(LOG(C59/C60))+(LOG(C60/C61))*(LOG(C60/C61))+(LOG(C61/C62))*
(LOG(C61/C62))+(LOG(C62/C63))*(LOG(C62/C63))+(LOG(C63/C64))*
(LOG(C63/C64))+(LOG(C64/C65))*(LOG(C64/C65))+(LOG(C65/C66))*
(LOG(C65/C66))+(LOG(C66/C67))*(LOG(C66/C67))+(LOG(C67/C68))*
(LOG(C67/C68))+(LOG(C68/C69))*(LOG(C68/C69))+(LOG(C69/C70))*
(LOG(C69/C70))+(LOG(C70/C71))*(LOG(C70/C71))+(LOG(C71/C72))*
(LOG(C71/C72))+(LOG(C72/C73))*(LOG(C72/C73))+(LOG(C73/C74))*
(LOG(C73/C74))+(LOG(C74/C75))*(LOG(C74/C75))+(LOG(C75/C76))*
(LOG(C75/C76))+(LOG(C76/C77))*(LOG(C76/C77))+(LOG(C77/C78))*
(LOG(C77/C78))+(LOG(C78/C79))*(LOG(C78/C79))+(LOG(C79/C80))*
(LOG(C79/C80))+(LOG(C80/C81))*(LOG(C80/C81))+(LOG(C81/C82))*
(LOG(C81/C82))+(LOG(C82/C83))*(LOG(C82/C83))+(LOG(C83/C84))*
(LOG(C83/C84))+(LOG(C84/C85))*(LOG(C84/C85))+(LOG(C85/C86))*
(LOG(C85/C86))+(LOG(C86/C87))*(LOG(C86/C87))+(LOG(C87/C88))*
(LOG(C87/C88))+(LOG(C88/C89))*(LOG(C88/C89))+(LOG(C89/C90))*
(LOG(C89/C90))+(LOG(C90/C91))*(LOG(C90/C91))+(LOG(C91/C92))*
(LOG(C91/C92))+(LOG(C92/C93))*(LOG(C92/C93))+(LOG(C93/C94))*
(LOG(C93/C94))+(LOG(C94/C95))*(LOG(C94/C95))+(LOG(C95/C96))*
(LOG(C95/C96))+(LOG(C96/C97))*(LOG(C96/C97))+(LOG(C97/C98))*
(LOG(C97/C98))+(LOG(C98/C99))*(LOG(C98/C99))+(LOG(C99/C100))*
(LOG(C99/C100)))-((LOG(C/C1))+(LOG(C1/C2))+(LOG(C2/C3))+
(LOG(C3/C4))+(LOG(C4/C5))+(LOG(C5/C6))+(LOG(C6/C7))+
(LOG(C7/C8))+(LOG(C8/C9))+(LOG(C9/C10))+(LOG(C10/C11))+
(LOG(C11/C12))+(LOG(C12/C13))+(LOG(C13/C14))+(LOG(C14/C15))+
(LOG(C15/C16))+(LOG(C16/C17))+(LOG(C17/C18))+(LOG(C18/C19))+
(LOG(C19/C20))+(LOG(C20/C21))+(LOG(C21/C22))+(LOG(C22/C23))+
(LOG(C23/C24))+(LOG(C24/C25))+(LOG(C25/C26))+(LOG(C26/C27))+
(LOG(C27/C28))+(LOG(C28/C29))+(LOG(C29/C30))+(LOG(C30/C31))+
(LOG(C31/C32))+(LOG(C32/C33))+(LOG(C33/C34))+(LOG(C34/C35))+
(LOG(C35/C36))+(LOG(C36/C37))+(LOG(C37/C38))+(LOG(C38/C39))+
(LOG(C39/C40))+(LOG(C40/C41))+(LOG(C41/C42))+(LOG(C42/C43))+
(LOG(C43/C44))+(LOG(C44/C45))+(LOG(C45/C46))+(LOG(C46/C47))+
(LOG(C47/C48))+(LOG(C48/C49))+(LOG(C49/C50))+(LOG(C50/C51))+
(LOG(C51/C52))+(LOG(C52/C53))+(LOG(C53/C54))+(LOG(C54/C55))+
(LOG(C55/C56))+(LOG(C56/C57))+(LOG(C57/C58))+(LOG(C58/C59))+
(LOG(C59/C60))+(LOG(C60/C61))+(LOG(C61/C62))+(LOG(C62/C63))+
(LOG(C63/C64))+(LOG(C64/C65))+(LOG(C65/C66))+(LOG(C66/C67))+
(LOG(C67/C68))+(LOG(C68/C69))+(LOG(C69/C70))+(LOG(C70/C71))+
(LOG(C71/C72))+(LOG(C72/C73))+(LOG(C73/C74))+(LOG(C74/C75))+
(LOG(C75/C76))+(LOG(C76/C77))+(LOG(C77/C78))+(LOG(C78/C79))+
(LOG(C79/C80))+(LOG(C80/C81))+(LOG(C81/C82))+(LOG(C82/C83))+
(LOG(C83/C84))+(LOG(C84/C85))+(LOG(C85/C86))+(LOG(C86/C87))+
(LOG(C87/C88))+(LOG(C88/C89))+(LOG(C89/C90))+(LOG(C90/C91))+
(LOG(C91/C92))+(LOG(C92/C93))+(LOG(C93/C94))+(LOG(C94/C95))+
(LOG(C95/C96))+(LOG(C96/C97))+(LOG(C97/C98))+(LOG(C98/C99))+
(LOG(C99/C100)))*((LOG(C/C1))+(LOG(C1/C2))+(LOG(C2/C3))+
(LOG(C3/C4))+(LOG(C4/C5))+(LOG(C5/C6))+(LOG(C6/C7))+
(LOG(C7/C8))+(LOG(C8/C9))+(LOG(C9/C10))+(LOG(C10/C11))+
(LOG(C11/C12))+(LOG(C12/C13))+(LOG(C13/C14))+(LOG(C14/C15))+
(LOG(C15/C16))+(LOG(C16/C17))+(LOG(C17/C18))+(LOG(C18/C19))+
(LOG(C19/C20))+(LOG(C20/C21))+(LOG(C21/C22))+(LOG(C22/C23))+
(LOG(C23/C24))+(LOG(C24/C25))+(LOG(C25/C26))+(LOG(C26/C27))+
(LOG(C27/C28))+(LOG(C28/C29))+(LOG(C29/C30))+(LOG(C30/C31))+
(LOG(C31/C32))+(LOG(C32/C33))+(LOG(C33/C34))+(LOG(C34/C35))+
(LOG(C35/C36))+(LOG(C36/C37))+(LOG(C37/C38))+(LOG(C38/C39))+
(LOG(C39/C40))+(LOG(C40/C41))+(LOG(C41/C42))+(LOG(C42/C43))+
(LOG(C43/C44))+(LOG(C44/C45))+(LOG(C45/C46))+(LOG(C46/C47))+
(LOG(C47/C48))+(LOG(C48/C49))+(LOG(C49/C50))+(LOG(C50/C51))+
(LOG(C51/C52))+(LOG(C52/C53))+(LOG(C53/C54))+(LOG(C54/C55))+
(LOG(C55/C56))+(LOG(C56/C57))+(LOG(C57/C58))+(LOG(C58/C59))+
(LOG(C59/C60))+(LOG(C60/C61))+(LOG(C61/C62))+(LOG(C62/C63))+
(LOG(C63/C64))+(LOG(C64/C65))+(LOG(C65/C66))+(LOG(C66/C67))+
(LOG(C67/C68))+(LOG(C68/C69))+(LOG(C69/C70))+(LOG(C70/C71))+
(LOG(C71/C72))+(LOG(C72/C73))+(LOG(C73/C74))+(LOG(C74/C75))+
(LOG(C75/C76))+(LOG(C76/C77))+(LOG(C77/C78))+(LOG(C78/C79))+
(LOG(C79/C80))+(LOG(C80/C81))+(LOG(C81/C82))+(LOG(C82/C83))+
(LOG(C83/C84))+(LOG(C84/C85))+(LOG(C85/C86))+(LOG(C86/C87))+
(LOG(C87/C88))+(LOG(C88/C89))+(LOG(C89/C90))+(LOG(C90/C91))+
(LOG(C91/C92))+(LOG(C92/C93))+(LOG(C93/C94))+(LOG(C94/C95))+
(LOG(C95/C96))+(LOG(C96/C97))+(LOG(C97/C98))+(LOG(C98/C99))+
(LOG(C99/C100))))/(100*100))))*100*16.1245)


HISTORICAL VOLATILITY RATIO PCFS

From an Educational article, “Volatility in Action” by
Dave Landry available at tradingmarkets.com
Divide the short-term volatility reading by the long-term reading
i.e. for stocks: (6 HV PCF/100 HV PCF)

Email 4/29/01
One certainly can use one or either part of this Pcf
(i.e. 6/100 or 10/100). I use these with NR4 & ID pcfs
for HV breakout systems. I am enclosing it as this
will also be useful to a lot of people.

Regards
Sammy_4_1


HV Ratio (6/100 & 10/100 )

(((SQR((10*((LOG(C/C1))*(LOG(C/C1))+
(LOG(C1/C2))*(LOG(C1/C2))+(LOG(C2/C3))*
(LOG(C2/C3))+(LOG(C3/C4))*(LOG(C3/C4))+
(LOG(C4/C5))*(LOG(C4/C5))+(LOG(C5/C6))*
(LOG(C5/C6))+(LOG(C6/C7))*(LOG(C6/C7))+
(LOG(C7/C8))*(LOG(C7/C8))+(LOG(C8/C9))*
(LOG(C8/C9))+(LOG(C9/C10))*(LOG(C9/C10)))-
((LOG(C/C1))+(LOG(C1/C2))+(LOG(C2/C3))+
(LOG(C3/C4))+(LOG(C4/C5))+(LOG(C5/C6))+
(LOG(C6/C7))+(LOG(C7/C8))+(LOG(C8/C9))+
(LOG(C9/C10)))*((LOG(C/C1))+(LOG(C1/C2))+
(LOG(C2/C3))+(LOG(C3/C4))+(LOG(C4/C5))+
(LOG(C5/C6))+(LOG(C6/C7))+(LOG(C7/C8))+
(LOG(C8/C9))+(LOG(C9/C10))))/(10*10))))
*100*16.1245)<=(((((SQR((100*((LOG(C/C1))
*(LOG(C/C1))+(LOG(C1/C2))*(LOG(C1/C2))+
(LOG(C2/C3))*(LOG(C2/C3))+(LOG(C3/C4))*
(LOG(C3/C4))+(LOG(C4/C5))*(LOG(C4/C5))+
(LOG(C5/C6))*(LOG(C5/C6))+(LOG(C6/C7))*
(LOG(C6/C7))+(LOG(C7/C8))*(LOG(C7/C8))+
(LOG(C8/C9))*(LOG(C8/C9))+(LOG(C9/C10))*
(LOG(C9/C10))+(LOG(C10/C11))*(LOG(C10/C11))+
(LOG(C11/C12))*(LOG(C11/C12))+(LOG(C12/C13))*(LOG(C12/C13))+
(LOG(C13/C14))*(LOG(C13/C14))+(LOG(C14/C15))*(LOG(C14/C15))+
(LOG(C15/C16))*(LOG(C15/C16))+(LOG(C16/C17))*(LOG(C16/C17))+
(LOG(C17/C18))*(LOG(C17/C18))+(LOG(C18/C19))*(LOG(C18/C19))+
(LOG(C19/C20))*(LOG(C19/C20))+(LOG(C20/C21))*(LOG(C20/C21))+
(LOG(C21/C22))*(LOG(C21/C22))+(LOG(C22/C23))*(LOG(C22/C23))+
(LOG(C23/C24))*(LOG(C23/C24))+(LOG(C24/C25))*(LOG(C24/C25))+
(LOG(C25/C26))*(LOG(C25/C26))+(LOG(C26/C27))*(LOG(C26/C27))+
(LOG(C27/C28))*(LOG(C27/C28))+(LOG(C28/C29))*(LOG(C28/C29))+
(LOG(C29/C30))*(LOG(C29/C30))+(LOG(C30/C31))*(LOG(C30/C31))+
(LOG(C31/C32))*(LOG(C31/C32))+(LOG(C32/C33))*(LOG(C32/C33))+
(LOG(C33/C34))*(LOG(C33/C34))+(LOG(C34/C35))*(LOG(C34/C35))+
(LOG(C35/C36))*(LOG(C35/C36))+(LOG(C36/C37))*(LOG(C36/C37))+
(LOG(C37/C38))*(LOG(C37/C38))+(LOG(C38/C39))*(LOG(C38/C39))+
(LOG(C39/C40))*(LOG(C39/C40))+(LOG(C40/C41))*(LOG(C40/C41))+
(LOG(C41/C42))*(LOG(C41/C42))+(LOG(C42/C43))*(LOG(C42/C43))+
(LOG(C43/C44))*(LOG(C43/C44))+(LOG(C44/C45))*(LOG(C44/C45))+
(LOG(C45/C46))*(LOG(C45/C46))+(LOG(C46/C47))*(LOG(C46/C47))+
(LOG(C47/C48))*(LOG(C47/C48))+(LOG(C48/C49))*(LOG(C48/C49))+
(LOG(C49/C50))*(LOG(C49/C50))+(LOG(C50/C51))*(LOG(C50/C51))+
(LOG(C51/C52))*(LOG(C51/C52))+(LOG(C52/C53))*(LOG(C52/C53))+
(LOG(C53/C54))*(LOG(C53/C54))+(LOG(C54/C55))*(LOG(C54/C55))+
(LOG(C55/C56))*(LOG(C55/C56))+(LOG(C56/C57))*(LOG(C56/C57))+
(LOG(C57/C58))*(LOG(C57/C58))+(LOG(C58/C59))*(LOG(C58/C59))+
(LOG(C59/C60))*(LOG(C59/C60))+(LOG(C60/C61))*(LOG(C60/C61))+
(LOG(C61/C62))*(LOG(C61/C62))+(LOG(C62/C63))*(LOG(C62/C63))+
(LOG(C63/C64))*(LOG(C63/C64))+(LOG(C64/C65))*(LOG(C64/C65))+
(LOG(C65/C66))*(LOG(C65/C66))+(LOG(C66/C67))*(LOG(C66/C67))+
(LOG(C67/C68))*(LOG(C67/C68))+(LOG(C68/C69))*(LOG(C68/C69))+
(LOG(C69/C70))*(LOG(C69/C70))+(LOG(C70/C71))*(LOG(C70/C71))+
(LOG(C71/C72))*(LOG(C71/C72))+(LOG(C72/C73))*(LOG(C72/C73))+
(LOG(C73/C74))*(LOG(C73/C74))+(LOG(C74/C75))*(LOG(C74/C75))+
(LOG(C75/C76))*(LOG(C75/C76))+(LOG(C76/C77))*(LOG(C76/C77))+
(LOG(C77/C78))*(LOG(C77/C78))+(LOG(C78/C79))*(LOG(C78/C79))+
(LOG(C79/C80))*(LOG(C79/C80))+(LOG(C80/C81))*(LOG(C80/C81))+
(LOG(C81/C82))*(LOG(C81/C82))+(LOG(C82/C83))*(LOG(C82/C83))+
(LOG(C83/C84))*(LOG(C83/C84))+(LOG(C84/C85))*(LOG(C84/C85))+
(LOG(C85/C86))*(LOG(C85/C86))+(LOG(C86/C87))*(LOG(C86/C87))+
(LOG(C87/C88))*(LOG(C87/C88))+(LOG(C88/C89))*(LOG(C88/C89))+
(LOG(C89/C90))*(LOG(C89/C90))+(LOG(C90/C91))*(LOG(C90/C91))+
(LOG(C91/C92))*(LOG(C91/C92))+(LOG(C92/C93))*(LOG(C92/C93))+
(LOG(C93/C94))*(LOG(C93/C94))+(LOG(C94/C95))*(LOG(C94/C95))+
(LOG(C95/C96))*(LOG(C95/C96))+(LOG(C96/C97))*(LOG(C96/C97))+
(LOG(C97/C98))*(LOG(C97/C98))+(LOG(C98/C99))*(LOG(C98/C99))+
(LOG(C99/C100))*(LOG(C99/C100)))-((LOG(C/C1))+(LOG(C1/C2))+(LOG(C2/C3))+(LOG(C3/C4))+(LOG(C4/C5))+
(LOG(C5/C6))+(LOG(C6/C7))+(LOG(C7/C8))+(LOG(C8/C9))+(LOG(C9/C10))+
(LOG(C10/C11))+(LOG(C11/C12))+(LOG(C12/C13))+(LOG(C13/C14))+
(LOG(C14/C15))+(LOG(C15/C16))+(LOG(C16/C17))+(LOG(C17/C18))+
(LOG(C18/C19))+(LOG(C19/C20))+(LOG(C20/C21))+(LOG(C21/C22))+
(LOG(C22/C23))+(LOG(C23/C24))+(LOG(C24/C25))+(LOG(C25/C26))+
(LOG(C26/C27))+(LOG(C27/C28))+(LOG(C28/C29))+(LOG(C29/C30))+
(LOG(C30/C31))+(LOG(C31/C32))+(LOG(C32/C33))+(LOG(C33/C34))+
(LOG(C34/C35))+(LOG(C35/C36))+(LOG(C36/C37))+(LOG(C37/C38))+
(LOG(C38/C39))+(LOG(C39/C40))+(LOG(C40/C41))+(LOG(C41/C42))+
(LOG(C42/C43))+(LOG(C43/C44))+(LOG(C44/C45))+(LOG(C45/C46))+
(LOG(C46/C47))+(LOG(C47/C48))+(LOG(C48/C49))+(LOG(C49/C50))+
(LOG(C50/C51))+(LOG(C51/C52))+(LOG(C52/C53))+(LOG(C53/C54))+
(LOG(C54/C55))+(LOG(C55/C56))+(LOG(C56/C57))+(LOG(C57/C58))+
(LOG(C58/C59))+(LOG(C59/C60))+(LOG(C60/C61))+(LOG(C61/C62))+
(LOG(C62/C63))+(LOG(C63/C64))+(LOG(C64/C65))+(LOG(C65/C66))+
(LOG(C66/C67))+(LOG(C67/C68))+(LOG(C68/C69))+(LOG(C69/C70))+
(LOG(C70/C71))+(LOG(C71/C72))+(LOG(C72/C73))+(LOG(C73/C74))+
(LOG(C74/C75))+(LOG(C75/C76))+(LOG(C76/C77))+(LOG(C77/C78))+
(LOG(C78/C79))+(LOG(C79/C80))+(LOG(C80/C81))+(LOG(C81/C82))+
(LOG(C82/C83))+(LOG(C83/C84))+(LOG(C84/C85))+(LOG(C85/C86))+
(LOG(C86/C87))+(LOG(C87/C88))+(LOG(C88/C89))+(LOG(C89/C90))+
(LOG(C90/C91))+(LOG(C91/C92))+(LOG(C92/C93))+(LOG(C93/C94))+
(LOG(C94/C95))+(LOG(C95/C96))+(LOG(C96/C97))+(LOG(C97/C98))+
(LOG(C98/C99))+(LOG(C99/C100)))*
((LOG(C/C1))+(LOG(C1/C2))+(LOG(C2/C3))+(LOG(C3/C4))+(LOG(C4/C5))+
(LOG(C5/C6))+(LOG(C6/C7))+(LOG(C7/C8))+(LOG(C8/C9))+(LOG(C9/C10))+
(LOG(C10/C11))+(LOG(C11/C12))+(LOG(C12/C13))+(LOG(C13/C14))+
(LOG(C14/C15))+(LOG(C15/C16))+(LOG(C16/C17))+(LOG(C17/C18))+
(LOG(C18/C19))+(LOG(C19/C20))+(LOG(C20/C21))+(LOG(C21/C22))+
(LOG(C22/C23))+(LOG(C23/C24))+(LOG(C24/C25))+(LOG(C25/C26))+
(LOG(C26/C27))+(LOG(C27/C28))+(LOG(C28/C29))+(LOG(C29/C30))+
(LOG(C30/C31))+(LOG(C31/C32))+(LOG(C32/C33))+(LOG(C33/C34))+
(LOG(C34/C35))+(LOG(C35/C36))+(LOG(C36/C37))+(LOG(C37/C38))+
(LOG(C38/C39))+(LOG(C39/C40))+(LOG(C40/C41))+(LOG(C41/C42))+
(LOG(C42/C43))+(LOG(C43/C44))+(LOG(C44/C45))+(LOG(C45/C46))+
(LOG(C46/C47))+(LOG(C47/C48))+(LOG(C48/C49))+(LOG(C49/C50))+
(LOG(C50/C51))+(LOG(C51/C52))+(LOG(C52/C53))+(LOG(C53/C54))+
(LOG(C54/C55))+(LOG(C55/C56))+(LOG(C56/C57))+(LOG(C57/C58))+
(LOG(C58/C59))+(LOG(C59/C60))+(LOG(C60/C61))+(LOG(C61/C62))+
(LOG(C62/C63))+(LOG(C63/C64))+(LOG(C64/C65))+(LOG(C65/C66))+
(LOG(C66/C67))+(LOG(C67/C68))+(LOG(C68/C69))+(LOG(C69/C70))+
(LOG(C70/C71))+(LOG(C71/C72))+(LOG(C72/C73))+(LOG(C73/C74))+
(LOG(C74/C75))+(LOG(C75/C76))+(LOG(C76/C77))+(LOG(C77/C78))+
(LOG(C78/C79))+(LOG(C79/C80))+(LOG(C80/C81))+(LOG(C81/C82))+
(LOG(C82/C83))+(LOG(C83/C84))+(LOG(C84/C85))+(LOG(C85/C86))+
(LOG(C86/C87))+(LOG(C87/C88))+(LOG(C88/C89))+(LOG(C89/C90))+
(LOG(C90/C91))+(LOG(C91/C92))+(LOG(C92/C93))+(LOG(C93/C94))+
(LOG(C94/C95))+(LOG(C95/C96))+(LOG(C96/C97))+(LOG(C97/C98))+
(LOG(C98/C99))+(LOG(C99/C100))))/(100*100))))*100*16.1245))*
0.5)AND
(((((SQR((6*((LOG(C/C1))*(LOG(C/C1))+(LOG(C1/C2))*(LOG(C1/C2))+
(LOG(C2/C3))*(LOG(C2/C3))+(LOG(C3/C4))*(LOG(C3/C4))+
(LOG(C4/C5))*(LOG(C4/C5))+(LOG(C5/C6))*(LOG(C5/C6)))-((LOG(C/C1))+(LOG(C1/C2))+(LOG(C2/C3))+(LOG(C3/C4))+
(LOG(C4/C5))+(LOG(C5/C6)))*((LOG(C/C1))+(LOG(C1/C2))+
(LOG(C2/C3))+(LOG(C3/C4))+(LOG(C4/C5))+(LOG(C5/C6))))/
(6*6))))*100*16.1245))<=(((((SQR((100*((LOG(C/C1))*
(LOG(C/C1))+(LOG(C1/C2))*(LOG(C1/C2))+(LOG(C2/C3))*(LOG(C2/C3))+
(LOG(C3/C4))*(LOG(C3/C4))+(LOG(C4/C5))*(LOG(C4/C5))+(LOG(C5/C6))*
(LOG(C5/C6))+(LOG(C6/C7))*(LOG(C6/C7))+(LOG(C7/C8))*(LOG(C7/C8))+
(LOG(C8/C9))*(LOG(C8/C9))+(LOG(C9/C10))*(LOG(C9/C10))+(LOG(C10/C11))*
(LOG(C10/C11))+(LOG(C11/C12))*(LOG(C11/C12))+(LOG(C12/C13))*
(LOG(C12/C13))+(LOG(C13/C14))*(LOG(C13/C14))+(LOG(C14/C15))*
(LOG(C14/C15))+(LOG(C15/C16))*(LOG(C15/C16))+(LOG(C16/C17))*
(LOG(C16/C17))+(LOG(C17/C18))*(LOG(C17/C18))+(LOG(C18/C19))*
(LOG(C18/C19))+(LOG(C19/C20))*(LOG(C19/C20))+(LOG(C20/C21))*
(LOG(C20/C21))+(LOG(C21/C22))*(LOG(C21/C22))+(LOG(C22/C23))*
(LOG(C22/C23))+(LOG(C23/C24))*(LOG(C23/C24))+(LOG(C24/C25))*
(LOG(C24/C25))+(LOG(C25/C26))*(LOG(C25/C26))+(LOG(C26/C27))*
(LOG(C26/C27))+(LOG(C27/C28))*(LOG(C27/C28))+(LOG(C28/C29))*
(LOG(C28/C29))+(LOG(C29/C30))*(LOG(C29/C30))+(LOG(C30/C31))*
(LOG(C30/C31))+(LOG(C31/C32))*(LOG(C31/C32))+(LOG(C32/C33))*
(LOG(C32/C33))+(LOG(C33/C34))*(LOG(C33/C34))+(LOG(C34/C35))*
(LOG(C34/C35))+(LOG(C35/C36))*(LOG(C35/C36))+(LOG(C36/C37))*
(LOG(C36/C37))+(LOG(C37/C38))*(LOG(C37/C38))+(LOG(C38/C39))*
(LOG(C38/C39))+(LOG(C39/C40))*(LOG(C39/C40))+(LOG(C40/C41))*
(LOG(C40/C41))+(LOG(C41/C42))*(LOG(C41/C42))+(LOG(C42/C43))*
(LOG(C42/C43))+(LOG(C43/C44))*(LOG(C43/C44))+(LOG(C44/C45))*
(LOG(C44/C45))+(LOG(C45/C46))*(LOG(C45/C46))+(LOG(C46/C47))*
(LOG(C46/C47))+(LOG(C47/C48))*(LOG(C47/C48))+(LOG(C48/C49))*
(LOG(C48/C49))+(LOG(C49/C50))*(LOG(C49/C50))+(LOG(C50/C51))*
(LOG(C50/C51))+(LOG(C51/C52))*(LOG(C51/C52))+(LOG(C52/C53))*
(LOG(C52/C53))+(LOG(C53/C54))*(LOG(C53/C54))+(LOG(C54/C55))*
(LOG(C54/C55))+(LOG(C55/C56))*(LOG(C55/C56))+(LOG(C56/C57))*
(LOG(C56/C57))+(LOG(C57/C58))*(LOG(C57/C58))+(LOG(C58/C59))*
(LOG(C58/C59))+(LOG(C59/C60))*(LOG(C59/C60))+(LOG(C60/C61))*
(LOG(C60/C61))+(LOG(C61/C62))*(LOG(C61/C62))+(LOG(C62/C63))*
(LOG(C62/C63))+(LOG(C63/C64))*(LOG(C63/C64))+(LOG(C64/C65))*
(LOG(C64/C65))+(LOG(C65/C66))*(LOG(C65/C66))+(LOG(C66/C67))*
(LOG(C66/C67))+(LOG(C67/C68))*(LOG(C67/C68))+(LOG(C68/C69))*
(LOG(C68/C69))+(LOG(C69/C70))*(LOG(C69/C70))+(LOG(C70/C71))*
(LOG(C70/C71))+(LOG(C71/C72))*(LOG(C71/C72))+(LOG(C72/C73))*
(LOG(C72/C73))+(LOG(C73/C74))*(LOG(C73/C74))+(LOG(C74/C75))*
(LOG(C74/C75))+(LOG(C75/C76))*(LOG(C75/C76))+(LOG(C76/C77))*
(LOG(C76/C77))+(LOG(C77/C78))*(LOG(C77/C78))+(LOG(C78/C79))*
(LOG(C78/C79))+(LOG(C79/C80))*(LOG(C79/C80))+(LOG(C80/C81))*
(LOG(C80/C81))+(LOG(C81/C82))*(LOG(C81/C82))+(LOG(C82/C83))*
(LOG(C82/C83))+(LOG(C83/C84))*(LOG(C83/C84))+(LOG(C84/C85))*
(LOG(C84/C85))+(LOG(C85/C86))*(LOG(C85/C86))+(LOG(C86/C87))*
(LOG(C86/C87))+(LOG(C87/C88))*(LOG(C87/C88))+(LOG(C88/C89))*
(LOG(C88/C89))+(LOG(C89/C90))*(LOG(C89/C90))+(LOG(C90/C91))*
(LOG(C90/C91))+(LOG(C91/C92))*(LOG(C91/C92))+(LOG(C92/C93))*
(LOG(C92/C93))+(LOG(C93/C94))*(LOG(C93/C94))+(LOG(C94/C95))*
(LOG(C94/C95))+(LOG(C95/C96))*(LOG(C95/C96))+(LOG(C96/C97))*
(LOG(C96/C97))+(LOG(C97/C98))*(LOG(C97/C98))+(LOG(C98/C99))*
(LOG(C98/C99))+(LOG(C99/C100))*(LOG(C99/C100)))-
((LOG(C/C1))+(LOG(C1/C2))+(LOG(C2/C3))+(LOG(C3/C4))+(LOG(C4/C5))+
(LOG(C5/C6))+(LOG(C6/C7))+(LOG(C7/C8))+(LOG(C8/C9))+(LOG(C9/C10))+
(LOG(C10/C11))+(LOG(C11/C12))+(LOG(C12/C13))+(LOG(C13/C14))+
(LOG(C14/C15))+(LOG(C15/C16))+(LOG(C16/C17))+(LOG(C17/C18))+
(LOG(C18/C19))+(LOG(C19/C20))+(LOG(C20/C21))+(LOG(C21/C22))+
(LOG(C22/C23))+(LOG(C23/C24))+(LOG(C24/C25))+(LOG(C25/C26))+
(LOG(C26/C27))+(LOG(C27/C28))+(LOG(C28/C29))+(LOG(C29/C30))+
(LOG(C30/C31))+(LOG(C31/C32))+(LOG(C32/C33))+(LOG(C33/C34))+
(LOG(C34/C35))+(LOG(C35/C36))+(LOG(C36/C37))+(LOG(C37/C38))+
(LOG(C38/C39))+(LOG(C39/C40))+(LOG(C40/C41))+(LOG(C41/C42))+
(LOG(C42/C43))+(LOG(C43/C44))+(LOG(C44/C45))+(LOG(C45/C46))+
(LOG(C46/C47))+(LOG(C47/C48))+(LOG(C48/C49))+(LOG(C49/C50))+
(LOG(C50/C51))+(LOG(C51/C52))+(LOG(C52/C53))+(LOG(C53/C54))+
(LOG(C54/C55))+(LOG(C55/C56))+(LOG(C56/C57))+(LOG(C57/C58))+
(LOG(C58/C59))+(LOG(C59/C60))+(LOG(C60/C61))+(LOG(C61/C62))+
(LOG(C62/C63))+(LOG(C63/C64))+(LOG(C64/C65))+(LOG(C65/C66))+
(LOG(C66/C67))+(LOG(C67/C68))+(LOG(C68/C69))+(LOG(C69/C70))+
(LOG(C70/C71))+(LOG(C71/C72))+(LOG(C72/C73))+(LOG(C73/C74))+
(LOG(C74/C75))+(LOG(C75/C76))+(LOG(C76/C77))+(LOG(C77/C78))+
(LOG(C78/C79))+(LOG(C79/C80))+(LOG(C80/C81))+(LOG(C81/C82))+
(LOG(C82/C83))+(LOG(C83/C84))+(LOG(C84/C85))+(LOG(C85/C86))+
(LOG(C86/C87))+(LOG(C87/C88))+(LOG(C88/C89))+(LOG(C89/C90))+
(LOG(C90/C91))+(LOG(C91/C92))+(LOG(C92/C93))+(LOG(C93/C94))+
(LOG(C94/C95))+(LOG(C95/C96))+(LOG(C96/C97))+(LOG(C97/C98))+
(LOG(C98/C99))+(LOG(C99/C100)))*((LOG(C/C1))+(LOG(C1/C2))+
(LOG(C2/C3))+(LOG(C3/C4))+(LOG(C4/C5))+(LOG(C5/C6))+(LOG(C6/C7))+
(LOG(C7/C8))+(LOG(C8/C9))+(LOG(C9/C10))+(LOG(C10/C11))+
(LOG(C11/C12))+(LOG(C12/C13))+(LOG(C13/C14))+(LOG(C14/C15))+
(LOG(C15/C16))+(LOG(C16/C17))+(LOG(C17/C18))+(LOG(C18/C19))+
(LOG(C19/C20))+(LOG(C20/C21))+(LOG(C21/C22))+(LOG(C22/C23))+
(LOG(C23/C24))+(LOG(C24/C25))+(LOG(C25/C26))+(LOG(C26/C27))+
(LOG(C27/C28))+(LOG(C28/C29))+(LOG(C29/C30))+(LOG(C30/C31))+
(LOG(C31/C32))+(LOG(C32/C33))+(LOG(C33/C34))+(LOG(C34/C35))+
(LOG(C35/C36))+(LOG(C36/C37))+(LOG(C37/C38))+(LOG(C38/C39))+
(LOG(C39/C40))+(LOG(C40/C41))+(LOG(C41/C42))+(LOG(C42/C43))+
(LOG(C43/C44))+(LOG(C44/C45))+(LOG(C45/C46))+(LOG(C46/C47))+
(LOG(C47/C48))+(LOG(C48/C49))+(LOG(C49/C50))+(LOG(C50/C51))+
(LOG(C51/C52))+(LOG(C52/C53))+(LOG(C53/C54))+(LOG(C54/C55))+
(LOG(C55/C56))+(LOG(C56/C57))+(LOG(C57/C58))+(LOG(C58/C59))+
(LOG(C59/C60))+(LOG(C60/C61))+(LOG(C61/C62))+(LOG(C62/C63))+
(LOG(C63/C64))+(LOG(C64/C65))+(LOG(C65/C66))+(LOG(C66/C67))+
(LOG(C67/C68))+(LOG(C68/C69))+(LOG(C69/C70))+(LOG(C70/C71))+
(LOG(C71/C72))+(LOG(C72/C73))+(LOG(C73/C74))+(LOG(C74/C75))+
(LOG(C75/C76))+(LOG(C76/C77))+(LOG(C77/C78))+(LOG(C78/C79))+
(LOG(C79/C80))+(LOG(C80/C81))+(LOG(C81/C82))+(LOG(C82/C83))+
(LOG(C83/C84))+(LOG(C84/C85))+(LOG(C85/C86))+(LOG(C86/C87))+
(LOG(C87/C88))+(LOG(C88/C89))+(LOG(C89/C90))+(LOG(C90/C91))+
(LOG(C91/C92))+(LOG(C92/C93))+(LOG(C93/C94))+(LOG(C94/C95))+
(LOG(C95/C96))+(LOG(C96/C97))+(LOG(C97/C98))+(LOG(C98/C99))+
(LOG(C99/C100))))/(100*100))))*100*16.1245))*0.5))