Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-21-2008, 06:02 PM
erbbbb erbbbb is offline
Novice
too mind boggling for the eyes please help
 
Join Date: Dec 2008
Posts: 1
erbbbb is on a distinguished road
Default too mind boggling for the eyes please help

I have started a formula that i need to continue to repeat 390 times for the 390 minutes that occour in the six and a half hour time frame between the hours of 930 am and 4 pm. The directions for a continuation of the formula are as follows:



To create the formula, copy the previous section and then increase the time by a minute +(Bar[Hour,1]*100+Bar[Minute,1]=940) would then become +(Bar[Hour,1]*100+Bar[Minute,1]=941). At the end of the numerator, add the next price*volume: +Bar[Close,1,10]*Bar[Volume,1,10])/(Bar[Volume,1] becomes +Bar[Close,1,10]*Bar[Volume,1,10]+Bar[Close,1,11]*Bar[Volume1,11)/(Bar[Volume,1]. And added the next volume to the end of the formula: +Bar[Volume,1,10])) becomes +Bar[Volume,1,10]+Bar[Volume,1,1

For this formula i have completed the first ten minutes of the day starting at nine thirty am to nineforty am..I will post that example at the bottom of this posting. My question is there an easier way of continuing and completing this formula until 4 pm without having my eyes fall out of my head?

(Bar[Hour,1]*100+Bar[Minute,1]=930)*((Bar[Close,1]*Bar[Volume,1])/(Bar[Volume,1]))+(Bar[Hour,1]*100+Bar[Minute,1]=931)*((Bar[Close,1]*Bar[Volume,1]+Bar[Close,1,1]*Bar[Volume,1,1])/(Bar[Volume,1]+Bar[Volume,1,1]))+(Bar[Hour,1]*100+Bar[Minute,1]=932)*((Bar[Close,1]*Bar[Volume,1]+Bar[Close,1,1]*Bar[Volume,1,1]+Bar[Close,1,2]*Bar[Volume,1,2])/(Bar[Volume,1]+Bar[Volume,1,1]+Bar[Volume,1,2]))
+(Bar[Hour,1]*100+Bar[Minute,1]=933)*((Bar[Close,1]*Bar[Volume,1]+Bar[Close,1,1]*Bar[Volume,1,1]+Bar[Close,1,2]*Bar[Volume,1,2]+Bar[Close,1,3]*Bar[Volume,1,3])/(Bar[Volume,1]+Bar[Volume,1,1]+Bar[Volume,1,2]+Bar[Volume,1,3]))
+(Bar[Hour,1]*100+Bar[Minute,1]=934)*((Bar[Close,1]*Bar[Volume,1]+Bar[Close,1,1]*Bar[Volume,1,1]+Bar[Close,1,2]*Bar[Volume,1,2]+Bar[Close,1,3]*Bar[Volume,1,3]+Bar[Close,1,4]*Bar[Volume,1,4])/(Bar[Volume,1]+Bar[Volume,1,1]+Bar[Volume,1,2]+Bar[Volume,1,3]+Bar[Volume,1,4]))
+(Bar[Hour,1]*100+Bar[Minute,1]=935)*((Bar[Close,1]*Bar[Volume,1]+Bar[Close,1,1]*Bar[Volume,1,1]+Bar[Close,1,2]*Bar[Volume,1,2]+Bar[Close,1,3]*Bar[Volume,1,3]+Bar[Close,1,4]*Bar[Volume,1,4]+Bar[Close,1,5]*Bar[Volume,1,5])/(Bar[Volume,1]+Bar[Volume,1,1]+Bar[Volume,1,2]+Bar[Volume,1,3]+Bar[Volume,1,4]+Bar[Volume,1,5]))
+(Bar[Hour,1]*100+Bar[Minute,1]=936)*((Bar[Close,1]*Bar[Volume,1]+Bar[Close,1,1]*Bar[Volume,1,1]+Bar[Close,1,2]*Bar[Volume,1,2]+Bar[Close,1,3]*Bar[Volume,1,3]+Bar[Close,1,4]*Bar[Volume,1,4]+Bar[Close,1,5]*Bar[Volume,1,5]+Bar[Close,1,6]*Bar[Volume,1,6])/(Bar[Volume,1]+Bar[Volume,1,1]+Bar[Volume,1,2]+Bar[Volume,1,3]+Bar[Volume,1,4]+Bar[Volume,1,5]+Bar[Volume,1,6]))
+(Bar[Hour,1]*100+Bar[Minute,1]=937)*((Bar[Close,1]*Bar[Volume,1]+Bar[Close,1,1]*Bar[Volume,1,1]+Bar[Close,1,2]*Bar[Volume,1,2]+Bar[Close,1,3]*Bar[Volume,1,3]+Bar[Close,1,4]*Bar[Volume,1,4]+Bar[Close,1,5]*Bar[Volume,1,5]+Bar[Close,1,6]*Bar[Volume,1,6]+Bar[Close,1,7]*Bar[Volume,1,7])/(Bar[Volume,1]+Bar[Volume,1,1]+Bar[Volume,1,2]+Bar[Volume,1,3]+Bar[Volume,1,4]+Bar[Volume,1,5]+Bar[Volume,1,6]+Bar[Volume,1,7]))
+(Bar[Hour,1]*100+Bar[Minute,1]=938)*((Bar[Close,1]*Bar[Volume,1]+Bar[Close,1,1]*Bar[Volume,1,1]+Bar[Close,1,2]*Bar[Volume,1,2]+Bar[Close,1,3]*Bar[Volume,1,3]+Bar[Close,1,4]*Bar[Volume,1,4]+Bar[Close,1,5]*Bar[Volume,1,5]+Bar[Close,1,6]*Bar[Volume,1,6]+Bar[Close,1,7]*Bar[Volume,1,7]+Bar[Close,1,8]*Bar[Volume,1,8])/(Bar[Volume,1]+Bar[Volume,1,1]+Bar[Volume,1,2]+Bar[Volume,1,3]+Bar[Volume,1,4]+Bar[Volume,1,5]+Bar[Volume,1,6]+Bar[Volume,1,7]+Bar[Volume,1,8]))
+(Bar[Hour,1]*100+Bar[Minute,1]=939)*((Bar[Close,1]*Bar[Volume,1]+Bar[Close,1,1]*Bar[Volume,1,1]+Bar[Close,1,2]*Bar[Volume,1,2]+Bar[Close,1,3]*Bar[Volume,1,3]+Bar[Close,1,4]*Bar[Volume,1,4]+Bar[Close,1,5]*Bar[Volume,1,5]+Bar[Close,1,6]*Bar[Volume,1,6]+Bar[Close,1,7]*Bar[Volume,1,7]+Bar[Close,1,8]*Bar[Volume,1,8]+Bar[Close,1,9]*Bar[Volume,1,9])/(Bar[Volume,1]+Bar[Volume,1,1]+Bar[Volume,1,2]+Bar[Volume,1,3]+Bar[Volume,1,4]+Bar[Volume,1,5]+Bar[Volume,1,6]+Bar[Volume,1,7]+Bar[Volume,1,8]+Bar[Volume,1,9]))
+(Bar[Hour,1]*100+Bar[Minute,1]=940)*((Bar[Close,1]*Bar[Volume,1]+Bar[Close,1,1]*Bar[Volume,1,1]+Bar[Close,1,2]*Bar[Volume,1,2]+Bar[Close,1,3]*Bar[Volume,1,3]+Bar[Close,1,4]*Bar[Volume,1,4]+Bar[Close,1,5]*Bar[Volume,1,5]+Bar[Close,1,6]*Bar[Volume,1,6]+Bar[Close,1,7]*Bar[Volume,1,7]+Bar[Close,1,8]*Bar[Volume,1,8]+Bar[Close,1,9]*Bar[Volume,1,9]+Bar[Close,1,10]*Bar[Volume,1,10])/(Bar[Volume,1]+Bar[Volume,1,1]+Bar[Volume,1,2]+Bar[Volume,1,3]+Bar[Volume,1,4]+Bar[Volume,1,5]+Bar[Volume,1,6]+Bar[Volume,1,7]+Bar[Volume,1,8]+Bar[Volume,1,9]+Bar[Volume,1,10]))
Reply With Quote
Reply

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 02:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft