Excel Help

[Waterstpub87]

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?

[nash13]

You can do a macro which replaces that expression with -1.5

[Waterstpub87]

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.

[Thunderground]

have you tried resetting the column from 'fraction' to 'number'? Those options are under 'general'.

[Waterstpub87]

Yes. Excel does not recognize the output as a number, so changing the number format will not work.

[HeeeHAWWWW]

Tried the VALUE function?

[Waterstpub87]

I didn't. Problem solved though

=replace(A116,3,1,.5)

[HeeeHAWWWW]

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.

[Waterstpub87]

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.