Below you will find pages that utilize the taxonomy term “Excel”
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 data and there is a native function called GOOGLEFINANCE. All I needed to do was enter =GOOGLEFINANCE(AAPL) and I would automatically get the current price of Apple, Inc.
I downloaded and started to fool around with another genetic algorithm addin for Excel. This one is called xlbit and is created by Xlpert. What I like about it is that it has a better interface than Gentik Solver, but its not free. It allows you do max and min for target cells, add constraints (a big plus), and lets you choose between three genetic algorithms: Elitism, Roulette, and Tournament. It even creates a new worksheet with results and graph for your average and overall fitness.
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 fucked up 2009 trading year, I had to revamp my entire arsenal of macros and screens for a brighter and more profitable future, I hope. Anyway, below is one of the many macros I use in TraderXL Pro for generating an automatic stop loss using and Average True Range (ATR) function.
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 my Forex stops and limit BUY/SELL points. I also use it for work creating complex budget risk Excel spreadsheets but you wouldn’t care about that.
The benefit of the using the Monte Carlo simulation is that you can update the model with new information and get a fresh perspective on where the â€œkeyâ€ price areas in the market and how you can profit from them.
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 years ago.
Financial Critical Mass is defined as the capital you need in your retirement accounts that will continue to grow after you retire and start withdrawing from it. In other words, your living off the interest of your investments.
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 see another leg down in the markets but what do I know?
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 enough it was at the 1335 level which is right around the 1337 support level I modeled using my Monte Carlo sim.
Could the market go lower from here? It sure could and I expect it to kiss the 1291 level,just like it nearly touched the 1383 level earlier this week.
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 confirmed my suspcisions that the the 1310 to 1340 level was indeed an interim support area and the sim calculated it as 1337. The simulation did indicate a negative bias for the S&P500 for the short term so I'm still concerned that we might see a breech of that level before we turn higher.
Itâ€™s no secret that I use TraderXL Pro to download the majority of my Stock, Future, and Forex data that I use for RapidMiner modeling. I use the BulkquotesXL module because itâ€™s able to download daily and weekly data from Yahoo and daily price data from the PiFin data source. Usually it downloads the data into separate tabs in your spreadsheet, which is nice but a pain to manipulate if you want to create a summary sheet to load into RapidMiner.
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 easy to do if you use YALE, but what if you don’t have the time to learn YALE? Is there another way to do it, perhaps using Excel?
If you’ve read my Build Your Blog Traffic Using Excel & Data Mining post, then you should be able to figure out what your busiest day is, what your most popular category is, and your optimal posts per day by now. If you haven’t read it, I highly suggest that you do because what you learn here today builds on that information.
In this post I want to talk about how to maximize your Adsense earnings and at the same time minimize your marketing costs in the event you use Adwords or a similar web advertising vehicle using 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 should’ve written was that you can use an Excel Pivot Table report, the chart is optional. So why should you build an Excel Pivot Table?
The inspiration for my S&P500 Volatility Timing model came from rereading portions of Mandelbrot’s book, The (Mis)Behavior of Markets, and trolling around the Internet for Nassim Taleb’s research work on risk. I think both guys push the envelope on truly understanding unseen risk and those pesky financial asteroids. Since my model is currently being developed, I thought it would be worth my while to truly learn and understand how historical volatility (HV) is calculated.
Today I wanted to share with you a part of the algorithmic back end to my ETF Trend System. Note, I said “part”, I’m not giving away all my secrets. It’s written completely in Excel, incredibly simple, and is a macro that you can import. The system works by using something called linear regression slope.
The easiest way to understand what linear regression slope is, is to think back to your basic statistics class.