Hi Chris,
A Hindenburg Omen divide by zero error is caused by the fact that the New York markets were closed on Oct 29 and 30 2012 due to Hurricane Sandy. The advance decline difference is zero for Oct30. The error propagates all the way to the end of the spread sheet. I used SP1500.txt security list. Also had to add SPY to the list because the spreadsheet expects SPY to be in any list it runs on.
Hindenburg Omen divide by zero error.
Moderator: Chris White
-
Chris White
- Posts: 212
- Joined: Mon Nov 29, 2010 9:21 pm
Re: Hindenburg Omen divide by zero error.
Hi Joel,
I have made an update to that template which you will get in the next update in a couple of weeks. The update addresses the problem of the case where advancers + decliners = 0 which was used as a divisor in the calculation of RANA (Ratio Adjusted Net Advancers). This div by zero error then propagated to every subsequent row.
I'm attaching the updated template in case you want to get it before the official update. Just unzip the file and copy it to your EdgeClub/System directory overwriting the one that is there.
I have made an update to that template which you will get in the next update in a couple of weeks. The update addresses the problem of the case where advancers + decliners = 0 which was used as a divisor in the calculation of RANA (Ratio Adjusted Net Advancers). This div by zero error then propagated to every subsequent row.
I'm attaching the updated template in case you want to get it before the official update. Just unzip the file and copy it to your EdgeClub/System directory overwriting the one that is there.
