| Index | Recent Threads | Who's Online | User List | Search |
|
|
 |
Portfolio123 » List all forums » Forum: Latest Release » Thread: New feature lets you create custom formulas |
|
Total posts in this thread: 19
|
[Request a Feature] [Add To My Favorites] [Watch this Thread] |
| Author |
|
|
marco
|
You can now create custom formulas that can be used as regular factors. This is a great time saver since you don't have to re-type formulas. You can create your own formulas in the MyP123->Formulas section here. Simply create a new formula and assign it a name. For example to create a formula to calculate the 3 month return, enter: Name: 3MoRet Formula: 100* (Close(0)-Close(60))/Close(60) Description: Calculate the 60 bar return (aprox 3 months) Once created you'll be able to: - Use it in any sytem, buy/sell rule and screen. - Share your formulas with the community. - Use them in screen reports (current data only) The name is automatically pre-pended with a $ sign. For example to use your new formula in the screener enter the following rule: $3MoRet > 10 Your formulas will be visible in the 'Rule Reference' under CUSTOM FORMULAS. Here you'll be able to see your formulas and P123 pre-defined formulas. However, we currently do not have any P123 formulas. If you have any suggestions for commonly used formulas we'll be happy to include them. Regards Marco ---------------------------------------- Portfolio123 Staff ---------------------------------------- [Edit 1 times, last edit by marco at Apr 10, 2008 9:54:07 AM] |
||
|
|
BJS
Advanced Member
|
Excellent, Marco! Thanks! |
||
|
|
Sterling
Advanced Member
|
Can these custom formulas be used within some of the current functions? For example can I use them as a substitute for the close, open, high, or, volume in the Highest() function or the SMA() function? |
||
|
|
marco
|
Sterling, I think the answer is no. Can you give an example? ---------------------------------------- Portfolio123 Staff |
||
|
|
Koronbock
Advanced Member  GERMANY Joined: Jun 11, 2006 Posts: 166 Status: Offline |
Great feature, thanks Marco ! As a "reminder": Will we get SHORT capabilities any time soon ???? Wern ---------------------------------------- [Edit 1 times, last edit by Koronbock at Apr 9, 2008 2:20:27 PM] |
||
|
|
Sterling
Advanced Member
|
An example might be I want to create a variable for the highest high value over 5 days and want to compute its moving average over 20 days. Example New variable custom formula: HHV5 -> Highest(#High, 5, 0) Output desired: SMA(20,$HHV5) By the way, does this feature allow us to see the output value in a screen factors report column? I want to see a 1 day rate of change as one of the outputs of a report when I'm screening but previously I haven't figured out if it is possible. Will a custom formula PctAvg(1,2) ( or is it PctAvg(2,1)? ) or perhaps a more intuitive for me ((Close(0)/Close(1))-1)*100 now allow me to see this? ---------------------------------------- [Edit 3 times, last edit by Sterling at Apr 10, 2008 2:09:04 AM] |
||
|
|
probtrader
Advanced Member ITALY Joined: Oct 11, 2004 Posts: 109 Status: Offline |
Excellent. Can we also display the formula value in the column report? |
||
|
|
marco
|
Sterling, your example is not possible. Probtrader, you can use custom formulas in the screen reports. Go to Screener->Reports, click on New and give it a name (must be a Current Data Factor report). Your custom formulas will appear in the lists. ---------------------------------------- Portfolio123 Staff |
||
|
|
jerrodmason
Advanced Member UNITED STATES Joined: Jan 14, 2005 Posts: 599 Status: Offline |
Really really useful extension would be to allow parameters. Example: Name: PctReturn(n) Formula: 100* (Close(0)-Close(n))/Close(n) Description: Calculate the n-bar return (I've already posted this idea as a question on another thread, but that probably got lost.) ---------------------------------------- The smart money was on Goliath. "He's not the Messiah. He's a very naughty boy." |
||
|
|
dimitri
Advanced Member UNITED STATES Joined: Oct 26, 2006 Posts: 38 Status: Offline |
Marco, Great Feature! Would you consider allowing the Function FRank to be used within custom formulas as well? Considering FRank is already permitted anywhere custom formulas can be used (Sims, ports & screens) I don't see why not let it be used within custom formulas as well. Thanks, Dimitri |
||
|
|
[Show Thread Printable Version] |
