IT Log

Record various IT issues and difficulties.

How to write the condition in Tongdaxin formulas to execute DRAWKLINE(H, O, L, C) when the code does not start with 880

To address the problem of executing DRAWKLINE(H, O, L, C) in Tongdaxin formulas only when the code does not start with 880, follow these steps:

  1. Access Current Code: Use the CODE() function to retrieve the current stock code.

  2. Extract Prefix: Extract the first three characters of the code using LEFT(CODE(), 3).

  3. Comparison: Compare the extracted prefix against “880” using IF(LEFT(CODE(), 3) != “880”, ...). Note that string comparison in Tongdaxin may require specific handling, potentially using functions like STRCMP.

  4. Conditional Execution: Wrap DRAWKLINE(H, O, L, C) within the condition to execute it only when the code does not start with 880.

  5. Integrate into Study Function: Use STUDY(..., ...), passing the condition as a parameter to ensure execution only under the desired circumstances.

Here’s how the formula would look:

This ensures DRAWKLINE executes when the code does not start with “880”.

, , , ,