Experimenting with Google Sheets

Google Sheets, and Google Documents for that matter, are turning into some really robust tools. If I were to start a company, I would use those tools for writing documents and building spreadsheets. I was experimenting with the data import...

comments

Learning Python helps me with Excel

I use Excel extensively at work and I've always wished to write intricate macros but never understood the complexities of Visual Basic. After spending a few weeks learning Python, I've managed to build an Excel formula in VB that creates an "IF"...

comments

Genetik Solver appears to be no more - ITS BACK!

Wow, Well at least its presence on the Internet. It appears to be gone and I can't locate the .XLA file anywhere to save my life. I wrote about this neat little Excel add-in a long time ago in my Genetic Algorithm Excel Addin post and since then...

comments

Understanding Fuzzy Trend Following in Excel

Building an asset trend following system is quite easy to do if you've read my tutorials. You gather your data, assign trend values (UP, DOWN), and then run it through a classification algorithm like YALE's IBK operator. Doing this is what some...

comments

Backtesting the S&P500 Volatility Timing Model

I'm moving my S&P500 Volatility Timing Model officially into Beta testing. I've been backtesting my model for a bit now and plan to compile a list of aggregate rates of return, draw downs, etc. Looking back through 2005, the timing model has...

comments

Neural Nets In Excel

For those of you who don't like using YALE, now called RapidMiner, I offer you neural nets in Excel. A few years ago I came across a slow, but really cool neural net application written in Excel by a PhD student, Angshuman Saha. I've used this...

comments

Build Your Blog Traffic Using Excel and Data Mining

This past Saturday, I posted about using data mining to look for patterns in your blog traffic. I wrote that you can use something called an Excel Pivot Chart report to get a better feel for how your readers are interacting with your site. What I...

comments