I run Microsoft Excel’s Power Query daily in order to pull data from the BAP website for the USD/PHP rates for the day, which in turn I save in an Airtable database as a record for that day.
This week, however, it seems that BAP has implemented CloudFlare DDoS Protection, which helps it to combat DDoS attacks. Good for BAP, they can minimize what we’ve experienced downtimes in the past. Bad for me, now I’m getting 503 error in my query.
So how do we deal with this in Power Query? A quick Google search yields not much of a result. There’s one posted in June 2017 on Mr. Excel forum, 3 years and no one bothered with an answer.
We have our salaries paid through our Security Bank accounts. Since I keep funds in my accounts with other banks, I need to do fund transfers now and then. And Instapay for Security Bank would have really helped.
Today I discovered that Fund Transfer to Other banks via Instapay functionality is already added to the Security Bank mobile apps.
Security Bank transfer to other banks via Instapay.
Apparently, this functionality is available only on Android and iOS apps, but not in the web using your favorite internet browser. Nevertheless, this is a welcome development, especially now that GCash disabled cash-in via bank cards starting July 6, 2020.
Currently, as the whole nation is still technically on lockdown, all fees for Instapay transfers for all banks, including Security Bank, are waived. When things go back to normal, this fee schedule indicates that fees range from ₱10 to ₱50 among the different Philippine banks. Security Bank in particular will charge ₱15 per transaction, which is I would say is not too steep. I would argue that would be a cost worth paying for the convenience of not waiting some 30 minutes should you need to visit a branch of your bank.