Column for Moving Average of Prices

A

arunkw

New Member
#1
#1
Dear Guys,

At end of everyday after market hours, I download the bhavcopy from NSE site and use it in my excel sheet to find out the moving averages.

Columns which are in bhavcopy are

  1. SYMBOL
  2. SERIES
  3. OPEN
  4. HIGH
  5. LOW
  6. CLOSE
  7. LAST
  8. PREVCLOSE
  9. TOTTRDQTY
  10. TOTTRDVAL
  11. TIMESTAMP

I use column No. 6 'CLOSE' in my moving averages for price. Am I right? or is it some other column.

Thanks
 
S

skarpio

Active Member
#2
#2
A moving average is an average after all. If you use Close, then you get a moving average of closing prices. Infact, Close seems to be a very popular choice among the trading community.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
V RSIa(HHV(High,-125),14) this is resulting in column with values of 100 AmiBroker 2
H How to add or delete desired columns in zerodha pi marketwatch excel file? Intraday 1
R Using the logic within a ranking column... AmiBroker 1
R Can someone help on the proper use of 'addtextcolumn' function ??? AmiBroker 17
C how to add custom column to the stocks imported from metastock? AmiBroker 2

Similar threads