Stock technical analysis software

  • Guest, it's time once again for the hotly contested and exciting FoH Asshat Tournament!



    Go here and fill out your bracket!
    Who's been the biggest Asshat in the last year? Once again, only you can decide!

Tuco

I got Tuco'd!
<Gold Donor>
45,320
73,377
I"m reading through abook on Technical Analysiswhich, in short, is how to predict stock market trends based on patterns that can be gleamed from their volume and price history. It all makes sense and is a good book, but I don"t really feel comfortable with the ideas in the book by just reading and understanding. I"ve been navigating charts at google finance, using the action to build patterns as best I can, but I"ve found it really lacking in terms of providing the kind of configurable analysis I want.

What I"d really like is a software that can:

1. Receive real time updates on the NYSE or other markets.
2. Perform analysis of individual stocks and present possible patterns and trends that exist in the charts.
3. Have configurable set of parameters that can be used to create buy/sell signals based on the perceived patterns.

I"m somewhat confident that software like this exists (A quick google brought up many professional software packages), but I"d like to hear what people know about what solutions are good.

I"ve thought about making my own software to manage this, the hardest part would be the analysis part which is what I really want to understand. The burden for doing this is getting the price/volume history of the exchange itself. Does the NYSE have some kind of semi-public database it publishes that people can lease access to? All I"d need is some way to query it to do what I want.
 

Shonuff

Mr. Poopybutthole
5,538
790
There"s many ways to do TA, but don"t let it be the main focus on your investing. Empirically, fundamental investing is better than TA. The people I know that are professionals at investing (i.e. fund managers from my b-school), look at the present value of cash flows of the company first to determine if its a good stock, and then they use TA to determine an entry point. TA should never be the main focus of your investing.

There are empirical studies out there on investing on fundamentals, as well as TA. Before you ask, I just moved to a new house, and I"m not digging through boxes and boxes of stuff to find my lecture notes. With investing, rather than take info from some anon person on message boards (most of the stuff posted on investing at FOH is bunk), do your own research to come to a determination. There"s probably three or four posters on this board even qualified to talk about this stuff in an intelligent manner.
 

prescient

Silver Knight of the Realm
97
5
You need gobs of historical data and the more granular the better. Think of TA as poor man"s quant analysis. I"m with Lyrical just go with fundamentals. I would personally screen the universe of stocks down to a few reasonable options and from there start building some models to explain their movements (ROE model can be used to explain changes in many of the ratios, and help highlight accounting issues), then start looking at discounted cash flows. After that you still have optimal portfolio weightings to worry about (minimizing your volatility for a given return). With all that going on I think it"s safe to say you can disregard TA for a while.

I wonder if I make the community of 4?
 

Gurgeh_foh

shitlord
0
0
Lyrical said:
There"s many ways to do TA, but don"t let it be the main focus on your investing. Empirically, fundamental investing is better than TA. The people I know that are professionals at investing (i.e. fund managers from my b-school), look at the present value of cash flows of the company first to determine if its a good stock, and then they use TA to determine an entry point. TA should never be the main focus of your investing.
That"s basicaly it, if you concerns are short term, TA is important. If you"re investing for several years TA isn"t that important. Obviously TA is a lot more important if you do dozens of trades a day than, like most private investor, if you do a couple of trades per month as a long term investment.
 

Tuco

I got Tuco'd!
<Gold Donor>
45,320
73,377
Thanks for the advice gentlemen. After I finish the book I"m reading I plan to focus on some other stuff, but after that I"ll probably read a book on securities analysis.

I"ll let you guys know if I find any software solutions that fit what I"m looking for.
 

prescient

Silver Knight of the Realm
97
5
Tuco said:
Thanks for the advice gentlemen. After I finish the book I"m reading I plan to focus on some other stuff, but after that I"ll probably read a book on securities analysis.

I"ll let you guys know if I find any software solutions that fit what I"m looking for.
I guess if you are absolutely set on TA you could grab an account at MB trading. Pretty sure you can get free real time values through a practice account and i think metatrader has it"s own scripting engine to let you build your own indicators.
 

Elerion

