lambda

Hi all, I am trying to figure out how to calculate the Exponential moving average of a stock. The sheet shows the steps involved. I tried using the scan function but I couldn't figure it out. I hope someone smarter than me can help with the formula or point me in the right direction. I know I...

Hi all! Hopeful that you can help me speed up some of my formulas. I'm building a chain of LAMBDA functions and the most recent one is running really slowly and I can't figure out why because if I run the exact same formula just filling in the variables, it runs instantly. Details below: Runs...

Good evening, hope someone can help. I am trying to create lambda functions that work in various tables in a workbook. The worksheet calculates "Year To Date" (a running total) and "Previous Year to Date" (YTD from the previous row) The functions are kind of long (especially the Previous...

Hi all, I have created a partial formula that calculates the amount of EMI going towards interest and principal. I am, however, looking to calculate the outstanding balance after each period as well. The formula for outstanding balance for each period would be - Example Period 1 ost bal =...

After the reconciliation was complete, The range gives out as values in both worksheets, values only in first worksheet and values only in second worksheet. (see last portion) But my area of interest is values in both worksheets. See below. ABCDEF1dec2021CASHBOOKdec2021NBK502BOTH2AmountCount...

Watching this video, I figured out how to set up a live connection to a Google Workbook through Power Query. Basically, you copy the URL for sharing, and then set up a URL with an ID gleaned from that URL. The ID is between the /d/ and the last / of the URL provided. The video is 2 years old...

As we know, the new excel release is super awesome with its array range and lambda function (along with other functions to work on array/lambda). One problem that still makes me uncomfortable is making an array with reference. We can make normal array as ={1,2,3;4,5,6}. But apparently we cannot...

Dear Members, I need assistance in creating a CAGR array from periodic returns vector. I wish to create a Dynamic Array holding only calculated CAGR (compound annual growth rate) values derived from periodical return on investment vector. This is easily performed in standard Excel but...

A SPLIT function (to break delimited text into separate cells) would be very useful. It is easy to do in VBA, which has a built in function to do it, but I thought I'd try to do it with lambdas. I found it extremely difficult (not least because it is so hard to check recursive lambdas if you...

Lambdas are held in individual workbooks. How can we copy them between workbooks, and keep them up to date if they change? Based on the current Excel beta version 2111 * copying any sheet (even blank) from workbook A containing lambdas to another workbook B, will also copy those lambdas to B...

This LAMBDA provides a recursive loop to extract subarrays of given set of dimensions, or warns the user if their provided dimension(s) are bigger than their target array; I am returning the list of the subarrays using ARRAYTOTEXT, but this could be substituted with another function to suit the...

Hello everyone! :) So I have been messing around lately with some data that has delimiters and I am trying (as an alternative to powerquery) to extract some strings that are in the raw data cells using the LAMBDA function. Could anyone help me out to see how I could use lambda for this? So...

Would be great to have Dynamic Waterfall charts with LAMBDA, where the items are dynamic. Any ideas about this from somebody?