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

Find Excel Solutions


Search Forums:
Recent Activity:
Can't Get It To Give Me The Report I Want
Importing Data From Pdf Files
Need Help With Formulas And Fixing This Spreadsheet
Wanting To Calculate All Hours Worked On A Project With Timesheets
Simple Formulae For Creating Complex Interactive Dashboards In Excel
What Is Microsoft Project Gantt Chart Used For?




Follow Business Spreadsheets On:
 
Forum TopicReply 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
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
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
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
 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: Loan Analysis Dependency Auditing Compare Files

 
Find Excel templates
and add-ins in the
Excel Business Solutions Directory
   
  © 2014 Business Spreadsheets. All Rights Reserved. Legal |