Login Page - Create Account

Support Board


Date/Time: Sat, 20 Apr 2024 14:58:11 +0000



Post From: Painting Candle (OHLC) with Spreadsheet Study

[2020-09-25 06:26:18]
User753843 - Posts: 8
Thanks for the quick response. To clarify, I have a subgraph in a spreadsheet that I'd like to display the OHLC instead of just a point at close. I understand I will need 4 formulas, in columns K,L,M,N for OHLC.

The formulas show the latest reading so I am a bit confused on how to capture the Open, High, and Low, as the numbers are always updating (Close).

Would it be possible to point me to an example of a spreadsheet study with a candle output?