1. 10-06-15 05:56 PM #1
    Waterstpub87
    Slan go foill
    Waterstpub87's Avatar Become A Pro!
    Join Date: 09-09-09
    Posts: 4,044
    Betpoints: 7292

    Excel Help

    Trying to make an automated backtest system in excel.

    I pull SBRodds for particular days and parse it to get the spread which looks like this:
    -1½

    However, excel does not recognize this as a number.

    Does anyone know how to easily convert that to -1.5?
    Reply With Quote Reply With Quote
  2. 10-06-15 07:14 PM #2
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7160

    You can do a macro which replaces that expression with -1.5
    Reply With Quote Reply With Quote
  3. 10-06-15 08:26 PM #3
    Waterstpub87
    Slan go foill
    Waterstpub87's Avatar Become A Pro!
    Join Date: 09-09-09
    Posts: 4,044
    Betpoints: 7292

    Excel doesnt recognize as number. Surely someone must have used the data import function in excel to import daily lines and would have figured out a fix for this.
    Reply With Quote Reply With Quote
  4. 10-07-15 06:41 AM #4
    Thunderground
    Thunderground's Avatar Become A Pro!
    Join Date: 09-09-15
    Posts: 256
    Betpoints: 277

    have you tried resetting the column from 'fraction' to 'number'? Those options are under 'general'.
    Reply With Quote Reply With Quote
  5. 10-07-15 07:02 AM #5
    Waterstpub87
    Slan go foill
    Waterstpub87's Avatar Become A Pro!
    Join Date: 09-09-09
    Posts: 4,044
    Betpoints: 7292

    Yes. Excel does not recognize the output as a number, so changing the number format will not work.
    Reply With Quote Reply With Quote
  6. 10-07-15 07:13 AM #6
    HeeeHAWWWW
    HeeeHAWWWW's Avatar Become A Pro!
    Join Date: 06-13-08
    Posts: 5,487
    Betpoints: 578

    Tried the VALUE function?
    Reply With Quote Reply With Quote
  7. 10-07-15 07:16 AM #7
    Waterstpub87
    Slan go foill
    Waterstpub87's Avatar Become A Pro!
    Join Date: 09-09-09
    Posts: 4,044
    Betpoints: 7292

    I didn't. Problem solved though

    =replace(A116,3,1,.5)
    Reply With Quote Reply With Quote
  8. 10-09-15 10:19 AM #8
    HeeeHAWWWW
    HeeeHAWWWW's Avatar Become A Pro!
    Join Date: 06-13-08
    Posts: 5,487
    Betpoints: 578

    If at all possible, try to do this in R instead. I did it in Excel originally, and after a few more years and a mass of extra stats, it's become ridiculously slow and unstable.
    Reply With Quote Reply With Quote
  9. 10-09-15 06:32 PM #9
    Waterstpub87
    Slan go foill
    Waterstpub87's Avatar Become A Pro!
    Join Date: 09-09-09
    Posts: 4,044
    Betpoints: 7292

    Quote Originally Posted by HeeeHAWWWW View Post
    If at all possible, try to do this in R instead. I did it in Excel originally, and after a few more years and a mass of extra stats, it's become ridiculously slow and unstable.
    familiar with R, some people use it at work. Need to learn more about it. More familiar with VBA for now. Hope to learn more about R soon.
    Reply With Quote Reply With Quote
Top
« Previous Thread | Handicapper Think Tank | Next Thread »