Login Page - Create Account

Support Board


Date/Time: Mon, 29 Apr 2024 14:32:43 +0000



Post From: Creating OHLC chart of a custom index

[2013-07-20 23:21:22]
Sawtooth - Posts: 3983
You can do this with the Spreadsheet Study study. The same-named spreadsheet study is added to each chart by entering/selecting the same name in the Spreadsheet Name field. On the main chart, chart #1 in the attached example, the spreadsheet study is checked to Display as Main Price Graph. You can hide the spreadsheet study on the other charts.

Put the attached files in your Sierra Chart \Data folder. Then go to File >> Open Chartbook >> EUR Index.cht

If you want bars instead of candlesticks, change the Draw Styles of SG7 and SG11 to Left Hash, and the Draw Styles of SG8 and SG12 to Right Hash.

If you need to invert the price of a symbol, simply add the 1 Divided by Price study to the specific chart. The inverted values will automatically populate and be used by the spreadsheet. Chart #3 has this study added as an example.





Date Time Of Last Edit: 2013-07-20 23:29:14
attachmentEUR Index.cht - Attached On 2013-07-20 23:18:47 UTC - Size: 93.46 KB - 570 views
attachmentEUR index.scwbf - Attached On 2013-07-20 23:19:14 UTC - Size: 246.26 KB - 538 views