First Post

I'm gonna try to make this as interesting as possible but its mostly just cool information. Some will be very technical.

This blog will cover my process of developing software for stocks analysis (technical analysis). I'll be using vba in excel because of the great built in functions.

If you want to get an idea of how powerful this software can be, imagine a tool that can make money simply by being turned on... ya that's pretty much the idea.

My goal is this: a tool which can be set up to pick stocks you are interested in, maintain a portfolio based on what you pick, and a watchlist partly on what it picks, and has the ability to chart and suggest entry and exit points. It then must also be able to provide a report for how well those entry and exit points worked.

So far, I have some of the scripting done to pull data for free from the yahoo stocks info. This is the first step and I'll have to clean it up to have it to really work well.

If you are new to vba, all you have to do in excel is get to the vba environment and press F1 after you select something that you aren't sure what it means to pull up help. I probably won't do too much explaining of the code for now. It's easier just to say what it does and what I want to make it do.

I'll upload the code and a screenshot tomorrow when I get a chance