Tutorial 197 | Storing bar and analysis technique data in Excel

A Gold Pass member asked how to create an Excel spreadsheet with n rows and m columns, the n rows representing each of the successive bars on an intraday chart, and for each of the n rows a column for each of the m different indicator values that appear on that bar. In tutorial 197 the following data is stored for each successive bar: a bar counter, date , time, close, open, high, low, the value of the calculated CCI, the values of the calculated RSI and the average of the closing price. The values for the most recent bar are updated in real time.

When the program is restarted it reopens and rewrites the data.

The tutorial also touched upon the use of the Microsoft Excel "Conditional Formatting" feature.

Other Excel integration tutorials include:

Tutorial 150 | Sharing data between two charts using Microsoft Excel
Tutorial 113 | Using data from an Excel sheet to update an EasyLanguage program
Tutorial 112 | Transfer price data from a Price Series Provider applied to a chart to an Excel spreadsheet
Tutorial 96 | Using the Workbook component to share information with Excel