N00b
735
46
I"d say any amateur that thinks they can consistently get better results from personally doing active management rather than by just passively investing in a nice low cost fund are nuts.

Most professional investors fail to consistently beat their benchmarks, and the quality and speed of the information/research they have access to is miles ahead of you as a private investor. You"re playing against the odds.

It"s a great hobby, though. Treat it as such. Play it safe and it generally won"t lose you more than you would spend on other hobbies, and you might catch a lucky break and end up making bank. It"s also a fantastic way to improve your awareness of personal finances, motivate you to save, and to keep up to date on important issues.



With that out of the way, prescient and Lyrical"s advice in this thread is good.
 

Fulorian

Golden Knight of the Realm
104
46
Blah blah academic bullshit. It"s not hard to beat index averages by doing a little homework. Those statistics are compiled by PhD"s who scurried into academia after being failures at Wall Street. They make up shit like the efficiency frontier to feel superior about their failures. Trust me, I know: I live it every day (MS Finance & CFA 1 almost complete).

Fact: The larger the sums of money you are working with, the harder it is to attain outsized results. The list of available financial instruments with viable liquidity to make a certain % return begins evaporating once you start entering into the millions.

Find some good companies at cheap or reasonable valuations, put your money into them, and wait. You WILL get superior results.

Here"s a few stocks I 500% guarantee exceed their benchmarks over the next 5 years (on both a risk adjusted and total return basis). I"m not saying you should own them (although I would, and do), but at least study their characteristics:

