Home
Services Offered
Payment Details
My Services
Contact Us
Market Heatmap
Charts
Charts (Premium)
Chart Watch
JCharts (EOD)
JCharts(EOD-COMM)
HCharts (EOD)
HCharts (EOD-COMM)
Forum
Stock Lists
Screener (EOD)
Screener (EOD-Comm)
Breadth Charts
Calculators
Education
Links
FAQs
Search
Advertise Here
Charts (Old)
Login Form





Lost Password?
No account yet? Register
  iCharts Discussions

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to calculate 20 DMA in excel sheet ????

 
Post new topic   Reply to topic    iCharts Discussions Forum Index -> Technical Analysis
View previous topic :: View next topic  
Author How to calculate 20 DMA in excel sheet ????
viraj5
White Belt
White Belt


Joined: 23 Jul 2010
Posts: 32

Post: #1   PostPosted: Thu Jul 25, 2013 11:13 pm    Post subject: How to calculate 20 DMA in excel sheet ???? Reply with quote

Hello !

Please help me to calculate 20 DMA in excel sheet. or Any formula to calculate 20 DMA
Back to top
View user's profile Send private message
ndpotade
Yellow Belt
Yellow Belt


Joined: 05 Feb 2010
Posts: 580

Post: #2   PostPosted: Sat Jul 27, 2013 8:10 am    Post subject: How to calculate EMA value Reply with quote

How to calculate EMA value
Regarding calculation of EMA... follow the following steps or search it on google.

1. Decide which EMA value, you want to calculate.. Suppose you want to calculate EMA 50

2. add 1 with 50, so it is 51. now devide 2 by 51 which 0.039216 ---- this is your multiplier value.

3. now deduct previous EMA value from Close price, multiple it with mulitiplier value

4. add previous ema value to answer of step 3, so you will get latest ema.


for eg. IF previous EMA is 6135 and Close Price is 5904, then your formula will be

= [(5904 -6135)*0.039216] + 6135

If you start with new EMA series.. Take Previous EMA as Close price as per Previous Period
Back to top
View user's profile Send private message
bharatpatel
White Belt
White Belt


Joined: 26 Oct 2011
Posts: 396

Post: #3   PostPosted: Sat Jul 27, 2013 8:37 am    Post subject: hi Reply with quote

Dear N D P ,

It will be helpful if you post calculated excel sheet itself.

Regards.
Back to top
View user's profile Send private message
biznet
White Belt
White Belt


Joined: 04 Feb 2013
Posts: 46

Post: #4   PostPosted: Sat Jul 27, 2013 11:06 am    Post subject: Re: How to calculate 20 DMA in excel sheet ???? Reply with quote

viraj5 wrote:
Hello !

Please help me to calculate 20 DMA in excel sheet. or Any formula to calculate 20 DMA


Dear viraj/ bharat,

I am posting a file for 20/50/100/200 Day MA and Pivot calculation in excel

Biznet



DMA & PIVOT EXCEL.xlsx
 Description:

Download
 Filename:  DMA & PIVOT EXCEL.xlsx
 Filesize:  88.21 KB
 Downloaded:  1001 Time(s)



Last edited by biznet on Sat Jul 27, 2013 4:33 pm; edited 1 time in total
Back to top
View user's profile Send private message
bharatpatel
White Belt
White Belt


Joined: 26 Oct 2011
Posts: 396

Post: #5   PostPosted: Sat Jul 27, 2013 12:07 pm    Post subject: Reply with quote

Dear Friend,

Thanks for quick response , as icharts.in known for.
Back to top
View user's profile Send private message
pipstocks
White Belt
White Belt


Joined: 02 Jan 2009
Posts: 29

Post: #6   PostPosted: Sat Jul 27, 2013 12:54 pm    Post subject: Reply with quote

hello biznet I think that excel sheet calculates 20-day MA.
But viraj asked for DMA = displaced moving average.
Kindly go through http: // t a - l i b . o r g for a nice Add-In which helps to calculate commonly used technical indicators in excel sheet.
For that you have to make some practice by downloading historical data in excel from nse site.
Back to top
View user's profile Send private message
shivanand
White Belt
White Belt


Joined: 05 Aug 2012
Posts: 3

Post: #7   PostPosted: Sat Jul 27, 2013 2:41 pm    Post subject: Reply with quote

Can pl you attach in xls format... Smile
Back to top
View user's profile Send private message
biznet
White Belt
White Belt


Joined: 04 Feb 2013
Posts: 46

Post: #8   PostPosted: Sat Jul 27, 2013 4:18 pm    Post subject: Reply with quote

shivanand wrote:
Can pl you attach in xls format... Smile


excel file to calculate simple moving average and pivot in xls

Biznet



Moving Average & Pivot.xls
 Description:

Download
 Filename:  Moving Average & Pivot.xls
 Filesize:  142.5 KB
 Downloaded:  641 Time(s)

Back to top
View user's profile Send private message
biznet
White Belt
White Belt


Joined: 04 Feb 2013
Posts: 46

Post: #9   PostPosted: Sat Jul 27, 2013 4:31 pm    Post subject: Reply with quote

pipstocks wrote:
hello biznet I think that excel sheet calculates 20-day MA.
But viraj asked for DMA = displaced moving average.
Kindly go through http: // t a - l i b . o r g for a nice Add-In which helps to calculate commonly used technical indicators in excel sheet.
For that you have to make some practice by downloading historical data in excel from nse site.


yes the excel sheet is for simple moving averages.
The link posted by you showing error can you please repost it

biznet
Back to top
View user's profile Send private message
pkholla
Black Belt
Black Belt


Joined: 04 Nov 2010
Posts: 2889

Post: #10   PostPosted: Sat Jul 27, 2013 6:45 pm    Post subject: Reply with quote

Viraj5: Why waste time, energy and bheja trying to calculate DMA when ICharts if there to do it for you?
In J Charts Premium see the 2 levels of symbols just above main chart. 3rd box on 2nd row is DMA (What you want)
Here you can specify (1) Arith ave or Exponent ave, (2) Period of average, (3) Period of displacement, (4) Displace to left or right
I have found that 8 period MA, 3 period displ, to left, works for me in intraday. You can change settings to find your optimum (eg dis to right is probably better for daily chart)
Jai Hind, Prakash Holla
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    iCharts Discussions Forum Index -> Technical Analysis All times are GMT + 5.5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group

@MEMBER OF PROJECT HONEY POT
Spam Harvester Protection Network
provided by Unspam