General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
I am trying to convert a column of fractional odds into decimal odds but don't know how to. Is there an easy way to do this?
When I take the odds from M/soft Works to Excel it shows either as 05-Feb for all sp's at 5/2. Others are shown below.
05-Feb 5/2
09-Apr 9/4
15-Aug 15/8
09-Apr 9/4
06-Apr 6/4
07-Apr 7/4
15-Aug 15/8
07-Apr 7/4
05-Feb 5/2
Can I put in formual that will change all incorrect dates as they are now not only into the correct fractional price but the correct decimal price so that all cells that are showing 05-Feb change to 3.5.
Thank you in advance.
.
When I take the odds from M/soft Works to Excel it shows either as 05-Feb for all sp's at 5/2. Others are shown below.
05-Feb 5/2
09-Apr 9/4
15-Aug 15/8
09-Apr 9/4
06-Apr 6/4
07-Apr 7/4
15-Aug 15/8
07-Apr 7/4
05-Feb 5/2
Can I put in formual that will change all incorrect dates as they are now not only into the correct fractional price but the correct decimal price so that all cells that are showing 05-Feb change to 3.5.
Thank you in advance.
.
Show More
you can format the column to text before importing the data. This would be starting point. How does it deal with "Evens" and does the price include an F for favourite?
With the fractional odds in D2 in this example:
=LEFT(D2,FIND("/",D2,1)-1)/MID(D2,FIND("/",D2,1)+1,LEN(D2))+1
=LEFT(D2,FIND("/",D2,1)-1)/MID(D2,FIND("/",D2,1)+1,LEN(D2))+1
Lay Low thanks , I am using Excel 2007. Below are a few of my sp's with Evens shown as Evens.
13/08
02/01
05/02
02/01
11/10
Evens
13/08
09/04
Evens
13/08
Evens
11/10
02/01
Smar Tarse: Can you let me know where to paste this formula in relation to where my sp's as shown above are. What should be in D2?, thank you.
.
13/08
02/01
05/02
02/01
11/10
Evens
13/08
09/04
Evens
13/08
Evens
11/10
02/01
Smar Tarse: Can you let me know where to paste this formula in relation to where my sp's as shown above are. What should be in D2?, thank you.
.
In answer to the question directed at Smar Tarse.
Put his code in any column in the 2nd row of your spreadsheet.
the fractional odds need to be in D2
It is pretty much what I was going to suggest.
Put his code in any column in the 2nd row of your spreadsheet.
the fractional odds need to be in D2
It is pretty much what I was going to suggest.
Thanks LayLow, I tried that but couldn't make it work. I can now however get my odds to sit as normal in excel by formatting to Turkish date so they now look like below:
9/4
6/4
7/4
15/8
7/4
5/2
9/4
11/8
5/2
5/4
Not sure how evens will work but don't worry.
With this change to how the fractional odds are shown in excel will I need to change Smar Tarse's formula to make it work or is there a different one I can use?
Many thanks.
.
9/4
6/4
7/4
15/8
7/4
5/2
9/4
11/8
5/2
5/4
Not sure how evens will work but don't worry.
With this change to how the fractional odds are shown in excel will I need to change Smar Tarse's formula to make it work or is there a different one I can use?
Many thanks.
.
I can now however get my odds to sit as normal in excel by formatting to Turkish date so they now look like below:
that is why Smar tarse's code does work. The data has to text not a date.
do you know how to run VBA code?
that is why Smar tarse's code does work. The data has to text not a date.
do you know how to run VBA code?
No I am rubbish at this sort of thing but don't give up on me :-)
I need to be shown step by step if possible.
If I could start again, I have a list of odds in Microsft Works which get shown as below.
06/04
05/02
09/04
02/01
15/08
02/01
09/04
07/04
02/01
13/08
I then copy this into an empty excel sheet and the odds change to:
06-Apr
05-Feb
09-Apr
02-Jan
15-Aug
02-Jan
09-Apr
07-Apr
02-Jan
13-Aug
From here I wish the original odds to be changed and all be shown as decimal prices (5/2 = 3.5 etc)
Thanks very much.
.
I need to be shown step by step if possible.
If I could start again, I have a list of odds in Microsft Works which get shown as below.
06/04
05/02
09/04
02/01
15/08
02/01
09/04
07/04
02/01
13/08
I then copy this into an empty excel sheet and the odds change to:
06-Apr
05-Feb
09-Apr
02-Jan
15-Aug
02-Jan
09-Apr
07-Apr
02-Jan
13-Aug
From here I wish the original odds to be changed and all be shown as decimal prices (5/2 = 3.5 etc)
Thanks very much.
.
I then copy this into an empty excel sheet and the odds change to:
This is the crucial stage. Either format the column as text (right click, format cells,Text) before pasting the data into them.
or use paste special unicode text (right click, paste special, unicode text)
Then use Smar Tarse's code
This is the crucial stage. Either format the column as text (right click, format cells,Text) before pasting the data into them.
or use paste special unicode text (right click, paste special, unicode text)
Then use Smar Tarse's code
:-)
Great now I have this, thanks very much but I cannot seem to copy this new list of decimal prices and paste them either somewhere else on this excel sheet or into a new m/soft works database as it just shows the formula or #VALUE
Is there a way I can now**these new decimal prices into the cells rather than it showing the formula?
Thanks again, all much appreciated.
.
Great now I have this, thanks very much but I cannot seem to copy this new list of decimal prices and paste them either somewhere else on this excel sheet or into a new m/soft works database as it just shows the formula or #VALUE
Is there a way I can now**these new decimal prices into the cells rather than it showing the formula?
Thanks again, all much appreciated.
.
Thanks laylow, I really appreciate your help.
Seeing how clever these formulas can be, it has got me thinking.
Would it be possible to paste a comment in running into a cell such as:
CHSD LDRS: RDN OVER2F OUT
Then ask the formula to use a value of say 1 if the word 'CHSD' is found first, 2 if 'HLD UP' is found, 3 if 'PROM' is found or whatever so that running style values could be kept on a database for each horse?
.
Seeing how clever these formulas can be, it has got me thinking.
Would it be possible to paste a comment in running into a cell such as:
CHSD LDRS: RDN OVER2F OUT
Then ask the formula to use a value of say 1 if the word 'CHSD' is found first, 2 if 'HLD UP' is found, 3 if 'PROM' is found or whatever so that running style values could be kept on a database for each horse?
.
panic
Out of curiosity are you downloading your data from horseracebase.com?
Out of curiosity are you downloading your data from horseracebase.com?
No I am just playing with some download results from Raceform Interactive.
.
.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539