shlogg · Early preview
Judy @esproc_spl

Extracting Stock Transaction Data With SPL Scripting

Get transaction info for Merchants Bank (600036) when closing price > 25 yuan in 2017 using SPL script.

Below is part of the Stock table:

Get the transaction information where the closing price of Merchants Bank (600036) exceeds 25 yuan in the year 2017.
SPL script:

A2: Find the first record where the closing price exceeds 25 yuan from the beginning.
Execution result:

SPL open source address
Download