Search results

Hi- I am looking for two files from the distant past: tr011111.zip gx011111.zip Does anyone go back that far? Thanks.

Instead of using Long, Short, Neutral you could use 1, -1, 0, thus: c2 = (a2 * b2) + c1 You can create constants in Excel (e.g., Long = 1, etc.), so you still use the names in Column B: 1. On the Insert menu, point to Name, and then click Define. 2. In the Names in workbook box...

Actually, a billion is a thousandth of a trillion, which is 0.1%.

DDE will not work to capture every change. You will have to use a polling method to monitor the cell and will miss some price changes. You might want to look at the IB activeX control. You can register it in excel and then the various IB events will be in the VBA editor just like the excel...

Engineers seem drawn to technical analysis but not necessarily to trading. I remember noticing this in the '70s (for example, John Magee of Edwards and Magee fame, MIT grad) and it holds true today (for example John Ehlers with digital signal processing).

Use the log of the price series rather than the price series itself. That way the slope of the linear regression equals (Δprice/price)/Δtime rather than Δprice/Δtime.