Go Back  FlyerTalk Forums > Miles&Points > Airlines and Mileage Programs > Air Canada | Aeroplan
Reload this Page >

Unofficial Advanced AC Reward Search Tool with Calendar (aka cowtool)

Old Jul 19, 21, 10:34 pm
FlyerTalk Forums Expert How-Tos and Guides
Last edit by: canadiancow
https://acrewardsearcher.cowtool.com/

Due to abuse, you must now first register (see https://www.cowtool.com, and read the rest of this wiki) and sign in to use it. All access is logged (not what you're searching, but the complexity of the searches, and the number of searches). Abusers will be throttled or terminated. Continued abuse will lead to a more involved registration process, up to and including personal vetting by canadiancow.

Access to this cowtool for new users is temporarily disabled due to anticipated ("I'm going to make a big blog post") publicity and actual increases in usage. This is not free for me, and I am concerned what will happen if all the US major blogs pick it up.

If anyone "new" needs an account here, as long as you have 25 posts and your account is at least 3 months old, please register for a cowtool account, and then PM me (please include your email address) and I'll set you up with reward search access. And I will read your posts, so don't spam FT with crap please. If you have a genuine interest in travel, points, and so on, it really isn't hard to make 25 contributive posts to FlyerTalk and be eligible for access. If you do not meet this threshold, I am not making an exception for you. Not because you live in SFO like me, not because you're really excited, and not because of any personal issues. In fact, if you PM me with 15 posts, and I ignore it, and then you PM me with 30 posts a few weeks later, don't expect a response. Moderator note: the rules for access are very clear. Please don't post in this thread, or anywhere else, asking how you can get access. Those posts will be deleted.

I do not process PMs instantly. My goal is at least once per week, so it may take a few days.

Additionally, any Prince of Travel Platinum or Royal Platinum members may contact me over POT Discord for access.

Alerts
Basic price alerts are currently in available to all registered users. Full search/availability alerts are in...alpha.
Each account is limited to 4 alerts* for now.

A price alert is set on a specific itinerary that includes AC metal (this may be expanded as we begin to see EK dynamic pricing). The general idea is that you making a booking at price X, set an alert, and then if the price drops, you'll get an email, and can rebook the itinerary at a lower price and cancel the old, more expensive, booking. This really only works well if you're SE or booked a fare with no cancellation fee. All results with AC flights will show a "Price alert" link on the right. Clicking this will add one. You can view all your alerts in the alerts section, where you can delete them, or select two one-way alerts to merge into a round-trip alert, which will determine the current round-trip price and reset the alert level (since round-trip pricing is not the sum of the two one-ways).

The following is crossed out pending a potential opening of availability alerts, which would likely have similar restrictions.
If you have at least 2500 FT posts and would like access to the beta, send me a PM including the email you used to sign up for cowtool. There are currently no exceptions on the post count restriction. I am trying to slowly roll this out, and need an easy way to expand access, ideally to people who have contributed to FT a lot. The threshold will be decreased over time.

* Due to the fact that a round-trip alert requires making and then merging two alerts, the technical limit is 5, but I'm advertising it as 4.

Having Trouble? Hold "shift" and click the refresh button.

Feature Requests:
  • Allowing filtering/alerting by brand
  • Option to launch AC.com in new tab should be saved to your account
  • Show more information about stops, such as the time
  • Finish and release alerts
  • "Copy into round-trip alert" instead of "merge into" in case you want both
  • Save filters to profile
  • Historical prices
  • Colored background gradiated by %age of mixed cabin. Solid green if 100%, fading to white as percentage drops...
  • Option to enable a priority reward discount
  • Populate filter checkboxes from deep links
  • Lie-flat filter (maybe with lie-flat % filter as well?) - Unsure if this data is easily accessible
  • +/- 1 or 2 days dropdown if entering a single value for date at top, grayed out if entering more than one date or range
  • filter option to set latest arrival date & time (cow likes this)

Bugs:
  • Reset password doesn't seem to work (though this has definitely gotten much better - if I made an account for you manually right after I started doing that, it may not work because I didn't understand the limitations, so I can help with that on one-off cases... it should work if it's a more recent creation)
Print Wikipost

Unofficial Advanced AC Reward Search Tool with Calendar (aka cowtool)

Old Jun 22, 21, 7:57 pm
  #91  
A FlyerTalk Posting Legend
Original Poster
 
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, UA Gold, Bonvoy Tit LT Sil, Hyatt Glob, HH Diamond, Accor Silver
Posts: 41,080
Originally Posted by jerryhung View Post
Q2 - I wonder if it's easy to generate a "filter/sort included URL"? so we don't have to re-do it every time. It can be done via a button or something?
I know right now the URL only contains the search parameters - date, origin/destination

e.g. https://api.ft.canadiancow.com/ac-re...7-31&airlines=
but say if I want to save the filter, like 50K points, Economy (Y), and order by Duration ASC (to find nonstop easily), is it hard to do?
I brought my laptop to a bar (Ungrafted) because I was ... ready to stop working for the day.

I made various tweaks to the tool, including adding the backend for your suggestion (i.e. https://api.ft.canadiancow.com/ac-re...eparture=22:00 )

I haven't built the front-end yet, but the champagne is kicking in, so it might have to wait until tomorrow.
jerryhung likes this.
canadiancow is offline  
Old Jun 22, 21, 8:35 pm
  #92  
 
Join Date: Jul 2008
Location: YVR
Programs: OZ Diamond, Jiffypark Manhattan Gold
Posts: 4,445
Dude...this is awesome, the sheer speed at which it searches it fantastic. You definitely don't need me to tell you I'm impressed, but I'm impressed! Sure there's not much GUI to look at lol, but who cares, it gets the job done!

I see the "are you booking through a partner" thing. I tried that but didn't really see a change. So is this exclusively an AP tool? Either way very useful. Honestly I used to use Expertflyer and was ok paying the sub fee as long as I was travelling. I have points spread across multiple programs so it helps with that cuz some of their websites absolutely suck (COUGH SQ) but something as simple as this would actually make me lean towards accumulating AC points with a purpose again. I still won't credit all my earnings there, cuz I won't make elite, but if a really good sale of miles comes up or whatnot, I won't hesitate to lump more points in. Many thanks!
canadiancow likes this.
drvannostren is offline  
Old Jun 22, 21, 8:55 pm
  #93  
A FlyerTalk Posting Legend
Original Poster
 
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, UA Gold, Bonvoy Tit LT Sil, Hyatt Glob, HH Diamond, Accor Silver
Posts: 41,080
Originally Posted by drvannostren View Post
I see the "are you booking through a partner" thing. I tried that but didn't really see a change. So is this exclusively an AP tool?
Search YYZ-YVR and compare the results to AC's website and UA's website. Unchecking that box definitely removes a ton of AC-operated itineraries.

To clarify something though, this will only show availability that can be booked through AC. You won't see SQ F or UA IN, etc.
Adam Smith and kalderlake like this.
canadiancow is offline  
Old Jun 23, 21, 1:28 am
  #94  
 
Join Date: Jul 2008
Location: YVR
Programs: OZ Diamond, Jiffypark Manhattan Gold
Posts: 4,445
Originally Posted by canadiancow View Post
Search YYZ-YVR and compare the results to AC's website and UA's website. Unchecking that box definitely removes a ton of AC-operated itineraries.

To clarify something though, this will only show availability that can be booked through AC. You won't see SQ F or UA IN, etc.
Alright thanks, now if only the airlines themselves just went with something like this!
drvannostren is offline  
Old Jun 23, 21, 9:50 am
  #95  
 
Join Date: Mar 2012
Location: London UK
Programs: AC 75K; HHonors Diamond; IHG Diamond; Bonvoy Gold;
Posts: 9
Originally Posted by canadiancow View Post
Search YYZ-YVR and compare the results to AC's website and UA's website. Unchecking that box definitely removes a ton of AC-operated itineraries.

To clarify something though, this will only show availability that can be booked through AC. You won't see SQ F or UA IN, etc.
First of all, this tool is AMAZING. So fast, convenient, flexible and intuitive. Kudos.

One question -- I'm not able to align results using the "(NOT) booking with Aeroplan" filter with actual availability on partner airlines. For example, the following search yields three, J-class, YYZ-LHR non-stops with availability for two passengers on Sep 21, 26 and 27. But checking availability on UA or ANA yields nothing for the entire month of September.

api.ft.canadiancow.com/ac-rewardsearcher/ac-rewardsearcher?pax=2&origins=YYZ&destinations=LHR& dates=2021-09-21%3A2021-09-30&airlines=AC

Having read a million posts on this forum, I'm still confused about how Aeroplan signals AC award availability for partner airlines? I understand that it's no longer linked to Aeroplan points, as these are now dynamic and no longer linked to award class. But are their still AC award classes (X, I), and if so: how does this tool detect? (And a related question, why can't Expert Flyer detect any longer?)

Thanks again for all your work on this, and for sharing. And thanks to everyone for any insights on my questions!
dirkhotel is offline  
Old Jun 23, 21, 12:32 pm
  #96  
A FlyerTalk Posting Legend
Original Poster
 
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, UA Gold, Bonvoy Tit LT Sil, Hyatt Glob, HH Diamond, Accor Silver
Posts: 41,080
Originally Posted by dirkhotel View Post
First of all, this tool is AMAZING. So fast, convenient, flexible and intuitive. Kudos.

One question -- I'm not able to align results using the "(NOT) booking with Aeroplan" filter with actual availability on partner airlines. For example, the following search yields three, J-class, YYZ-LHR non-stops with availability for two passengers on Sep 21, 26 and 27. But checking availability on UA or ANA yields nothing for the entire month of September.

api.ft.canadiancow.com/ac-rewardsearcher/ac-rewardsearcher?pax=2&origins=YYZ&destinations=LHR& dates=2021-09-21%3A2021-09-30&airlines=AC

Having read a million posts on this forum, I'm still confused about how Aeroplan signals AC award availability for partner airlines? I understand that it's no longer linked to Aeroplan points, as these are now dynamic and no longer linked to award class. But are their still AC award classes (X, I), and if so: how does this tool detect? (And a related question, why can't Expert Flyer detect any longer?)

Thanks again for all your work on this, and for sharing. And thanks to everyone for any insights on my questions!
Okay I guess that option needs more work.

This is, first and foremost, a tool for searching out Aeroplan bookings 🤷
canadiancow is offline  
Old Jun 25, 21, 10:28 am
  #97  
 
Join Date: May 2014
Posts: 14
Originally Posted by canadiancow View Post
I brought my laptop to a bar (Ungrafted) because I was ... ready to stop working for the day.

I made various tweaks to the tool, including adding the backend for your suggestion (i.e. https://api.ft.canadiancow.com/ac-re...eparture=22:00 )

I haven't built the front-end yet, but the champagne is kicking in, so it might have to wait until tomorrow.
Any chance to open-source the front-end so we can help with it? I've been using it frequently for myself and to help others book and I want to help improve it so it's easier to use for everyone.
thedoraemon is offline  
Old Jun 25, 21, 12:44 pm
  #98  
A FlyerTalk Posting Legend
Original Poster
 
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, UA Gold, Bonvoy Tit LT Sil, Hyatt Glob, HH Diamond, Accor Silver
Posts: 41,080
Originally Posted by thedoraemon View Post
Any chance to open-source the front-end so we can help with it? I've been using it frequently for myself and to help others book and I want to help improve it so it's easier to use for everyone.
It would take a fair bit of work to split them apart at this point. I hacked this together without thinking too much about the architecture.

All it really needs is some auto-updating link that changes whenever any input fields change, which even for me, shouldn't be too bad. One of these days...

Maybe my next project should be separating the front from the back though.
canadiancow is offline  
Old Jul 13, 21, 6:51 pm
  #99  
 
Join Date: Jul 2021
Posts: 1
This is a great tool, thanks so much for putting it together, it is extremely helpful.
canadiancow likes this.

Last edited by aviator5; Jul 13, 21 at 7:53 pm
aviator5 is offline  
Old Jul 16, 21, 9:12 pm
  #100  
 
Join Date: Jun 2021
Posts: 14
This is excellent! Thanks for sharing!
canadiancow likes this.
hermesN is offline  
Old Jul 16, 21, 9:19 pm
  #101  
A FlyerTalk Posting Legend
Original Poster
 
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, UA Gold, Bonvoy Tit LT Sil, Hyatt Glob, HH Diamond, Accor Silver
Posts: 41,080
Seems like there's an issue where sometimes the AC.com link takes you to the wrong date. I'll try to get that fixed sometime in the next 24 hours.

Edit: Fixed

There was an assumption that every search response would be returned in the order they went out, which was definitely not true.

Last edited by canadiancow; Jul 17, 21 at 12:24 am
canadiancow is offline  
Old Jul 17, 21, 2:59 am
  #102  
 
Join Date: Mar 2017
Location: USA
Programs: AA Gold, Hyatt Globalist, Hilton Diamond
Posts: 291
I just wanted to thank @canadiancow for this amazing tool. It really saved my hide when salvaging a legacy mRTW over a lengthy phone call with the "lovely" Aeroplan help desk.
canadiancow and Adam Smith like this.
milesforhire is offline  
Old Jul 17, 21, 2:50 pm
  #103  
A FlyerTalk Posting Legend
Original Poster
 
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, UA Gold, Bonvoy Tit LT Sil, Hyatt Glob, HH Diamond, Accor Silver
Posts: 41,080
I don't know what happened a week ago, but this wasn't getting too much usage before then. If this keeps up I guess I'll have to implement free user accounts and rate limiting.

canadiancow is offline  
Old Jul 17, 21, 2:52 pm
  #104  
 
Join Date: Apr 2018
Location: Ontario Canada
Programs: Air Canada 50K - Hilton Diamond - Marriott Platinum
Posts: 252
Originally Posted by canadiancow View Post
I don't know what happened a week ago, but this wasn't getting too much usage before then. If this keeps up I guess I'll have to implement free user accounts and rate limiting.

Prince of Travel mentioned it in a livestream
canadiancow likes this.
Aselwyn is offline  
Old Jul 17, 21, 4:46 pm
  #105  
A FlyerTalk Posting Legend
Original Poster
 
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, UA Gold, Bonvoy Tit LT Sil, Hyatt Glob, HH Diamond, Accor Silver
Posts: 41,080
Originally Posted by Aselwyn View Post
Prince of Travel mentioned it in a livestream https://youtu.be/GVOm78Y8C0A?t=2360
Thanks. I'm glad I watched that. I saw a YYZ-EWR (F) -BOM (J) that listed as 96% mixed cabin because "F". I need to fix that.
milesforhire and Aselwyn like this.
canadiancow is offline  

Thread Tools
Search this Thread