Experimenting with Google Sheets

Posted on Do 27 Oktober 2016 in misc • Tagged with AAPL, Charting, Excel, Google Sheets • 1 min read

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 functionality of Google Sheets. I wanted to import some stock …

Continue reading

Learning Python helps me with Excel

Posted on Do 06 Januar 2011 in misc • Tagged with Python, Excel • 1 min read

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" statement formula if a hammer candlestick formation has …

Continue reading

Genetik Solver appears to be no more - ITS BACK!

Posted on Mi 20 Oktober 2010 in misc • Tagged with Excel • 1 min read


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 its remained …

Continue reading

Understanding Fuzzy Trend Following in Excel

Posted on Sa 07 Juli 2007 in misc • Tagged with Excel • 2 min read

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 people call Fuzzy trend analysis and its quite …

Continue reading

Backtesting the S&P500 Volatility Timing Model

Posted on Di 19 Juni 2007 in Stocks • Tagged with Excel • 1 min read

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 returned a nice profit, +33%. I can't …

Continue reading