Generating cashflows based on scripts

Hello everyone,
Is there a way to generate cashflow based on scripts?
i.e. I have two variables “A” & “B” (array of x data points each). Can simply write
C = A + B and generate the sum array etc?

Welcome to the community Ayaz!

If you have the A & B arrays listed out as columns in a sheet, using SSDC Column-Formula type you can quickly populate a third-column having sum-array values.

That is,

  • For two existing columns A & B with data series.

  • You can define a Column C as column-formula type with formula expression A+B

  • This will yield a sum-series as follows

Hope this helps.