How to Use Power Query to Pull Data from a CloudFlare Protected Website

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.

Continue reading

Adobe just ruined its reputation to me

I was just trying to take Adobe Acrobat Reader DC for a spin, availed of the free trial, which by the way I found to be total crap — so no use to me! It was a 1.2GB piece of crap!

Then Adobe installed a 502MB worth of Adobe Creative Cloud Desktop for me, without even my consent!

Who the hell cares about Adobe Creative Cloud? It even added a stupid shortcut in the Navigation pane in Windows File Explorer (under Quick Access).

Adobe is a joke! I’m not paying them anything! They’re a scam, fraud, con artist, swindler — errr, wait let me check my dictionary for what more bad things to describe Adobe.

Everyone, stay away from this stupid company.

Sometimes it pays to keep Index and Match to yourself

To me, Index and Match functions combined is so much better than VLookUp. But sometimes, that fact is better kept to myself rather than trying to convert others. Saves me a lot of headache.

Please, don’t get me started on XLOOKUP. Compatibility issues is a serious concern.

So, are you Team Index and Match or Team VLookUp?

Instapay now available in Security Bank mobile app

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

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.