Search found 62 matches
- Fri Aug 12, 2016 3:21 pm
- Forum: Forum
- Topic: Backtesting Using External Data Fields
- Replies: 4
- Views: 18324
Re: Backtesting Using External Data Fields
Hey Chris, That solved it! Now for the problem I was expecting to run into: I thought I'd combine the list output capability that you added to the Entries and Exits in the latest July Template with the external data field retrieval that you described in your latest blog post in a multiple column ret...
- Fri Aug 12, 2016 11:37 am
- Forum: Forum
- Topic: Backtesting Using External Data Fields
- Replies: 4
- Views: 18324
Backtesting Using External Data Fields
Chris, I was going to try out this new backtesting capability so I started out with a blank new script window and copied and pasted this from your blog: myVal:= WB_SYMBOL_LOOKUP(‘C:\\myData\Top50GIR.xlsx’, ‘Values’); cond1:= myVal == 1; cond2:= COUNT(cond1, 80) >= 20; event: cond1 & cond2; and w...
- Wed Aug 03, 2016 10:14 am
- Forum: EdgeRater Scripting
- Topic: your latest blog post on backtesting with external data
- Replies: 1
- Views: 11872
your latest blog post on backtesting with external data
Chris, In the externally called spreadsheet do the stock names have to be in a column and the individual dates in a row, or can it be switched around? Do the data values in the externally called spreadsheet for the dates, have to be 1s and 0s, because they are only to be used in the variable data se...
- Wed Aug 03, 2016 9:58 am
- Forum: EdgeRater Scripting
- Topic: Using Weekly and Monthly Time Frames in Script
- Replies: 1
- Views: 10654
Re: Using Weekly and Monthly Time Frames in Script
Chris, I can't find the term "STREAK" anywhere in the online code documentation but it appears it might be the number of consecutive days that a condition such as "Close" is greater than the prior "Close", given that the "Close" the day before was lower than i...
- Sat Jul 16, 2016 6:15 pm
- Forum: Forum
- Topic: Baselining a stock with POTBOT: Who knew!
- Replies: 0
- Views: 8500
Baselining a stock with POTBOT: Who knew!
I created a simple script event : C>0; for a stock baseline test using the new POTBOT template. Surprisingly, for MSFT from 1/1/00 to current, the POTBOT run showed that over 50% of the time in 4,140 events, MSFT will reach a favorable 4.5% gain in 21 trading days. I guess the next thing to check is...
- Sat Jul 16, 2016 12:51 pm
- Forum: Forum
- Topic: Suggestions related to POE/POT BOT templates
- Replies: 0
- Views: 8107
Suggestions related to POE/POT BOT templates
Chris, 1. Could you add the stock name to the automatic generated report name so if we accidentally click the Save button instead of Save As we will at least know what stock the report is about? 2. Besides the basic functionality of those 2 new templates I really like the features of the "Choos...
- Thu Jul 14, 2016 11:22 am
- Forum: Forum
- Topic: Portfolio Manager
- Replies: 4
- Views: 17528
Re: Portfolio Manager
Hey Chris,
I'll send you one of my timing list spreadsheets to your regular email, it has about 20 entry and exit dates for a triple leveraged ETF timing system that someone in my VV user group developed.
Ed S.
I'll send you one of my timing list spreadsheets to your regular email, it has about 20 entry and exit dates for a triple leveraged ETF timing system that someone in my VV user group developed.
Ed S.
- Thu Jul 14, 2016 11:05 am
- Forum: Forum
- Topic: The use of the Backset Function ?
- Replies: 3
- Views: 15276
Re: The use of the Backset Function ?
Henry,
Did you ever get a workaround for "PREV" ?
Thanks,
Ed S.
Did you ever get a workaround for "PREV" ?
Thanks,
Ed S.
- Thu Jul 14, 2016 9:23 am
- Forum: Forum
- Topic: Portfolio Manager
- Replies: 4
- Views: 17528
Re: Portfolio Manager
John, There is a possible workaround to using your own entry and exit dates in the Entries and Exit tab and then run a simulation; See my post in the "Add to Entries" message stream circa December 2014. You'll have to use Excel for the Date conversion and then paste into separate Entry and...
- Fri Nov 06, 2015 12:15 pm
- Forum: Forum
- Topic: Price Predictor Template suggestion
- Replies: 0
- Views: 18997
Price Predictor Template suggestion
Hey Chris, I was using the Price Predictor Template, which I like a lot, and realized that some of the columns to the right were still showing avg results even though it was impossible to calculate them meaningfully because there were not enough stock history days available for some of the exits. Fo...