Monday, August 4, 2008

Scanning the stocks.........

There is some problem .......the formulas those I applied on the sheet that i uploded at google docks are not appearing........let me right here the manual process.......

Colums A ........Name of the Stock

Column B C D ......high low & close respectively.

Column E .....High - Low .....

Column F......Type-1 (near high)

Now apply the formula in column F.......if e<5,E,0

Column G.....Close- Low

Column H......Type-2

repet the same formula in column H.

or find the sheet here......

http://rapidshare.com/files/134816711/scan.xls.html

No comments: