to calculate 26 weeks high low avg closing prices


This query is : Resolved 

(Querist)
09 September 2010 relevant date 23/08/2010
i have to calculate 26 weeks closing high/closing low have data of last 6 months.i divide it in 26 weeks but confuse to calculate closing high/low in b/w that i have to chck the data that wts the high/low figure or by adding all and then calculate avg...pls suggest wts the right procedure...asap

24 September 2010 I suppose you mean weekly high / low for 26 weeks.

If that is the case, then you will have 26 week's data.
Each week has 5 closing values (Mon to Fri).
Put them in 26 columns (each column has 5 closing values)
Take high and low of each week.
So you have 26 high values and 26 low values.

Hope this clarifies. What is the objective?

ajay arora (Querist)
24 September 2010 thanx sir actually i had to make the data for bse requirement to issue the warrant.


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
08 September 2026
Semi-Qualified Assitant

Subrahmanyam & Sivudu CA Firm

Hyderabad

CA Inter

View Details
Company
20 September 2026
Semi Qualified CA

Navin & Associates

Mumbai

CA Inter

View Details
Company
09 September 2026
Chartered Accountant

Aviv Global Private Limited

Ahmedabad

CA

View Details
Company
ARTICLESHIP 30 September 2026
CA Article Assistant

CA Suraj Garg & Associates

New Delhi

CA Final

View Details
Company
ARTICLESHIP 28 September 2026
Junior Accountant

J S P M & Associates LLP

Pune

B.Com

View Details
Company
26 September 2026
Chartered Accountant

pushpganga ventures

Pune

CA

View Details
Company
ARTICLESHIP 07 October 2026
Article assistant

S.K.Bajpai & Co.

Noida

B.Com

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details