Support Board
Date/Time: Sat, 08 Feb 2025 05:18:22 +0000
[User Discussion] - USER HELP / DISCUSSION ON HOW TO PASTE HISTORICAL DATA INTO A SPREAD SHEET.
View Count: 470
| [2020-06-23 08:55:01] |
| TraderTen - Posts: 80 |
|
A few years ago I constructed many spreadsheets to make buy/sell decisions, simply by copying Sierra Chart Historical Data: (O/H/L/C/Volume) in comma-delimited format. Now I am having trouble pasting the data into a 7-column spreadsheet, as my method is jamming everything into one column, instead of 7 (even though it is comma-delim). It is driving me crazy that I can no longer make it work. Any suggestions please? |
| [2020-06-23 13:41:40] |
| Sawtooth - Posts: 4173 |
|
Try this: In Sierra Chart, go to Edit >> Export Bar Data To Text File. In Excel, go to Data >> From Text, and navigate to your Sierra Chart \Data folder. Select the saved txt file, change the Delimiter to Comma. |
To post a message in this thread, you need to log in with your Sierra Chart account: