Can this tool capture the 'Average True Range' as a value within an Excel 2010 spreadsheet?

Excel Help for Can This Tool Capture The 'average True Range' As A Value Within An Excel 2010 Spreadsheet? in Charting and Performing Technical Analysis

Can This Tool Capture The 'average True Range' As A Value Within An Excel 2010 Spreadsheet?

Rate this: (3/5 from 1 vote)

	If a stock symbol (like IBM) is entered then does this tool return the value of the 'average true range' and paste the value into a cell? Thus, within the spreadsheet, the value of the ATR can be multiplied by other value.
	Posted by Lou on 04 Feb 2011

Replies - Displaying 1 to 3 of 3

Order Replies By: Most recent | Chronological | Highest Rated

	Technical Analysis indicators product Rate this: (3/5 from 1 vote) The product which I think that you are referring to in our directory is supplied by a third party.  You can download a trial version of this solution from the listing here to test the ability to calculate the average true range.
	Excel Business Forums Administrator
	Posted by Excel Helper on 05 Feb 2011

Clarify the ability to use your tool to calculate the 'average true rangs'. Rate this: (3/5 from 1 vote) Excel 2010 provides the ability to download the high, low, and close price for a stock symbol on a daily basis. I can not find a function within Excel 2010 that will calculate the 'average true range'. As I understood your products, you have the ability to calculate the 'average true range' in your Technical Analysis tool. Is this a correct statement?

Posted by Lou on 05 Feb 2011

	Download market data fields Rate this: (3/5 from 1 vote) I assume that the tool referred to is the market data download from Yahoo Finance. This tool only downloads historical data that is available. Having said that, the average true range could then be calculated separately from the downloaded data.
	Excel Business Forums Administrator
	Posted by Excel Helper on 04 Feb 2011

Displaying page 1 of 1