-
Recent Posts
Recent Comments
Data Mining
Economy
Quant Finance
R
Trading
Category Archives: Excel
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 … Continue reading
Posted in Excel, Python
12 Comments
Genetik Solver appears to be no more – ITS BACK!
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 … Continue reading
Posted in Excel, Genetic Algorithms
4 Comments
Calling ATR and A Stop Loss Macro In TraderXL Pro
Yeah, I still use TraderXL Pro for a bunch of my data manipulation and technical analysis stuff. I use it to download data and run macros through it, macros that I design and then use in my trading screen. After my … Continue reading
50% Off On TraderXL Till December 31, 2009
If you're itching to buy TraderXL and have put it off, now's the time to do it. They are offering a 50% coupon code for TraderXL and other codes for individual packages. TraderXL is the only XLS addon package that I … Continue reading
Posted in ATS, Excel, Links, Products
Tagged Data Management, Products, Technical Analysis, TraderXL
Leave a comment
Exciting Times
We are living in exciting times alright! I’m happy that the bailout plan was voted down but my guess is they’ll try to get it passed again. I’m not happy that 1.2 trillion dollars of market cap vanished yesterday but … Continue reading
Market Price Targets
With everyone scrambling to see how low the Dow, Nasdaq, and S&P500 will go, I’ve decided to throw my Monte Carlo simulated price targets into the mix. They’ve been pretty accurate so far and I use this system to find … Continue reading
Achieving Financial Critical Mass (FCM)
I left work late on Friday because I got distracted running Monte Carlo simulations on our 401k accounts. I’m on a quest to refine my retirement plan of achieving Financial Critical Mass, something I heard about from Bob Brinker many … Continue reading
S&P500 Price Targets
I haven’t posted price targets in a while but here’s a quick one for the S&P500 based on today’s close of 1360. Upside Targets: 1446, 1544 Downside Targets: 1348, 1250, 1152 If you ask me, I think we’re going to … Continue reading
S&P500: Catching Falling Knives
I make it a habit of “selectively” catching falling knives and yesterday was definitely such a day. I emailed my members yesterday around lunch time yesterday to tell them that my Market Timing model issued a strong BUY signal. Interestingly … Continue reading
Posted in 401K, Excel, Members, Neural Nets, Trends
Tagged Economy, Excel, Members, S&P500
Leave a comment
How High or Low Will the S&P500 Go?
I mentioned to my members in this past week’s Market Timing Report that I would run a Monte Carlo simulation on the S&P500 to see what are the potential upside and downside targets for the S&P500. The Monte Carlo sim … Continue reading
Build an ETF Trend System in Excel – Part 2
The spreadsheet I’m about to share with you was the basic backend ETF trend system I developed for live trading. I used the RTQuotesXL and AnalyzerXL modules from TraderXL Pro to download the data in real time and create … Continue reading
Why I Use RiskAMP
A few years ago I got fascinated with Monte Carlo simulations after this application appeared in my 401k plan. At the time they had this “what if” calculator where you enter your age and then the amount you plan to … Continue reading