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?