Importing dividends into excel from a fixed betting site....

I end up with a column of dividends. Next column contains the amount needed to bet to return $100.
My problem is that if there is a scratching, there is a blank cell and I am trying to divide by zero.

=if(isblank(a1),,100/a1)

This formula obviously leaves a value of zero if a1 is blank. I need it to return a blank cell for other formulas to work.

I formatted the number cells to 0;-0;;@ which apparantly hides the zero but the cell still has a value.

Can anybody tell me the correct formula...?
Thankyou everybody for your time...

leave the formating to this $0.00 that is currency say cell A1 contains the blank try this
=if(A1=0.00,"",100/A1)

Thanks Shaun... Did consider that, but for some reason I had it in my head that "" left a value in the cell.... My spreadsheet is now working.

Np...you will find that the IF statemnet becomes your best friend...lol i use it all the time....i will uplaod a file containing all the stuff that i have had to search for when setting up my excels sheets for punting and getting information from sites....at this time i can get form from ozeform,cyberhorse,spotingbet and am currently working on a program to get betfair prices in real time...well trying anyways.

Attached Files

Excel help.txt (3.5 KB, 743 views)

Was just coming in to ask a question about the possibility of realtime betfair prices.... I know there is a program that does it but fairly pricey.....

well i am not 100% sure it is possible...but i can certanly read the page and put it in excel....but doing it automaticly at a rate that is of use to us...thats a different story

As far as betfair is concerned for Australian racing, the only time their prices are relevant is when they are getting matched. This is usually only the last 3-4 minutes of betting... Just not much action except for Sats....

Another question if I can pick your brain again....

When I import the odds, most of my formulas become irrelevant. For example:
$8 $12.5
$3 #Ref!
$2 #Ref!
$4 #Ref!
$5 #Ref!

The autorefresh works, but as soon as I edit the query to choose the next race, this happens...
Sorry but that is the best I can explain it... All I have to do is drag the formula from 12.5 down, but I am presuming there is a setting I can choose....

It seems to me that it is inserting new cells, therefore leaving references to what was there before irrelevant....

I do have a solution to that problem....just have to dig it up

=INDIRECT("FORM!A1")

or

=INDEX(FORM!A:A,1)

use the top one for single cells and the bottom for multiple cells

Sorry, been busy for a couple of days so am only now reading your response.
I will have a look at your suggestion and see if I can get it going. If I can't, at least now I know where to look in excel help.

Alright, so I am admitting defeat regarding those 2 formulas...

Here is now what I am trying to do....
I want to import data from ias. I am running excel 2003 so have the yellow arrows next to the tables when running a query...

The first table has fixed price divs open price, fluc1, fluc2... in 1 table...
The next has current fixed price.
Then current SP win div.
Then current SP place divs....

If I try and import these in 1 query, They are all lined up in 1 column seperated by spaces...
I want them as seen on the website. But to do this I need to run 4 different queries, and update these 4 queries every race which is no good....


I want to convert the place div to a win div ( placeDiv - 1 )*4, then add it to the fixed and SP win price to get an average win div.... This will be the market I use to find current prices.
But, by the time I have written the formula to average these, the query is updated and my formula wiped out leaving a blank cell.

How do I import these 4 tables as 1 query in the same format as seen on the website, and how do I then use this data?