FlyerTalk Forums

FlyerTalk Forums (https://www.flyertalk.com/forum/index.php)
-   oneworld (https://www.flyertalk.com/forum/oneworld-411/)
-   -   Updated source for xONEx prices by starting location? (https://www.flyertalk.com/forum/oneworld/818227-updated-source-xonex-prices-starting-location.html)

Nobby Apr 28, 2008 7:34 pm

Updated source for xONEx prices by starting location?
 
All of the price lists I've been able to find for xONExs on FlyerTalk and elsewhere are at least a year or two old. Is there a recent (last few months) version out there, or some other way of finding out prices by starting location?

I'm buying a LONE5 for a trip I'll be starting in Australia. But I could easily use points to get me to a starting location in East Asia, and go from there. I would want to go from somewhere in Southeast/Northeast Asia though, not say Sri Lanka or India, because I can't afford to waste a segment -- I need all 20 of them! I'll be going to a number of places in Southeast Asia and China/Japan, so are starting point somewhere in those areas wouldn't waste a segment.

Thank you very much!

Kiwi Flyer Apr 28, 2008 7:50 pm

The oneworld website now produces this info (in local currency).

pandaperth Apr 28, 2008 8:19 pm


Originally Posted by Nobby (Post 9647737)

But I could easily use points to get me to a starting location in East Asia, and go from there. .... I'll be going to a number of places in Southeast Asia and China/Japan, so a starting point somewhere in those areas wouldn't waste a segment.

Don't forget that you are allowed only two stopovers in the continent of origin; so if you start in Asia....

In any case, the fares differences for LONE* tickets are not that signficant

Mwenenzi Apr 28, 2008 8:29 pm


Originally Posted by Kiwi Flyer (Post 9647793)
The oneworld website now produces this info (in local currency).

Link here. Purchasing through AA and not QF saves a lot of $ in fuel surcharges. Several threads on this in FT & AFF

20 segments *ONE* must be ticketed before end of May. 16 segments after that

moa999 Apr 28, 2008 9:37 pm

See this thread for SWP LONEs.
http://www.flyertalk.com/forum/showthread.php?t=817554

I am using the last version of the WearyBiz spreadsheet and have manually updateed SWP locations recently. Australia is cheap for LONEs. NZ might be slightly cheaper but it would cost you the difference just to get there

Viajero Apr 29, 2008 4:43 am


Originally Posted by Nobby (Post 9647737)
...I'll be going to a number of places in Southeast Asia and China/Japan...

Then I agree with pandaperth's warning and would go even further: with that itinerary you should not be considering Asia as a continent of origin.

WearyBizTrvlr Apr 29, 2008 7:11 pm

As it happens, I have just updated my RTW fares spreadsheet. Corrections and comments are welcome.

moa999 Apr 29, 2008 7:49 pm

WearyBiz,

Japan DONE4 should be Yen 780400 (OW website is wrong)

Sri Lanka needs to be fully updated (now much more expensive)
AONEx LKR 1150400 1274000 1436500 1623100
DONEx LKR 674100 768600 883800 1006500
LONEx LKR 303200 361800 416300 479900

Other that have moved:
Australia, Bahrain, Bangladesh, Canada, China, Hong Kong, Indonesia...

Am wondering if my server is caching your old spreadsheet
(pulling 1.9.9c - OW data updated 10 Feb 07)

Deslok Apr 29, 2008 9:30 pm

Nice to see my nice and cheap Korea price up near the top, makes me feel oh so nice now that I've purchased the ticket. And thanks to the various folks who helped me with some of the questions I had(ended up call the AA rtw desk, and they were great, got me all set up, including where I could easily go in Seoul to pay for the ticket).

Kiwi Flyer Apr 29, 2008 10:44 pm


Originally Posted by WearyBizTrvlr (Post 9653504)
As it happens, I have just updated my RTW fares spreadsheet. Corrections and comments are welcome.

Thanks WearyBizTrvlr ^

WearyBizTrvlr Apr 29, 2008 11:10 pm

moa999, you should be getting version 2.0, updated 25 April 2008. It may indeed be a caching issue. If the normal link does not work, try http://qsi.cc/users/wbt/RTWFares2.0.xls. That should get you direct access to the latest file.

RTW4 Apr 30, 2008 4:16 am

First of all thanks for all the hard work.. I am pleased to learn that MRU is still available at the prices listed. I was going to begin a AONE5 from JNB or CPT and will now reconsider...

tourguide May 1, 2008 12:55 pm

I am also looking to buy an AONE5. I looked at the fares displayed on
the oneworld website to compare Mauritius with South Africa.
For Mauritius i find MUR 215000, which is according to www.xe.com
eur 5352.33 today and for South Africa ZAR 66000, which is eur 5609.85.
How come the spreadsheet shows eur 4179 ex Mauritius?
I opted for South Africa as there is the AA office (less surcharges) and
also because i thought the service charge is much lower in South Africa.
So this would even out with Mauritius.
But if anyone can confirm to me that the spreadsheet is correct for MRU,
i will call them right now!!!

Viajero May 1, 2008 1:09 pm


Originally Posted by tourguide (Post 9662618)
I am also looking to buy an AONE5. I looked at the fares displayed on
the oneworld website to compare Mauritius with South Africa.
For Mauritius i find MUR 215000, which is according to www.xe.com
eur 5352.33 today and for South Africa ZAR 66000, which is eur 5609.85.
How come the spreadsheet shows eur 4179 ex Mauritius?
I opted for South Africa as there is the AA office (less surcharges) and
also because i thought the service charge is much lower in South Africa.
So this would even out with Mauritius.
But if anyone can confirm to me that the spreadsheet is correct for MRU,
i will call them right now!!!

It looks like the spreadsheet is incorrect; ExpertFlyer shows AONE5 ex-MRU as 5333 EUR.

serfty May 1, 2008 1:17 pm


Originally Posted by Viajero (Post 9662709)
It looks like the spreadsheet is incorrect; ExpertFlyer shows AONE5 ex-MRU as 5333 EUR.


Originally Posted by WearyBizTrvlr (Post 9654413)
moa999, you should be getting version 2.0, updated 25 April 2008. It may indeed be a caching issue. If the normal link does not work, try http://qsi.cc/users/wbt/RTWFares2.0.xls. That should get you direct access to the latest file.

The spreadsheet from that alternative link shows ex mRU AONE5 as MUR172,186.

moa999 May 1, 2008 6:22 pm

To see the input sheets (ie Raw Data)

Format->Sheet->Unhide then Unhide the OWData sheet.

Inputed prices are contained in Columns E through P.

What strikes me is that there are a number of countries that appear to have odd inputs (ie decimal points), whereas by and large according to the OW website flights are price in Round Numbers. Unsure what WearyBiz's source for the data was.

If I go through and check the data with the OW website database for the cheap DONE4 fares - Mauritius and Syria increases quite a bit, Namibia, Pakistan and Indonesia slightly. OW provides no prices on Malawi, Iran, Amenia, Azerbijian, Georgia

So for prices (as from OW website and currency today) excluding those with no prices I get the following

DONEs in USD
Code:

                  DONE3        DONE4        DONE5        DONE6
South Africa                5,265        5,970        6,985
Namibia                          5,667        6,123        6,787
Mauritius                6,083        6,877        8,010
Ukraine            5,850        6,500        7,550        8,700
Pakistan          5,852        6,589        7,578        8,715
Korea            5,623        6,702        7,703        8,690
Indonesia        5,928        6,779        7,725        8,630
Saudi Arabia        5,939        6,817        7,696        8,575
Gibraltar          6,140        6,932        7,724        8,913
Africa                        7,000        7,600        8,200  (includes Angola, Ethiopa, Ghana, Kenya, Nigeria, Tanzania, Uganda, Zimbabwe)
Philippines        6,134        7,022        8,001        8,925
Syrian Arab R.        6,074        7,041        8,283        9,923
Sri Lanka        6,242        7,117        8,183        9,320

AONEs in USD

Code:

                      AONE3        AONE4        AONE5        AONE6
South Africa                6,852        8,698        10,121
Mauritius                    7,103        8,123        9,257
Namibia                    8,142        8,924        9,575
Saudi Arabia        7,936        9,081        10,226        11,398
Ukraine            8,650        9,300        10,900        11,900
Indonesia        8,198        9,370        10,670        11,948
Africa                    9,400        10,100        11,300
Philippines        8,481        9,734        11,088        12,390
Syrian Arab R.        8,559        9,801        11,459        12,701
Jordan            8,705        9,969        11,654        12,918
Korea            8,783        9,987        11,476        13,197
Israel            8,800        10,000        11,700        13,000


WearyBizTrvlr May 2, 2008 2:10 am

Ouch, back to the drawing board it is... I'll try to get the mispricings fixed shortly.

Gardyloo May 2, 2008 2:32 am

Notwithstanding any glitches, this is magnificent work, WBT. Heaps of praise and thanks be upon you.

moa999 May 2, 2008 2:33 am

Weary send me a PM with your email address and I can send you my partially updated spreadsheet...

AND I agree with the comments above that this IS nonetheless a hugely useful resource

pandaperth May 2, 2008 5:59 am


Originally Posted by Gardyloo (Post 9665566)
Notwithstanding any glitches, this is magnificent work, WBT. Heaps of praise and thanks be upon you.

Second that

WearyBizTrvlr May 2, 2008 10:45 am

Thank you all for your kind words.

I have uploaded a corrected version that is much closer to moa999's numbers here. I think I found the glitch... for those afflicted by caching problems, the direct link is http://qsi.cc/users/wbt/RTWFares2.0.1.xls.

One more conference call and it's all South African wines for me tonight. :)

ReelChief May 2, 2008 11:37 am

Thanks from me too. I have found your past work very useful and am happy to see the update. It is much appreciated.

Kiwi Flyer May 2, 2008 2:27 pm

OW useful reference links is updated for the new version.

nomoreiphone Jan 10, 2009 8:41 pm

Hi there,

just wondering is there an update to this excel fare sheet. Given the changes in USD, I think a direct calc from oanada will be really useful

thanks

Is it possible to also linking the Oneworld prices directly into the sheet (given they seem to increase their prices without much notice)


All times are GMT -6. The time now is 11:20 pm.


This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.