Search found 63 matches
- Sun Aug 14, 2016 7:16 am
- Forum: Forum
- Topic: Backtesting Using External Data Fields
- Replies: 4
- Views: 16196
Re: Backtesting Using External Data Fields
Hey Chris, There is a much more concise version of my questions that has been sitting in your other Forum "Edgerater Scripting" for the better part of 2 weeks now, along with other questions. Perhaps it would be easier for you to answer those questions, as creating that video on Jing would...
- Fri Aug 12, 2016 3:21 pm
- Forum: Forum
- Topic: Backtesting Using External Data Fields
- Replies: 4
- Views: 16196
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: 16196
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: 10611
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: 9477
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: 7434
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: 7188
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: 15434
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: 13353
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: 15434
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...