No Arbitrage
-
Hacking Debt schedule with Lambda in Excel TOP NEW
How to use one single formula to hack Debt schedule with CashSweep Create a lambda function as below. Syntax DebtSchedule( [OpenBalance] = Debt Open Balance, [CashBalance] = Cash Open Balance, [CFArray] = Cashflow Array, [MandatoryAmort] = Mandatory Amortisation, [CashSweep] = % of available cash after mandatory amortisation allocate... Read More
-
Free Power Bi template - a showcase of dashboard development TOP NEW
Power BI (DAX) Implementation Goal This post is share my experience of developing power bi dashboard. I will find another time to discuss the internal working, data model and other bits around power bi development with you. In this post, I will just share the file with you. You can do whatever you want with this file. I taught myself the skil... Read More
-
Welcome to No Arbitrage! TOP NEW
Welcome Hello! I am thrilled that you are here! This is my first and latest blog where I will share my thoughts on financial market and financial fundamental knowledge and occassionally practical example files (models and slides). You can find more about me in the ABOUT page. To add new posts, simply add a file in the _posts directory that fol... Read More
-
How to Practically Diversify Your Investment for Non-financial Analysts (Free Calculator Workbook) TOP NEW
Why Should You Read This? If you’ve ever wondered whether your investment portfolio is working as hard as you are, this post is for you. By the end, you’ll know how to optimize your portfolio like a pro. Plus, you’ll get a nifty spreadsheet that does the heavy lifting for you. Simply plug in your own investment data, and voilà—instant insights ... Read More
-
Comparing Default Solvers in Excel TOP NEW
Simplex Method Used for linear optimization problems Fastest and most reliable for linear models Guaranteed to find the global optimum for linear problems Only works when the Assume Linear Model box is checked1 GRG (Generalized Reduced Gradient) Nonlinear Method Used for nonlinear optimization problems Can handle smooth, cont... Read More
-
Unlocking cross sales opportunities with pre-made Basket Analysis template TOP NEW
Images: Jacek Dylag (unsplash.com) Goal This post provides sales managers ability to run simple Basket Analysis insights on their own without having to request support from Data Analyst. Our goal is to offer practical, easy-to-implement strategies that help you drive performance and achieve measurable results. Key Idea Basket analysis using... Read More