Recent content by RedE

A further refinement is to add a trade code to each row, so you can then calculate P&L per closed trade. In this way, each row represents a single ticket and groups of rows, not necessarily contiguous ones, represent a whole trade, as inidicated by the trade code. You then do a =SUMIF...

The most efficient way to distinguish Long from Short is to use positive values for long and negative values for short in the trade quantitty column. That way, simply multiplying the trade price column by the trade quantitiy gives you a cash impact, which when summed gives you the P&L to date...

Try CBOT.com/dow

Has anybody traded the VIX futures on the new CFE market. For those not up to speed: The VIX is the index which measures the "implied volaitility" of the near SP500 index options. The VXB is another index: the VIX value multiplied by 10. The Futures are based on the VXB. So, trading the...

RE Wireless LANs Beware the following: (1) WiLANs are inherently insecure (2) they intorduce another point of error into your systems, and if you're trading through one, you need 100% reliability (3) Worst of all: WiLANs are slooower than wired LANs (4) Microwave ovens interfere with the...

See http://www.riskglossary.com/articles/collateralized_debt_obligation.htm

If your employer's IT dept. have done their job properly, your new laptop will be a member of your company's domain and you, not being an administrator, will not be able to change that. The vital piece of info you omitted is how do you connect to the ADSL router. If it is through a USB port...

RE: "Options pricing models are geared to favour sellers over buyers." I do not agree. Options pricing models assume an equal probability for an upmove or a down move - the degree of movement over a given period is determined by the "assumption" about volality (thus "implied" volatility)...

Excel knowledge For anyone who is interested, the best resource, by far, for learning how to program Excel, is "Excel 2000 VBA Programmers Reference" published by Wrox Press. It is now on the 2002 version. Serious traders can only benefit from knowing how to drive Excel to its limits - and...

IQLink Macro I was bored, so I wrote this macro for you. It took 3 minutes, so don't worry about compensation! The code is in the attached Excel file. and it is: Sub InsertIQLink() Dim rngCell As Range Dim rngSel As Range Set rngSel = Selection For Each...

Covered Calls = RISK I am sure all of you coverved call writers are aware of this, but just in case: Covered Short Call = Synthetic Short Put A covered call is NOT a risk free position. It is not free money. The risk graph for a covered call is identical to the risk graph of a short put. In...

Is HISTORYBANK.com still alive I heard that HIstoryBank was due to be turned off 31.12.2003. Does anyone know if this has happenned? When I try downloading all I get is (something like): Downloading 0% distributing 0% I never seem to get a connection to HIstoryBank. Are there any firewall...

You have 2 options (at least): (1) In the database windows,click NEW and create a Linked table which you point at the text file. The text file will then appear to act like a native Access table (2) Import the data into an existing table. Goto File-Get External Data-Import Option 1 is...

Optionetics Seminar The duo of George Fontanills and Tom Gentile, with whom many of you may be familiar through their books, magazine columns or website( www.optionetics.com ), are holding an Optionetics seminar in London next week. Has anyone been to one of these? How was it? Did you learn...

NEVER UPGRADE ONLY INSTALL FROM SCRATCH.