General Betting
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.
.
sort by:
Show
per page
Replies: 15
|
By:
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?
|
|
By:
and what version of Excel are you using?
|
|
By:
With the fractional odds in D2 in this example:
=LEFT(D2,FIND("/",D2,1)-1)/MID(D2,FIND("/",D2,1)+1,LEN(D2))+1 |
|
By:
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. . |
|
By:
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. |
|
By:
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. . |
|
By:
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? |
|
By:
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. . |
|
By:
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 |
|
By:
:-)
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. . |
|
By:
You can copy them using paste special, values
|
|
By:
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? . |
|
By:
panic
Out of curiosity are you downloading your data from horseracebase.com? |
|
By:
No I am just playing with some download results from Raceform Interactive.
. |
|
By:
OK.
Thanks. |