Maybe the most friendly programming to Excel data analyst

1Intuitive Code in Grid, Convenient Debugging

Say goodbye to the annoying print debugging method.

2Powerful data computation capability

Calculate the longest consecutive rising days for each stock
A
1=T("stock.xlsx")
2=A1.sort(DT)
3=A2.group(CODE;~.group@i(CL< CL[-1]).max(~.len()):max_increase_days)

Just 3 lines!

Find the periods of stock price increases lasting for more than 5 consecutive days.
A
1=T("stock.xlsx")
2=A1.sort(CODE,DT)
3=A2.group@i(CODE!=CODE[-1]||CL< CL[-1])
4=A3.select(~.len()>=5)
5=A4.conj()

Getting Excel puzzles done

Built-in cursor supports big data

Cursor technology effortlessly handles big data that exceeds memory limits; simply adding options enables parallel computing to boost performance.

Calculate the longest consecutive rising days for each stock
A
1StockRecords.txt
2=file(A1).cursor@t().sortx(CODE,DT)
3=A2.group(CODE;~.group@i(CL< CL[-1]).max(~.len()):max_increase_days)
Find the periods of stock price increases lasting for more than 5 consecutive days.
A
1StockRecords.txt
2=file(A1).cursor@t().sortx(CODE,DT)
3=A2.group(CODE).conj(~.group@i(CL< CL[-1]))
4=A3.select(~.len()>=5).conj()

3Highly interactive, WYSWYG interface.

Find the periods of stock price increases lasting for more than 5 consecutive days.

Additionally, there is XLL to enhance Excel

To find periods of stock price increases for more than 5 consecutive days directly within Excel.
=spl("=E(?1).sort(CODE,DT).group@i(CODE!=CODE[-1]||CL< CL[-1]).select(~.len()>=5).conj()",A1:D253)
Read the e-book "SPL Programming"
Watch the video "SPL video course"
Download esProc Desktop
Communityc.scudata.com