martinpace.com

In this screencast I talk about stock market indices and methods by which they are calculated on a daily basis in order to display index changes in those fancy stock tickers you see all around the world on television, the web, and Wall Street itself.
Download the Market Indices Excel 2007 document.
How to Calculate Stock Market […]

I’ve finally settled on a hosting solution for my screencast videos. Previously, I had been storing the FLV videos on my own website, but several of my viewers reported problems streaming them. Sometimes they would cut off and fail to keep streaming or they would not load properly from the get-go.
I’ve decided to host all […]

Sometimes people can have a pretty tough time finding a thorough guideline as to how they can achieve passing data between Windows Forms (namely from a parent form to a child form). Since it’s far simpler than it would seem at first glance, I figured I’d walk through it real quick.
I’ve setup a Windows Forms […]

I recently helped someone who asked how to implement a working ProgressBar control and update it based on the progress of a WebBrowser control that is navigating to a URL.
Often I encounter things like this which are very easy to do, yet rarely appear on the web, be it in articles, message boards, or email […]

My apologies for not having published many screencasts this summer. I’ve been rather busy with work and some programming projects on the side.
Surprisingly enough, I’ve had several people contacting me with feedback - to be quite honest, I wasn’t aware anyone was even viewing this blog other than myself. I’m happy to know that at […]

Learn how to calculate a proper Geometric Mean of stock returns in which negative rates of return can be included. I cover another of the many Excel nuances that Finance and Statistics personnel are presented with. I cover the Geometric Mean formulae, appropriate adjustments, and a way in which you can maniuplate Excel’s GEOMEAN function […]

Learn how to setup a simple yet useful loan amortization schedule. While I cover an automobile loan example in this screencast, you can apply the same practices to mortgages and other loans. It’s simple, it’s intuitive, and it provides you with a lot of useful information. Enjoy!
Download the Loan Amortization Schedule Excel 2007 document.

I cover one of Excel’s many nuances: the incorrect Net Present Value function, courtesy of Microsoft developers. The NPV function in Excel has been incorrect ever since Excel could first calculate Net Present Value. As my example I use a simple corporate project with an initial cash outlay, three cash inflows, and a cost of […]

Welcome aboard viewers. I’m still tweaking things here and there and I’m trying to decide where I should host my screencasts and in what format(s) they should be available. Then I will begin recording them and uploading them as time goes on. At the moment, Veoh is looking rather appealing. I may go with Revver […]