MS Excel-"CUSTOMIZED DYNAMIC GRAPHS OF RIL"

Please refer excel file attached below-

Here is something really interesting for excel lovers and finance enthusiasts.Continuing from previous data of RIL (as in previous article,but here it is day wise),I had created this model for analysis of day wise average return and closing price.You have to fill only 3 credentials as per your requirement for analysis as mentioned in image below. For Example,you want to do analysis on 5 day data , simply type 1 and 5 in first and second column respectively.In case ,you want 10 days average return inspite of 1 day average return,type 10 in first column.

Now suppose you want closing price ,adj closing price,return and average return of any respective day.Let say you want these credentials of last 5th day,i.e, 22nd of june,Simply type 5 in third column and press Enter.

So this is how it works.For any query ,revert us in forum

Download Analysis Model-

RIL Rev Analysis(Graphs)

.xlsx

Download XLSX • 794KB

Downlaod Raw Data(Source-Yahoo Finance)

RELIANCE(2)

.xlsx

Download XLSX • 380KB