Financial Trading Software?
finance-geek asks: "What software do you use for trade evaluation? Are there any good free programs out there? I am a former programmer now working at an investment fund, and I am shocked at the limited number of applications for evaluating and back-testing trading models. We currently use Wealth Lab , but since they were recently purchased by Fidelity, we are less certain about the future of their customer service. I checked out SourceForge.net but only a few programs looked interesting, and it will take me a while to evaluate them. Any suggestions?"
Although it doesn't let you input your own data, I have found ETF Timing's (www.etftiming.com) approach to trading logical and accurate. They provide market timing on ETFs (sorta like mutual funds, but traded like a stock), and have been quite accurate during the length of my subscription (about 6 months).
It's not free, and I'm not generally one to plug a specific site or product, but it is on-topic.
The most likely reason for a lack of free software for this application is it's not common for someone to have experience programming and this sort of thing.
You are in this unique position, so I would recommend you start such a project yourself.
- Preferences: Solaris 10 (servers), Ubuntu (desktops), Solaris 11 (personal servers) -
Simply subscribe to an online service through your brokerage company. They generally offer a wealth of information.
This is a great area where an open source app would be found. You could get the bigger companies like ML,Vanguard,Fidelity, etc to fund an app that they could all share and return. But realistically, will they .. No. I work for a company that does some financial software consulting. These people guard thier data very closely, because that's what matters to the managers. Having somehting in an open format lets you move to another app and loses that subscription fee they all covet. This is going to end up being an app that someone who works for a company like mine does on the side(and probably breaks thier contract in the process). You would think an app running on GTK/Qt with a PostgreSQL backend could do all of this. But I still haven't seen anyone even interested in it.
Based on my experience, the challenge is not the software but getting access to updated, correct and historical data. Mechanical Investing is a disipline that seeks to make investment decisions based on objective rules rather than subjective measures (typically "chart reading"), and attempt to measure the success of a strategy with extensive backtesting using historical data. Currently, the most common data sources are ValueLine reports, Stock Investor PRO (from aaii.com) or IBD (investor.com). Getting access to historical data, keeping the data clean and current and "normalize" it for any changes the providers do over time (and they DO change their formats every few years) is the big challenge, not making the software that uses that data to simulate strategies.
And if you want intra-day data, the data problems become even bigger. I guess quite a few of the Technical Analysis services have historical data for testing TA models, but from what I have found there are few cheap and good sources for fundamental company data which also offer historical data.
The real problem is getting a reliable (i.e. non screen-scraped from Yahoo and preferebly scrubbed for accuracy) set of data and storing it.
And, even if they'd *like* to, exchange rules *forbid* vendors from giving away real-time (i.e. non delayed-by-20-minutes) feeds.
I think, for the most part, if you don't have a lot of money, sophisticated tools are a waste of time, because you'd get better results putting them into mutual funds, bonds, ETFs, and savings accounts. If you've got a lot of money, the cost for some good tools (and a data vendor who properly scrubs the data) is money well spent.
Gentoo Sucks
I hope you realize that as soon as the masses get a program that allows them to successfully game the system, the FTC will immediately outlaw day trading and/or computerized trades. They only reason they allow it right now is the fact that most people lose money.
Food for thought.
I'm glad I saw this thread.
First, check out GeniusTrader, which is a very usable tool for backtesting strategies.
A friend of mine and I are writing software for backtesting options trading strategies. It will also be GPLed and some of the architecture is based on the way GeniusTrader did things. GeniusTrader is written in Perl and optsys is being written in C++.
optsys, or what's been done of it (it's in maaaaaaaajor pre-alpha state right now, most features aren't even working yet) is available here, but since I'm running the server on my home PC, it's only up about 14-18 hours a day. GeniusTrader, however, is immediately usable and they have quite a developer/user community now.
I claim first use of "Error No. 0B" - or "No. 0B error." It'll be the new ID 10T!
Based on friend's experience in this are, I think so much heavy processing goes on in Excel, and is of such a general nature, that specialized tools don't get made.
Spencer Ogden
TA-Lib: Technical Analysis Library at http://ta-lib.org/
Windows and Linux technical analysis open-source software library allowing to maintain and process financial data. Provides RSI, MACD, Stochastic, moving average... plus SQL, ASCII, Yahoo! stock market data access. Works in C/C++, Perl, .NET. Source code included.
Another: http://eiffel-mas.sourceforge.net/
and one more library: http://quantlib.org/
You might want to ask this question on the Wilmott Software Forum. There's a decent number of quants and quantitative developers over there, and the the archives will be useful, too.
there is no thing
what else could you want?
You do realize that unless you are professional trader (who has access to data seconds before it goes out to individual investors) you are playing a losing game? Roughly 70% of individual traders lose money, once you figure in taxes and comissions. Think about it: if RANDOMLY pick a basket of stocks, buy and hold for 5-10 years, you will most likely come out AHEAD of a majority of active traders. If you buy and hold an *index fund* and the market goes up, you will outperform traders.
Sure, buy-and-hold doesnt "feel" like you're "doing something", but don't let that fool you.
It's like dieting. The only way to lose weight is to eat fewer calories, everything else builds on that foundation. There are no quick fixes or "secrets" that some people know that others don't.
Now, day-trading can be FUN (I do it occasionally, even options, but never expecting a profit) but you have to realize you are PAYING for that entertainment. It's easier just to do paper trades.
I bet the reason there is so little open-source or free trading software is that a lot of this trading software is developed strictly to sucker YOU out of your money. Back-testing strategies? You can't learn anything about the future by past behavior.
My recommendation is to write your own trading software and get rich. You won't get rich trading, that's for sure.
I've watched several people go broke on the gospel of technical analysis. To me, the tell-tale is that I never hear people who are into technical analysis talk about their total return, after taxes and commissions. Instead, I always hear them talk about the stocks they made money on. I happen to be privy to my father's portfolio, and using technical analysis, churning his portfolio, paying taxes, he has made 8.3% a year over the last 10 years. And he more or less does this full time since his retirement.
In the same period, I've averaged 17% APR, even allowing for the .com dive. My dad makes a killing on a few stocks, but in the long run he loses because of the stocks that he makes a little bit on, but not enough to cover his brokerage fees.
My advice is this: pick a few companies whose product you believe in. Figure out what their historical P/E is. Compensate for the fact that P/E's are going up nowadays (I usually allow 20:1 where traditional value is 14.5:1.) Then estimate -- and here's the art of it -- where their earnings are going in 3 years. If the P/E based on future earnings is less than your target P/E, buy.
Then, /ignore/ "the market". I mean it. Look at your portfolio once a month, and whatever you do don't watch CNNFN or pay attention to analysts whose main interest is to get you to churn your portfolio. Buy and hold, and pay attention only to your companies' BUSINESS, not the market.
Maybe some of you can make TA work for you. If so, more power to you. But my money's on buy-n-hold. TA isn't investing, it's trading and gambling. Doing research for more effective TA doesn't make it not random any more than reading the sports pages makes betting on sports not random. And you don't really need any software to do it, although Quicken might be nice. As far as a book, I'd recommend "Stocks for the Long Run" by Spiegel. He goes into a lot more detail than the Lynch's of the world. Also, get yourself a good book on reading balance sheets. You'll need it.
"He who would learn astronomy, and other recondite arts, let him go elsewhere. " -- John Calvin, commenting on Genesis 1
Does anyone have info on horse race analysis and where to get the data?
Oh well, what the hell...
i don't want to be too rude, but..
.5-1% gains per day are pretty common for good technical pattern traders (this is after commissions and before taxes).
technical analysis is more for intraday trading, i'm not sure what your father is trying to accomplish with what sounds like long-run technical investment.
commissions at $.005/share can be had relatively easily, and
i know several of them.
unrelated:
here's a relatively simple scheme for making long-term investments that may interest a few people:
http://www.dogsofthedow.com
It seems important to note that holding "THE MARKET" portfolio is great for folks that 1) adhere to the efficient market hypothesis, and 2) don't put a price premium on certain investments due to some feature of their available portfolio of investments. However, some firms may be in a position to reduce risk within their company by purchasing specific securities or options. Even though you may be an efficient market believer, some companies do benefit from specific investments to hedge risk. If the software developed was flexible enough to accept inputed data, say the returns on an internal project, it could be very useful for back testing of risk reducing investments. Just an example of why this software could be important even if you do believe in efficient markets - which is the basic description for some many of these comments arguing against a technical analysis approach to investing.
Check http://www.ta-lib.org/hdr_lnk.html Most commercial software forces the user into limited testing capability. Often they choose a model that gravitates around the charting/visual features. I took a different approach where the design has no GUI. I did put my energy into building a good back testing (walk-forward) engine with my own optimizer and money management. I found TA-Lib useful for providing efficient technical analysis functions and data access. It's not an application by itself, but a good starting point for almost any type of TA apps.
I am actually more invested in real estate than stocks at this stage.
Another option is to play Lotto 649 - the odds are terrible, but you can't win if you don't play...
BTW, I'm in Canada now. Been around a bit.
Oh well, what the hell...
I don't want to be rude either, but your statement:
> technical analysis is more for intraday trading
is equivalent to saying "I really don't know what I'm talking about"...
For the record,
- I use technical analysis almost exclusively
- I trade futures, not stocks
- I don't day trade; I look for trades that will ideally run for weeks at a time
- I've made more money trading an (initially) $20k account than I have out of working as an IT consultant for each of the last 3 years (note: I'm defining a "year" as a tax year, in this context). Aside from a 5 month break last year, I've worked more or less full time in IT for those 3 years. Furthermore, I purposely drain the account down to $20k each time it's gone above $100k
There's any number of people who trade successfully in this manner; I've met several dozen at various seminars, although I've always traded either from home or from a pager when I'm at work.
I know of people who claim to daytrade stocks, but no-one that's done it successfully for any length of time. As far as I'm concerned, that's a fair indication that it's extraordinarily difficult to do well.
Finally, when trading I look for gains considerably above your figures of 0.5-1% per day. When I can't get those returns with a high degree of confidence, I don't trade.
Technical analysis, on the other hand, depends utterly on the assumption that the market is basically efficient, and that there are no true "values" in a general sense.
Now, the truth is probably somewhere in the middle. To my way of thinking, at this time most of the market is inflated (not efficient). This means that you might have some short term luck with TA as you mess around with price fluctuations on already inflated stocks. On the other hand, there are some bargains out there, and also some tech companies that may grow a great deal over the next few years.
But, at the end of the day, 80% of mutual funds, the great bastions of TA, underperform the market. Sorry, I don't buy it.
"He who would learn astronomy, and other recondite arts, let him go elsewhere. " -- John Calvin, commenting on Genesis 1
Just out of curiosity, what books/methods would you recommend? I'm certainly open to being proven wrong, but thus far haven't seen anything but buy and hold investing that offered a conistent return. Can you describe your anualized return?
"He who would learn astronomy, and other recondite arts, let him go elsewhere. " -- John Calvin, commenting on Genesis 1
This is an OSS project hosted on sourceforge: http://qtstalker.sourceforge.net.
From the SF description: "Stock market, commodity and technical analysis charting app based on the Qt toolkit. Extendible plugin system for quotes and indicators. Portfolio, back testing, chart objects and many more features included."
Finally, when trading I look for gains considerably above your figures of 0.5-1% per day. When I can't get those returns with a high degree of confidence, I don't trade.
I must offer my congratulations! $20,000 earning 0.5% per day will have a future value of $123,493.06 at the end of one year. On the other hand, the same $20,000 earning 1% per day will result in $755,668.69. So assuming "considerably above" is around 2% to 2.5% per day, you would have an annual income between $27,548,165.84 and $164,149,991.15 (less the original 20K).
U DA MAN!
If VISTA is the answer, you didn't understand the question
I certainly agree with the tenets of value investing. I'd have to say this describes my personal investing philosophy better than anything. However, in order to hedge specific risks a company may face due to investments that are required by their business model, it may be advantageous to gain exposure to securities which are not, objectively speaking, undervalued. I'm just saying that capital markets are useful for things other than value investing, and the software described at the outset could be useful in many circumstances, regardless of what investment goals you have in mind. This, of course, depends on how much flexibility there is on the data input side.
Man, I love it when people use math. :) Until proven otherwise, let's just agree that this guy is perhaps mistaken about his overall returns. Or perhaps there just aren't very many opportunities where he can apply his winning strategy. Either way, have to wonder why he doesn't just leave his money in for a year or 10 then buy australia.
"He who would learn astronomy, and other recondite arts, let him go elsewhere. " -- John Calvin, commenting on Genesis 1
collective2.com is a website where you can set up your own trading system for free and compete with other traders by making trades in real-time. Your system is rated by % of return. You can have more than one system, either futures, equity options, currencies, commodities, or just stocks. Now, what's interesting there is that you can sell your services by subscription. It is great learning tools and potential to make some money if your system is a successful one.
IP was invented for the sake of lawsuits.
Check out QTExtender QTExtender. Excellent decision support product for financial decisions.
I really do not recommend Prophet's historical options data. I just arranged for a refund, for the following reasons:
-There is no way to tell which stocks the majority of the option roots are for. This is particularly irritating, because if you can't match them, they're useless.
-Quite a few of the files are misnumbered when it comes to the year (possibly more, but I didn't look that closely once I got to the problems that it was already having). That's more trouble to figure out how to relabel thousands if not millions of files.
-The data's not very clean. They basically take what the CBOE reports and pass it on to the customer. There are missed decimal points, missed dates, seemingly incorrect volumes and open interest totals, etc. I didn't investigate it very far once I saw some of the errors.
-They will not go back and try to fix historical data. I asked the tech support people, and they said that once a mistake makes it into historical data, it stays there and they won't try to fix it.
In short, I definitely don't recommend their historical options data. I have also had experience with their charting app (through my broker, thinkorswim, which uses Prophet's Java charting application in its trading software) and am quite satisfied with that. They seem to be a good company, but historical options data is not their strong point.
I claim first use of "Error No. 0B" - or "No. 0B error." It'll be the new ID 10T!