Home > Forum Home > Charting and Performing Technical Analysis > Can this tool capture the 'Average True Range' as a value within an Excel 2010 spreadsheet? Share

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


Forum TopicPost Reply Login

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

Rate this:
(3/5 from 1 vote)
ConfusedIf 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 on
 
Replies - Displaying 1 to 3 of 3Order Replies By: Most Recent | Chronological | Highest Rated
Fedup
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 on
ConfusedExcel 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 on
Surprised
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 on
 Displaying page 1 of 1 

Excel templates and solutions matched for Can this tool capture the 'Average True Range' as a value within an Excel 2010 spreadsheet?:

Solutions: Dependency Auditing Compare Files