Technical analysis

Technical Analysis
Technical Analysis
Technical analysis is a collection of methods to predict future stock prices taking into account only the past and present data – prices and (optionally) volume. There is no consideration given to the fundamentals of the company or the industry under consideration.

I personally use technical analysis(TA) only after I have zeroed in onto a company that I want to invest in. That is, I use it to determine when to enter (buy) and when to exit (sell). Over and above that – I do not execute blindly the output from TA. I look at the market sentiment, company and industry timing etc. Even so, technical analysis does help me big time with the decision making.

How is TA performed? No need to understand that. Attached is a spreadsheet that will help you carry out TA based on different indicators: Moving average, Moving Average Convergence / Divergence or Relative strength index.
The spreadsheet is here: AutoTech.

How is this spreadsheet different from others available online?

  • This sheet doesn’t require you to interpret the graph. While the graph is still created, which you can check, or create additional graphs based on the data, its not really required – you can read the interpretations directly. The sheet gives you buy/sell advice directly based on the indicator you select.
  • The sheet does not require you to buy MS Excel if you do not have it. It works fine with Openoffice Portable. I have already talked about portable apps – this one is free as well.

Portable software

Portable software refers to programs that can be stored onto a media (such as USB drives, CDs, external harddisks etc.) and run directly from there on multiple computers. In other words, software that you can move from one computer to another without the need to re-install.

There are a lot of sites that provide such software for download. Google for “portable software” in general, or, say for “portable firefox” in particular. My favourite portable apps are the GIMP, and portable FileZilla (a GUI FTP tool).

Cygwin is a Linux like environment for Windows. It can run within Windows and access the filesystem. Its very useful to people like me who need Windows as the main OS, but need to test Linux shell scripts and other utilities. I even have a portable version of Cygwin, created based on these instructions. In fact, I was able to improve the procedure slightly. If someone needs help, please contact me through comments. I want to upload the ISO of the DVD created – if someone can provide the bandwidth and hosting space, I can mail a copy of the DVD to him.