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
-
Major League Fishing
3 days agoBass Pro Tour LIVE - Stage Three - Day 2
39.5K -
1:31:50
vivafrei
6 hours agoInterview with Norm Pattis - Attorney for Alex Jones, Jan. 6'ers! Life to Lawfare! Viva Frei Live
39.7K25 -
1:27:03
Steve-O's Wild Ride! Podcast
1 day agoDuncan Trussell Isn't Screwing Around When It Comes To A.I
16.7K5 -
2:42:11
Barstool Yak
7 hours agoThe Yak with Big Cat & Co. Presented by Rhoback | The Yak 5-3-24
30.2K4 -
43:15
TENET Media
4 hours agoShocking Images of UCLA Post-Protest | Dave Rubin & Isabel Brown
16.8K36 -
7:38
America Uncovered
8 hours agoThe Most Dramatic and Terrifying Expansion of US Government Surveillance?
16.9K12 -
1:20:09
Deprogrammed with Keri Smith
3 hours agoHow to Practice Public Speech - LIVE Deprogrammed with Keri Smith
15.3K3 -
59:33
Dr. Eric Berg
1 day agoThe Dr. Berg Show LIVE May 3, 2024
23.5K8 -
1:04:34
John Burk
4 hours agoMan or bear and John Ross returns!
27.8K10 -
1:02:12
Russell Brand
9 hours ago“You’re Dealing With A SCAM!” Nick Hudson On WHO Pandemic Treaty - Stay Free #358
185K357