Page 1 of 1
How to add additional Columns
Posted: Mon Jan 21, 2013 8:48 am
by Import
I am using EdgeClub. I am using the template Trading Leveraged ETF's with ConnorRSI.
My question is how do I add an additional column to the template? IF I wanted to add the X=4, CRSI>80 to Column I for example,...how do I do that?
Thanks,
Jim
Re: How to add additional Columns
Posted: Mon Jan 21, 2013 8:55 am
by Chris White
Hi Jim,
The key is that the processing of the template is all driven by the naming of cells and ranges of cells. Here’s the set of names for that workbook:
- Name Manager showing the list of defined names in the Leveraged ETFs workbook
- crsilev3.png (44.87 KiB) Viewed 15874 times
The ERF_ name (stands for EdgeRater Formula) refers to the range C2:H2. The EdgeClub software only looks in C2:H2 for formulas to process. If you want to add another formula in I2, you can put the formula in I2 (on the ‘System’ worksheet) and then name the cell ERF_1. Alternatively you could extend the range ERF_ to include I2.
Hope that helps, I will put a video together on this topic as I have had a number of questions about it.
Chris.