Excel help needed (again..)

Hey Excel gurus.. I’m looking at adding a calculation of drawdown to my spreadsheet. I have columns of both individual trade results as well as a column for cumulative P&L but I have no idea how to build a formula which looks at the largest drawdown drop. I may also get the Excel Bible book […]

Stocktickr Interview

I had the pleasure of doing an interview for Stocktickr in which I tell a bit about myself and how I trade. You’re welcome to leave comments / questions and I’ll try to answer them.

Several trades

Market looked gree in the morning so I was looking long. My watchlist had: ATYT, VPHM, AVII and PTEN. I took three trades
PTEN - broke my entry rules on this one and paid the price of -1R
ATYT - didn’t go anywhere and ended as BE
AVII - closed at end of day for +2.1R
Total for the […]

Expectancy

I was looking at my stats yesterday and the calculated expectancy (TraderMike’s explanation is really succicnt) and I realised that I’m not quite sure what it means. Sure I can tell if it’s positive or negative but beyond that I have no clue what it “should” be or what’s the typical expectancy for stock day […]

ACD method

This is an interesting resource on the ACD Method which I found through a fellow trader in NZ magpie trader. There are some interesting articles, many with a forex focus but some more general ones including a PDF to Chapter 1 of the The Logical Trader.
Complete resource list can be found here:
StrategyBuilderFX Community - ACD […]

QCharts now runs on Linux!

Another step closer to a Microsoft free shop - QCharts now works on my Linux! With a bit of mucking around it now loads up.
What you need is to install:
1. Wine HQ
2. Mozille ActiveX Control installed on Wine from here: http://crossover.codeweavers.com/redirect/mozcontrol
3. msvcirt.dll and mfc42.dll copied over from Windows’s system folder to Linux Wine’s /windows/system
4. […]

More on Stops

Stops and more stops, this is my focus these days. My entry rules are pretty well defined, the end result of profit or loss depends largely on exists.
The following article from HRE covers Q&A on all sorts of stops: percentage, fixed dollar, time based, gaps, stops gunning, trailing etc.
Some favourite points:
The trends are more obvious […]

« go back — keep looking »