Support Board
Date/Time: Wed, 05 Mar 2025 19:17:24 +0000
Export ATR data to EXCEL
View Count: 856
| [2022-01-21 10:54:32] |
| User194713 - Posts: 27 |
|
I wondered if you could help with a task. I need to export price and average true range data (so that I can see individual ATR readings per price bar). Are you able to point me in the right direction please? Thanks in advance
|
| [2022-01-21 13:08:25] |
| 1+1=10 - Posts: 270 |
|
You can use the menu command. Edit >> Export Bar and Study Data to Text File When SC wants to save the file to your computer it will automatically fill in a file name. You have to change the end from .txt to .csv as Excel understands the latter file format but not the former. Alternatively, you can keep it as a .txt, open the file in Notepad, select the whole page, copy the selection, paste into an Excel cell and use split data to column, which will ask for a delimiter. Deselect “spaces” and select “commas”. |
| [2022-01-21 13:20:23] |
| Marmany - Posts: 308 |
|
Alternative route is to use Spreadsheet Study from which you can copy data and paste into Excel.
|
| [2022-01-22 11:44:52] |
| User194713 - Posts: 27 |
|
Thanks for the help, that works great. Just one other question, is it possible to get day of the week (as well as date) when using "export bar and study data to text file". The current export only gives dates.
|
| [2022-01-22 12:11:13] |
| 1+1=10 - Posts: 270 |
|
In Excel you can change the format of the SC datetime column to “Long Date” and Excel will include the day of week.
|
To post a message in this thread, you need to log in with your Sierra Chart account: