• Free API Moscow Stock Exchange (MOEX) in Google Sheets

      Last year the number of private investors at Moscow Stock Exchange (MOEX) has doubled and reached 3.86 million: about 1.9 million people have opened accounts at MOEX in 2019. The Saint Petersburg Stock Exchange which specializes in trading of foreign company shares has seen its accounts increase three times from 910,000 to 3,06 million over the past year.



      This means that almost 2 million newbies without any actual trading experience and lacking any specialized software for trading/position analysis have entered the market.
      Read more →
    • How to receive data from Google Analytics using R in Microsoft SQL Server

      • Tutorial

      In this article I want to show in detail how you can use R in Microsoft SQL Server to get data from Google Analytics (and generally from any API).


      The task — we have MS SQL server and we want to receive data in DWH by API


      We will use googleAnalyticsR package to connect to Google Analytics (GA).


      This package is chosen as an example due to its popularity. You can use another package, for example: RGoogleAnalytic.
      Approaches to problem solving will be the same.

      Read more →
    • Google+ is Dead. So what?

        Google shut down their social media platform Google+ on April 2, 2019. It’s hard to find some technical article that hasn’t mentioned the end of Google’s social network era. But, a high level of consistency in connectivity within services of the company had received scant attention. In this article I would like to share my thoughts on the internal way of Google services consistency and what it means for Google API users when it comes to a Google+ shutdown.

        Read more →
      • How I discovered an easter egg in Android's security and didn't land a job at Google

        • Translation
        Google loves easter eggs. It loves them so much, in fact, that you could find them in virtually every product of theirs. The tradition of Android easter eggs began in the very earliest versions of the OS (I think everyone there knows what happens when you go into the general settings and tap the version number a few times).

        But sometimes you can find an easter egg in the most unlikely of places. There’s even an urban legend that one day, a programmer Googled “mutex lock”, but instead of search results landed on foo.bar, solved all tasks and landed a job at Google.

        Reconstruction
        image

        The same thing (except without the happy ending) happened to me. Hidden messages where there definitely couldn’t be any, reversing Java code and its native libraries, a secret VM, a Google interview — all of that is below.
        Read more →