Community
Wiki Posts
Search

mileage run program

Thread Tools
 
Search this Thread
 
Old Mar 28, 2009 | 10:33 pm
  #1  
Original Poster
All eyes on you!
15 Years on Site
 
Join Date: May 2008
Location: Minneapolis
Programs: AA EXP, Hyatt Diamond, SPG Gold, GlobalEntry, Admirals Club, United Club
Posts: 2,095
mileage run program

i was wondering if anyone knew of any mileage run program or site that would allow someone to simply pick an airport, and find the lowest cpm on united from that airport.

someone created an excel sheet similar to that in the *wood forum. if this doesnt exist yet, does anyone know if it would be possible? and if it is, how it could be done? it doesn't really seem like it would be that difficult. i would be willing to provide a server to run it on if someone knows how to do it.
jetsfan92588 is offline  
Old Mar 28, 2009 | 10:40 pm
  #2  
A FlyerTalk Posting Legend
20 Countries Visited
2M
50 Countries Visited
20 Years on Site
 
Join Date: Apr 2004
Location: GVA (Greater Vancouver Area)
Programs: D.R.E.A.D. Gold card holder
Posts: 53,219
Originally Posted by jetsfan92588
if this doesnt exist yet, does anyone know if it would be possible?
Fares change daily and sometimes more often than that.
mahasamatman is offline  
Old Mar 28, 2009 | 10:41 pm
  #3  
All eyes on you!
15 Years on Site
 
Join Date: Jul 2006
Location: ATL
Programs: DL, AA
Posts: 6,033
It's a bit complicated given how often airfares changes and how many destinations/routing you can devise. Not to mention fuel surcharges and taxes.

However, farecompare has a page that does sort of what you are looking for:
http://www.farecompare.com/search/fl...sortby=ppm&p=1
scoow is offline  
Old Mar 28, 2009 | 10:42 pm
  #4  
Original Poster
All eyes on you!
15 Years on Site
 
Join Date: May 2008
Location: Minneapolis
Programs: AA EXP, Hyatt Diamond, SPG Gold, GlobalEntry, Admirals Club, United Club
Posts: 2,095
i know, i was thinking about having it update with the change in fares like somehow connect to united to get those fares. somehow expedia, priceline, kayak, etc... have the fares updated instantaneously. i am not a coder, and do not know if this would be possible without united's permission. i was just curious if it was
jetsfan92588 is offline  
Old Mar 28, 2009 | 10:44 pm
  #5  
A FlyerTalk Posting Legend
20 Countries Visited
2M
50 Countries Visited
20 Years on Site
 
Join Date: Apr 2004
Location: GVA (Greater Vancouver Area)
Programs: D.R.E.A.D. Gold card holder
Posts: 53,219
It's akin to the Traveling Salesman Problem.
mahasamatman is offline  
Old Mar 28, 2009 | 11:04 pm
  #6  
 
Join Date: May 2008
Location: SFO / SJC
Programs: UA 1P
Posts: 391
I have been doing some tinkering on this.

I wrote some perl code to take fare routing rules and come up with all possible routes. (Hopefully. UA's routing rules are so many lines long, but by using the timetable to trim down bogus routings it seems to process in reasonable time.) Then I have code that sorts those routes by distance and finally it looks through the timetable (using the published pdf timetable which I parse in) to find which routes one can actually fly. (Would be fun to play around with interesting constraints like equipment type, etc.)

Still it has got some issues though. But if there is interest I will keep working on it. I noticed it seems that AA uses an almost identical timetable format, so maybe the code won't have to be limited to UA but could also be expanded to the dAArkside.

One hang-up is that I am not sure where routing rules for fares can be found anymore. Farecompare, as mentioned by others is a great starting point for find good fares. I wanted to simply be able to go one step further once I had a specific fare and route in mind, to find the best flights. Eventually having those flights, it is a piece of cake to have ITA check availability using another script (to generate the ITA syntax to find those exact flights, etc.) which I toyed around with.

Sorry if this message is a bit incoherent or poorly written. I have a really bad head flu right now. It made my 5 segment transcon flight rather miserable.
SFOtoBOS is offline  
Old Mar 28, 2009 | 11:21 pm
  #7  
 
Join Date: Oct 2008
Programs: UA 1K, AA Plat, SPG Platinum, National Executive
Posts: 1,970
It would be really easy if you just compile a list of every airport code you know of in the form:

lax; sfo; ord; iad; den; bos; ewr; jfk; lga; mht; sba; sea; mia; tpa; smf; ont; san;

and copy and paste it into ITA.

There, I even got the list started...people can go ahead and add to the list

PS - I wonder if ITA has a limit...

EDIT - yes, there is a limit. I got to "ATY"...

Last edited by UAX_Brasilia; Mar 28, 2009 at 11:46 pm
UAX_Brasilia is offline  
Old Mar 28, 2009 | 11:34 pm
  #8  
 
Join Date: May 2008
Location: SFO / SJC
Programs: UA 1P
Posts: 391
Originally Posted by UAX_Brasilia
It would be really easy if you just compile a list of every airport code you know of in the form:

lax; sfo; ord; iad; den; bos; ewr; jfk; lga; mht; sba; sea; mia; tpa; smf; ont; san;

and copy and paste it into ITA.

There, I even got the list started...people can go ahead and add to the list

PS - I wonder if ITA has a limit...
ITA has a limit on how much searching it will do. Ask a better question and it gives you a better answer. The more refining of the problem you do before turning to ITA the better. If you know you want to be on United metal, then using ITA is not the best option, except maybe to check fare bucket availability for specific flights on specific dates, but clearly others may be able to suggest even better ways to do that.
SFOtoBOS is offline  
Old Jan 10, 2012 | 2:00 am
  #9  
10 Years on Site
 
Join Date: Dec 2011
Location: New Orleans on a sabattical. My roots are in Los Angeles.
Programs: Chase Palladium, AMEX Plat, UA Plat, AA EXP, HH/SPG G, PC plat
Posts: 340
Originally Posted by SFOtoBOS
I wrote some perl code to take fare routing rules and come up with all possible routes. (Hopefully. UA's routing rules are so many lines long, but by using the timetable to trim down bogus routings it seems to process in reasonable time.) Then I have code that sorts those routes by distance and finally it looks through the timetable (using the published pdf timetable which I parse in) to find which routes one can actually fly. (Would be fun to play around with interesting constraints like equipment type, etc.)

SFOtoBos; any chance you can share that perl code?
rizwank is offline  
Old Jan 11, 2012 | 11:15 am
  #10  
30 Countries Visited
40 Countries Visited
50 Countries Visited
10 Years on Site
 
Join Date: Sep 2011
Posts: 17
Would be interested as well....
tnbt is offline  
Old Jan 11, 2012 | 12:10 pm
  #11  
 
Join Date: Apr 2010
Location: SEA
Programs: AS MVP 75K, DL Diamond, LH SEN, Hyatt Globalist, Marriott Ambassador
Posts: 2,360
Originally Posted by rizwank
SFOtoBos; any chance you can share that perl code?
Originally Posted by tnbt
Would be interested as well....
You're replying to a thread from 2009. Also, SFOtoBOS hasn't been active on FT since October 2010.
BryanIAH is offline  


Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

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.