Ford (F) - Trades at 5 times trailing earnings, has amazing earnings growth, has the best management in the United States. Has pulled off a miracle, and an equivalent valuation of it against the GM IPO puts the fair price at $30/share.
Goldman Sachs (GS) - Best financial company in the United States. The VERY best and brightest, pulls off a 20% ROE like clockwork but is priced at less than 1.5x book.
Hyundai Motor (005380:KS - you have to have an international broker to touch it, but you can still find financial statements and study what they"re doing/valuations) - Best profit margins in the business, market share is growing at the fastest rate any automaker has seen since Japan entered the US market in the 70s. 3x US market share in less than a decade.
KKR Financial (KFN) - Personal favorite. Difficult to understand their financials, but they"re trading very cheap for what they are. Mainly only held by institutional investors, less predictable day-to-day movements as a result, but a long term solid company still stuck at a discounted price from the crash.

Every single one of these will have doubled by 2015. Some will have doubled by the end of 2011. The S&P won"t. And academics will, 4 years later, tell you that a fund composed of these 5 stocks and nothing else are outliers, not statistically significant, and were impossible to predict in 2010.

Now you may begin the requisite demeaning of my credentials and attacking of my thesis.
 

Elerion

N00b
735
46
For every self-proclaimed genius claiming he can beat the market blindfolded, there"s a fund manager that was allowed to put his money where his mouth was over a number of years and failed to beat benchmarks.

I don"t believe you can"t beat benchmarks. It"s been my job to do so. I just believe it"s hard as fucking fuck to do and most professionals fail, despite having far better tools and information than ordinary investors. Thus private investors shouldn"t expect to actually make money off actively investing, they should treat it as a fun, educational and free/cheap (if you play safe) hobby with a potential lottery win.

And no, the vast majority of fund managers aren"t limited by their size. You could accumulate millions of dollars worth of GS or F per day without affecting the price significantly.
 

Shonuff

Mr. Poopybutthole
5,538
790
Elerion said:
For every self-proclaimed genius claiming he can beat the market blindfolded, there"s a fund manager that was allowed to put his money where his mouth was over a number of years and failed to beat benchmarks.
Gonna have to agree with you there. Everyone brags about beating the market, but no one wants to show you their portfolios.
 

prescient

Silver Knight of the Realm
97
5
Lyrical said:
Gonna have to agree with you there. Everyone brags about beating the market, but no one wants to show you their portfolios.
My fake portfolio kills the market, and it"s all buy and hold. I"ve been trading this fake portfolio since mid 2006. I need a life.

Alpha 9.78%
Beta .27
Rsquared .35

Honestly though my timing is pretty killer hahaha.

Edit: Fuck Energizer, I overweighted or i guess optimally (risk return adjusted) weighted it in my portfolio the day before it dropped off the goddamn map. I need to dump that dog.

Edit 2: While I"m thinking about it, I"ve been thumbing through the Handbook of Portfolio Mathematics - Formulas for Optimal Allocation and Leverage and I think that is a pretty solid book. You"re going to need a little stats knowledge to read it though. Don"t let that scare you though it isn"t really quant heavy. If you can handle correlation, covariance, and z-scores I think you would be fine, and the author seems to walk you through many of the examples but I pretty much just skipped to the sections I was interested in.
 

Tuco

I got Tuco'd!
<Gold Donor>
45,320
73,377
I signed up for MB Trading and they"re going to call me about opening an account or whatever, but I"m betting that"s going to be a dead end. Unless I"m missing something, Metatrader seems focused on Forex, and I"m more interested in stocks at the NYSE. It seems like Metatrader is just a front end to data, so maybe there"s a way to convert an exchange"s stock data into something it eats... It"s not open source so it"s really not what I want.

I found what I"m looking for though, Yahoo has a Web API that one can use to request stock data. Google has one also but it"s focused more on portfolio work it seems so I"m pursuing Yahoo"s for now. I haven"t explored everything that much. This article gives a quick explanation on what I"m doing.C# .NET Yahoo Stock Download and Charting

I also found a set of libraries to use for TA, most notable is ta-libTA-Lib: Technical Analysis Library | Download TA-Lib: Technical Analysis Library software for free at SourceForge.netbut I haven"t dug into it.

Thanks for everyone"s help.
 

prescient

Silver Knight of the Realm
97
5
Tuco said:
I signed up for MB Trading and they"re going to call me about opening an account or whatever, but I"m betting that"s going to be a dead end. Unless I"m missing something, Metatrader seems focused on Forex, and I"m more interested in stocks at the NYSE. It seems like Metatrader is just a front end to data, so maybe there"s a way to convert an exchange"s stock data into something it eats... It"s not open source so it"s really not what I want.
Sorry about the metatrader thing I totally forgot. What you can do though is get the MB Navigator and link it to Ninja Trader. Though this has been problematic for me as it won"t build charts, but it may be because I"ve been playing with version 7.0 which is beta. The other option is that MB Trading has a fix API and their own API for entering trades if you want to do it all programatically. The same goes for Interactive brokers but I don"t think they will give you quotes unless you have an active account.

I know this sounds like a plug for MB Trading, but they are the only source I"ve found where they don"t shut off your feed after 30 days of playing with it which is nice. Additionally, since I"m doing the MBA thing and I don"t have access to all the fun institutional shit (ie direct ticker plant feeds & massive databases) anymore so I take what I can get.

I"m working on learning me some Matlab right now so that I can execute a currency pairs trading strategy, well maybe execute a currency pairs trading strategy. I"ll have to see if I can come up with anything profitable through backtesting, and then test on a simulated account + allow for slippage which is a real bitch in forex.
 

Tuco

I got Tuco'd!
<Gold Donor>
45,320
73,377
Hehe, when Lyrical said no one wants to show you their portfolio, he didn"t mean fake portfolio. It"s easy to make a set of portfolio"s and show off the best one! Just fuckin" with you prescient.

I did some more research and started the development of my project. I"m very happy/lucky to have stumbled upon the yahoo api. Maybe I"m missing it but there"s a real lack of content on the internet for doing what I"m doing (Which makes me think I"m just missing on some advanced stock analysis project that makes everything obsolete. Like being disappointed in the options of consumer operating systems while not knowing about the Windows OS"). I expected there to be a very complete open source C# or java application that taps into a database like yahoo"s finance and runs all the analyses I want.

Instead I"m finding a lot of outdated open source libraries and a suite of decent non-open source applications like metatrader that use some licensed servers for trading.

Either way I"ve got what I need. I can quickly get the financial data of any NYSE listed stock, with a daily readout of the open, high, low, close, volume and adjusted close. With this I should be able to build analysis using everything in the book I"m reading and run simulations.

I"ll keep this thread updated with what I come up with or if I find something more suitable to what I"m doing. I should find a library that does this and also a library meant to chart this kind of thing.