We will be using the CHOOSE Function for today's tutorial to determine each company we had Dollar-cost Averaging in. For the examples, we will be taking Vanguard 500 Index Fund ETF, SPDR Gold Shares, Tesla Inc, Apple Inc, Microsoft Corp and Facebook prices.
We will also show you how to convert your CHOOSE function into an API at the end of the video.
Download: AlchemyJ FREE Community Edition: https://www.alchemyj.io/download
Excel Template: https://www.alchemyj.io/aj-excel-template
How to setup AlchemyJ: https://www.youtube.com/watch?v=eTyYTf1sw9k&feature=youtu.be&ab_channel=AlchemyJ
How AlchemyJ works: https://www.youtube.com/watch?v=bAQHo8I1xuQ&ab_channel=AlchemyJ
Let's connect: LinkedIn: https://www.linkedin.com/company/alchemyj
We will be using the CHOOSE Function for today's tutorial to determine each company we had Dollar-cost Averaging in. For the examples, we will be taking Vanguard 500 Index Fund ETF, SPDR Gold Shares, Tesla Inc, Apple Inc, Microsoft Corp and Facebook prices. Without further ado, let us get started.
How to use CHOOSE Function
How to use the CHOOSE Function? For our first example, let us find the company of our choice by simply choosing 1 to 6. Select Cell C15, type in equal, Choose, open parentheses. Select B15. This cell will be representing our Index Number. Next, we will be selecting our values. Move your cursor and select cells C6 to C11 and hit return. You will get value. This is because we have not added our index number. Select B15 and type in 2, and hit return. You will get SPDR Gold Shares.
Now let us use the choose function and find the total cost of the company. Select Cell F15, type in equal, Sum, open parentheses. Type in choose and open parentheses again. Next, we will select cell E15 as the cell for our Index Number. Type in Comma. Move your cursor and select Cell D6 to Cell O6. Repeat the steps from row 7 to row 11. Close parentheses twice and hit return. As usual, you will get Value. Let us type in 3 in Cell E15. You will get $3761.12. The total Sum for Tesla Inc.
Lastly, we will look at the average cost per month for Apple Inc for our last example. Select Cell I15. Type in equal, Average, open parentheses. Type in choose, open parentheses and repeat the steps from our previous example from row 6 to row 13. Close parentheses twice and hit return. To find the average cost per month for Apple Inc. Select cell H15 and type in 4, and hit return. You will get $97.28.
There you have it, the Choose function for Excel. If you have any excel formula you want us to teach, let us know in the comment section below. Don't forget to subscribe, hit the bell button and turn on the notification to have more free excel function tutorials. But, before you go, we have a bonus clip for you. I will be turning this Excel spreadsheet into an API. Stay tuned to see how the magic works.
Convert CHOOSE function into Application Programming Interface (API)
I will be using AlchemyJ Studio Excel Add-in to turn this Choose Function Excel into an API. To do this, I will need AlchemyJ Excel installed and with a pre-set of rules. I will select the AlchemyJ ribbon, select Generate API and click on Generate API. The file is now converting. Okay, your API is ready.
I will now launch this open API that Alchemy Jay generates. I will expand this tab, and select try it out. I will input 2 and select Execute. We will get $167.37. The average cost per month for SPDR Gold Shares.
AlchemyJ Studio Excel Add-in turns your Excel business model into API. This way, you can integrate your Excel model into other applications. You can download AlchemyJ Studio Excel Add-in for free at alchemyj.io. And once again, thank you for watching. So which Excel function you wish to be converted into an API? Let us know in the comment section below. Lastly, don't forget to subscribe, hit the bell button and turn on the notification. See you soon.