|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Strike Price | |
| tennoel 6/13/2012 3:55:45 PM | Jeff, Can an SQL be written comparing strike price to the final odds, or odds 1mtp, to tell the win% and roi when the odds are >= to the strike price in the wager history?
| |
| jeff 6/14/2012 1:03:06 AM | Absolutely! The relevant field names are: decisionodds strikeprice Both fields are data type: numeric, single precision You can write sql to do simple evaluations based on one field, both fields, comparisons between both fields, and even perform a little math. Below are three screenshots showing the WagerHistory Module Reporting Engine after executing three different sql expressions using the two aforementioned fields: Screenshot #1: http://www.jcapper.com/messageboard/avatars/wagerhist06132012a.jpg The above screenshot shows results of the HIST data sample where the value recorded in the decisionodds field is less than or equal to the value recorded in the strikeprice field. Screenshot #2: http://www.jcapper.com/messageboard/avatars/wagerhist06132012b.jpg The above screenshot shows results of the HIST data sample where the value recorded in the decisionodds field is greater than the value recorded in the strikeprice field. Screenshot #3: http://www.jcapper.com/messageboard/avatars/wagerhist06132012c.jpg The above screenshot shows results of the HIST data sample where the value recorded in the strikeprice field is greater than zero, the value recorded in the decisionodds field is greater than the value recorded in the strikeprice field, and the value recorded in the decisionodds field is at least 3.50. I really need to do the following: 1. A write up of the WagerHistory table field names and data types (like I did for the StarterHistory table.) 2. A write up explaining how and when the values in the WagerHistory table that aren't populated when you hit the Save button become populated using companion values pulled from the StarterHistory table. Armed with knowledge about these two (unfinished) areas, I'm thinking most players could gain some serious insight about their wager history. -jp .
| |
| tennoel 6/14/2012 8:02:22 AM | Great! Thanks Jeff. I tried 'odds', 'decsnodds', and 'odds1mtp'.
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |