You can now download my Nintendo earnings FY3/22 Python code from GitHub (Up: mobile-friendly output done)

ggx2ac · Mar 3, 2022

Link to the GitHub repository:

GitHub - r134x7/nintendo-earnings-data-and-other-video-game-companies: Ever-evolving personal project. Started out in the repo as Python scripts, now it is TypeScript Front-end React App. For displaying financial information of video game companies t

Ever-evolving personal project. Started out in the repo as Python scripts, now it is TypeScript Front-end React App. For displaying financial information of video game companies that provide adequa...

github.com

Link to the Folder for Nintendo earnings FY3/22:

nintendo-earnings-data-and-other-video-game-companies/Nintendo/Nintendo FY3-2022 at main · r134x7/nintendo-earnings-data-and-other-video-game-companies

Ever-evolving personal project. Started out in the repo as Python scripts, now it is TypeScript Front-end React App. For displaying financial information of video game companies that provide adequa...

github.com

From 2018 to 2021 I had all my Nintendo earnings code in Java, then I built new code from scratch in Python which was only a few months ago and was used for the first time in the following thread (other than updating the historical earnings data thread): https://www.installbaseforum.com/fo...-hardware-q3-10-67m-7-78-yoy-103-54m-ltd.534/

I am not looking for collaborators for my code, I just needed something for my portfolio. The code is out there now but I still have to improve it, for example, at least two files have 1800 and 2400 lines of code respectively.

My first priority will be to make it more readable for anyone that wants to use the code for themselves, I have finished updating the comments on one file (mentioned above) so there is only five to go.

Whether I will have time to improve the code so that my files don't use 2400 lines of code is another matter.

What can you do with this code? You could apply some of these files to other gaming companies when they have their earnings results such as Capcom and Bandai Namco to make threads here.

What do you need to use to run this code? You can download a Python terminal from https://www.python.org/ or...... you can download Visual Studio Code which is probably highly recommend for something more approachable and then when you're in VS Code you can download the latest version of Python via extensions: https://code.visualstudio.com/

For those unaware, I wrote all this code (which is now the old code) on a smartphone (even the Java code) so if you're looking to program on your phone then you can download Android app "Pydroid 3 - IDE for Python 3" and run the code on that.

There are plenty of free online resources if you are looking to learn how to use the code, some things you'll need to understand are: strings, floats, variables, arrays, operators, if statements and printing to name a few. (And now for loops and functions)

Do you need a GitHub account to go and clone the repository? No, if you just want to grab the code you can view the file and there's a raw option, click that and it's viewable like a txt file and you can just copy from there.

Am I making any money from this? No, I've spent four years making code related to the Nintendo earnings releases and I haven't made any from it.

Without editing any of the code, you can grab any file right now and run it in Visual Studio Code and it will print out the code that you've seen in the latest Nintendo earnings financial results thread from me.

Please feel free to comment on my code, as I said, only one file has been commented thoroughly to be readable, the rest will be done over time. If you have any questions about my code it may take a while to give you an answer.

Update: All the files have had functions added and comments updated. The files still contain the old code and will be removed next fiscal year.

Second update: All the files have had their code refactored and mobile-friendly output has been added.

asperatology · Mar 4, 2022

Do you have plans to parse spreadsheet data from files into the code instead of having numbers hardcoded in the source code?

K samedi · Mar 4, 2022

Thanks for sharing. I will have a look at it. Wanted to get into Python (php, Swift and C++ programmer myself). This will give me a good excuse to dive in.

ggx2ac · Mar 4, 2022

asperatology said:
Do you have plans to parse spreadsheet data from files into the code instead of having numbers hardcoded in the source code?

I have never done that before so I don't know about it.

My coding knowledge is still novice level.

Whether I have time to add more plans is another matter because I have other things that are taking priority for a while.

ggx2ac · Mar 8, 2022

What's the difference between the table here on the top and the one below?

New code.

Code:

+------------------------------------------------------------------------------+
| Nintendo Co., Ltd.| Net Sales   | Operating Income | Op. Margin | Net Profit |
+------------------------------------------------------------------------------+
| 1st Quarter       |   ¥322,647M |        ¥119,752M |     37.12% |   ¥92,747M |
| 1st Quarter YoY%  |      -9.90% |          -17.26% |            |    -12.90% |
+------------------------------------------------------------------------------+
| 2nd Quarter       |   ¥301,625M |        ¥100,207M |     33.22% |   ¥79,087M |
| 2nd Quarter YoY%  |     -26.69% |          -31.69% |            |    -25.84% |
+------------------------------------------------------------------------------+
| 3rd Quarter       |   ¥695,947M |        ¥252,592M |     36.29% |  ¥195,553M |
| 3rd Quarter YoY%  |      +9.61% |           +9.97% |            |    +19.57% |
+==============================================================================+
| First Half        |   ¥624,272M |        ¥219,959M |     35.23% |  ¥171,834M |
| First Half YoY%   |     -18.88% |          -24.52% |            |    -19.37% |
+------------------------------------------------------------------------------+
| First 3 Quarters  | ¥1,320,219M |        ¥472,551M |     35.79% |  ¥367,387M |
| First 3 Qtrs YoY% |      -6.00% |           -9.32% |            |     -2.46% |
+------------------------------------------------------------------------------+
| FY3/22 Cumulative | ¥1,320,219M |        ¥472,551M |     35.79% |  ¥367,387M |
+------------------------------------------------------------------------------+
| FY3/22 Forecast   | ¥1,600,000M |        ¥500,000M |     31.25% |  ¥340,000M |
| 1st FCST Revision | ¥1,600,000M |        ¥520,000M |     32.50% |  ¥350,000M |
| 2nd FCST Revision | ¥1,650,000M |        ¥560,000M |     33.94% |  ¥400,000M |
+------------------------------------------------------------------------------+
###
+------------------------------------------------------------------------------+
| Nintendo Co., Ltd.| Net Sales   | Operating Income | Op. Margin | Net Profit |
+------------------------------------------------------------------------------+
| 1st Quarter       |   ¥322,647M |        ¥119,752M |     37.12% |   ¥92,747M |
| 1st Quarter YoY%  |      -9.90% |          -17.26% |            |    -12.90% |
+------------------------------------------------------------------------------+
| 2nd Quarter       |   ¥301,625M |        ¥100,207M |     33.22% |   ¥79,087M |
| 2nd Quarter YoY%  |     -26.69% |          -31.69% |            |    -25.84% |
+------------------------------------------------------------------------------+
| 3rd Quarter       |   ¥695,947M |        ¥252,592M |     36.29% |  ¥195,553M |
| 3rd Quarter YoY%  |      +9.61% |           +9.97% |            |    +19.57% |
+==============================================================================+
| First Half        |   ¥624,272M |        ¥219,959M |     35.23% |  ¥171,834M |
| First Half YoY%   |     -18.88% |          -24.52% |            |    -19.37% |
+------------------------------------------------------------------------------+
| First 3 Quarters  | ¥1,320,219M |        ¥472,551M |     35.79% |  ¥367,387M |
| First 3 Qtrs YoY% |      -6.00% |           -9.32% |            |     -2.46% |
+------------------------------------------------------------------------------+
| FY3/22 Cumulative | ¥1,320,219M |        ¥472,551M |     35.79% |  ¥367,387M |
+------------------------------------------------------------------------------+
| FY3/22 Forecast   | ¥1,600,000M |        ¥500,000M |     31.25% |  ¥340,000M |
| 1st FCST Revision | ¥1,600,000M |        ¥520,000M |     32.50% |  ¥350,000M |
| 2nd FCST Revision | ¥1,650,000M |        ¥560,000M |     33.94% |  ¥400,000M |
+------------------------------------------------------------------------------+

I said I was going to make improvements to my code, this is the start of it. Just like a few months ago when I announced I would be building new code by moving from Java to Python which took weeks. It is now going to take weeks improving this Python code since I have completed only one of several files.

What have I done? I have finally made use of functions and for loops, what this means is using methods to reduce lines of code that get repeated over and over again.

What benefits does this provide? First, for the one file I have completed so far I have reduced the amount of lines it uses from 224 to 131 which is approximately a 40% reduction. Second, with the use of functions I am now able to move all the variables that require input to the top of the page. This means much less scrolling to search for things.

Why didn't I do this before? I didn't understand how to make functions and for loops until now and even then it was still a matter of trial and error to get it to work.

What about the old code? I have placed it underneath the new code behind comments if you still wanted to view it. When I make the files for next fiscal year the old code won't be in the new files.

What can I do with the single completed file so far? As mentioned before, there are some files here that are applicable for other gaming companies. You could use it for Capcom or Square Enix earnings results for example.

Where is the link for the file? Here:

nintendo-earnings-data-and-other-video-game-companies/earningsfy3-22.py at main · r134x7/nintendo-earnings-data-and-other-video-game-companies

Ever-evolving personal project. Started out in the repo as Python scripts, now it is TypeScript Front-end React App. For displaying financial information of video game companies that provide adequa...

github.com

Edit: I noticed an error where I forgot to use i for the forecast revision for loop. I have just updated the code for that.

ggx2ac · Mar 8, 2022

So assuming you have read my posts in this thread so far then this is an update about another I have added new code to.

The file I use for posting (usually top ten) Top Selling Switch is around 500 lines of code. I added a function to that code, now that file uses only 70 lines of code an 85% reduction.

As mentioned before, since it uses a function, all the variables you need to input numbers are now found at the top of the page which means less scrolling.

I'm actually surprised at the function I made because it fulfills the outcome I wanted but it wasn't what I initially planned to build.

The outcome I was looking for was this, one of the things I was annoyed about when making the Top Selling Switch titles table was that people would post that the top selling titles aren't ordered from highest to lowest selling titles. I couldn't do anything about that with my old code because it would have meant moving around multiple lines of code which is messy and tiring.

Now with this new function I made, I can now switch around single lines of code to change the order of the titles.

So what you see below is the output of my new code, you will notice now that the titles are ordered from highest selling to lowest.

Where is the link for this file? Here:

nintendo-earnings-data-and-other-video-game-companies/topnswswfy3-22.py at main · r134x7/nintendo-earnings-data-and-other-video-game-companies

Ever-evolving personal project. Started out in the repo as Python scripts, now it is TypeScript Front-end React App. For displaying financial information of video game companies that provide adequa...

github.com

What can you do with this code? I was thinking you could use it to track the Capcom platinum titles page but that might be asking for too much since it lists 107 titles currently.

Code:

+------------------------------------------------------+
| Switch - Top Selling Titles              |   Units   |
+------------------------------------------------------+
| Mario Kart 8 Deluxe                      |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.69M |
| 2nd Quarter                              |     1.66M |
| 3rd Quarter                              |     4.61M |
+======================================================+
| FY3/22 Cumulative                        |     7.96M |
| Life-To-Date                             |    43.35M |
+------------------------------------------------------+
| Animal Crossing: New Horizons            |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.26M |
| 2nd Quarter                              |     0.96M |
| 3rd Quarter                              |     2.77M |
+======================================================+
| FY3/22 Cumulative                        |     4.99M |
| Life-To-Date                             |    37.62M |
+------------------------------------------------------+
| Super Smash Bros. Ultimate               |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.93M |
| 2nd Quarter                              |     0.94M |
| 3rd Quarter                              |     1.69M |
+======================================================+
| FY3/22 Cumulative                        |     3.56M |
| Life-To-Date                             |    27.40M |
+------------------------------------------------------+
| The Legend of Zelda: Breath of the Wild  |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.92M |
| 2nd Quarter                              |     0.93M |
| 3rd Quarter                              |     1.67M |
+======================================================+
| FY3/22 Cumulative                        |     3.52M |
| Life-To-Date                             |    25.80M |
+------------------------------------------------------+
| Pokémon Sword/Shield                     |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.75M |
| 2nd Quarter                              |     0.79M |
| 3rd Quarter                              |     1.26M |
+======================================================+
| FY3/22 Cumulative                        |     2.80M |
| Life-To-Date                             |    23.90M |
+------------------------------------------------------+
| Super Mario Odyssey                      |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.57M |
| 2nd Quarter                              |     0.55M |
| 3rd Quarter                              |     1.07M |
+======================================================+
| FY3/22 Cumulative                        |     2.19M |
| Life-To-Date                             |    23.02M |
+------------------------------------------------------+
| Super Mario Party                        |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.93M |
| 2nd Quarter                              |     0.76M |
| 3rd Quarter                              |     0.91M |
+======================================================+
| FY3/22 Cumulative                        |     2.60M |
| Life-To-Date                             |    17.39M |
+------------------------------------------------------+
| Pokémon Let's Go Pikachu/Eevee           |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.29M |
| 2nd Quarter                              |     0.26M |
| 3rd Quarter                              |     0.50M |
+======================================================+
| FY3/22 Cumulative                        |     1.05M |
| Life-To-Date                             |    14.33M |
+------------------------------------------------------+
| Pokémon Brilliant Diamond/Shining Pearl  |           |
+------------------------------------------------------+
| 3rd Quarter                              |    13.97M |
+======================================================+
| FY3/22 Cumulative                        |    13.97M |
| Life-To-Date                             |    13.97M |
+------------------------------------------------------+
| Ring Fit Adventure                       |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.15M |
| 2nd Quarter                              |     0.95M |
| 3rd Quarter                              |     1.32M |
+======================================================+
| FY3/22 Cumulative                        |     3.42M |
| Life-To-Date                             |    13.53M |
+------------------------------------------------------+
| Splatoon 2                               |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.24M |
| 2nd Quarter                              |     0.23M |
+======================================================+
| FY3/22 Cumulative                        |     0.47M |
| Life-To-Date                             |    12.68M |
+------------------------------------------------------+

Kenka · Mar 8, 2022

That is really appreciated ggx, the new code is much more legible

I can't wait to see it in action the moment the next quarterly results are in.

ggx2ac · Mar 9, 2022

As I mentioned in the OP, one of the files uses up 2400 lines, I have added a function and reduced the amount of code it uses to 250 lines, almost a 90% reduction.

The output of the new code is below.

As usual, with the use of a function, all the variables that require input are now at the top of the page. There are a lot of variables though so there will be some scrolling but you won't end up lost. Also, I'm still leaving the old code below and commented out until next FY.

Where is the link for this file? Here:

nintendo-earnings-data-and-other-video-game-companies/sip3fy3-22.py at main · r134x7/nintendo-earnings-data-and-other-video-game-companies

Ever-evolving personal project. Started out in the repo as Python scripts, now it is TypeScript Front-end React App. For displaying financial information of video game companies that provide adequa...

github.com

Code:

+-------------------------------------------------------------------------------------------+
| Nintendo Switch FY Million-Seller Titles                                                  |
+-------------------------------------------------------------------------------------------+
+-------------------------------------------------------------------------------------------+
| Miitopia                                | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.26M |       0.78M |     1.04M |      1.04M |
| 2nd Quarter (Units)                     |    0.09M |       0.24M |     0.33M |      0.33M |
| 3rd Quarter (Units)                     |    0.03M |       0.23M |     0.26M |      0.26M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.38M |       1.25M |     1.63M |      1.63M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   23.31% |      76.69% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Mario Kart 8 Deluxe                     | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.20M |       1.50M |     1.69M |     37.08M |
| 2nd Quarter (Units)                     |    0.26M |       1.39M |     1.65M |      1.66M |
| 3rd Quarter (Units)                     |    0.40M |       4.21M |     4.62M |      4.61M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.86M |       7.10M |     7.96M |     43.35M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   10.80% |      89.20% |    18.36% |     81.64% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| The Legend of Zelda: Breath of the Wild | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.16M |       1.70M |     1.85M |     24.13M |
| 3rd Quarter (Units)                     |    0.24M |       1.41M |     1.67M |      1.67M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.40M |       3.11M |     3.52M |     25.80M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   11.36% |      88.35% |    13.64% |     86.36% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| New Super Mario Bros. U Deluxe          | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.08M |       0.96M |     1.03M |     11.48M |
| 3rd Quarter (Units)                     |    0.06M |       1.17M |     1.25M |      1.24M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.14M |       2.13M |     2.28M |     12.72M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |    6.14% |      93.42% |    17.92% |     82.08% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Mario Golf: Super Rush                  | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.21M |       1.13M |     1.34M |      1.34M |
| 2nd Quarter (Units)                     |    0.08M |       0.52M |     0.60M |      0.60M |
| 3rd Quarter (Units)                     |    0.01M |       0.31M |     0.32M |      0.32M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.30M |       1.96M |     2.26M |      2.26M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   13.27% |      86.73% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Ring Fit Adventure                      | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.25M |       0.89M |     1.15M |     11.26M |
| 2nd Quarter (Units)                     |    0.27M |       0.69M |     0.95M |      0.95M |
| 3rd Quarter (Units)                     |    0.28M |       1.04M |     1.32M |      1.32M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.80M |       2.62M |     3.42M |     13.53M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   23.39% |      76.61% |    25.28% |     74.72% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Super Mario Party                       | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.22M |       1.47M |     1.68M |     16.48M |
| 3rd Quarter (Units)                     |    0.07M |       0.83M |     0.91M |      0.91M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.29M |       2.30M |     2.59M |     17.39M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   11.20% |      88.80% |    14.89% |     85.11% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Pokémon Sword/Shield                    | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.19M |       1.35M |     1.54M |     22.64M |
| 3rd Quarter (Units)                     |    0.23M |       1.03M |     1.26M |      1.26M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.42M |       2.38M |     2.80M |     23.90M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   15.00% |      85.00% |    11.72% |     88.28% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Super Smash Bros. Ultimate              | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.33M |       1.53M |     1.86M |     25.71M |
| 3rd Quarter (Units)                     |    0.44M |       1.26M |     1.70M |      1.69M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.77M |       2.79M |     3.56M |     27.40M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   21.63% |      78.37% |    12.99% |     87.01% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Super Mario Odyssey                     | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.08M |       1.03M |     1.12M |     21.95M |
| 3rd Quarter (Units)                     |    0.07M |       1.01M |     1.07M |      1.07M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.15M |       2.04M |     2.19M |     23.02M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |    6.85% |      93.15% |     9.51% |     90.49% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Animal Crossing: New Horizons           | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.13M |       1.13M |     1.26M |     33.89M |
| 2nd Quarter (Units)                     |    0.12M |       0.84M |     0.96M |      0.96M |
| 3rd Quarter (Units)                     |    0.45M |       2.33M |     2.77M |      2.77M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.70M |       4.30M |     4.99M |     37.62M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   14.03% |      86.17% |    13.26% |     86.74% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| The Legend of Zelda: Skyward Sword HD   | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.42M |       3.18M |     3.60M |      3.60M |
| 3rd Quarter (Units)                     |    0.02M |       0.22M |     0.25M |      0.25M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.44M |       3.40M |     3.85M |      3.85M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   11.43% |      88.31% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Super Mario 3D World + Boswer's Fury    | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.21M |       0.87M |     1.09M |      6.68M |
| 2nd Quarter (Units)                     |    0.15M |       0.63M |     0.77M |      0.77M |
| 3rd Quarter (Units)                     |    0.18M |       1.22M |     1.40M |      1.40M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.54M |       2.72M |     3.26M |      8.85M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   16.56% |      83.44% |    36.84% |     63.16% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| New Pokémon Snap                        | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.00M |       2.07M |     2.07M |      2.07M |
| 2nd Quarter (Units)                     |    0.00M |       0.12M |     0.12M |      0.12M |
| 3rd Quarter (Units)                     |    0.00M |       0.17M |     0.17M |      0.17M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.00M |       2.36M |     2.36M |      2.36M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |    0.00% |     100.00% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Metroid Dread                           | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    0.26M |       2.48M |     2.74M |      2.74M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.26M |       2.48M |     2.74M |      2.74M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |    9.49% |      90.51% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Mario Party Superstars                  | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    1.13M |       4.30M |     5.43M |      5.43M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    1.13M |       4.30M |     5.43M |      5.43M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   20.81% |      79.19% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Pokémon Brilliant Diamond/Shining Pearl | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    3.79M |      10.18M |    13.97M |     13.97M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    3.79M |      10.18M |    13.97M |     13.97M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   27.13% |      72.87% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Big Brain Academy: Brain vs Brain       | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    0.38M |       0.90M |     1.28M |      1.28M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.38M |       0.90M |     1.28M |      1.28M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   29.69% |      70.31% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Luigi's Mansion 3                       | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    0.09M |       1.36M |     1.45M |     11.04M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.09M |       1.36M |     1.45M |     11.04M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |    6.21% |      93.79% |    13.13% |     86.87% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| WarioWare: Get It Together!             | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    0.30M |       0.94M |     1.24M |      1.24M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.30M |       0.94M |     1.24M |      1.24M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   24.19% |      75.81% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Pokémon: Let's Go, Pikachu!/Eevee!      | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    0.03M |       1.02M |     1.05M |     14.33M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.03M |       1.02M |     1.05M |     14.33M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |    2.86% |      97.14% |     7.33% |     92.67% |
+-------------------------------------------------------------------------------------------+
###
+-------------------------------------------------------------------------------------------+
| Game Builder Garage                     | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    0.44M |       0.58M |     1.01M |      1.01M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.44M |       0.58M |     1.01M |      1.01M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   43.56% |      57.43% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
###

ggx2ac · Mar 10, 2022

I have added a function to the key indicators and digital indicators file.

It's probably a 50% reduction in lines used since the original was over 200 lines long.

As usual, all the inputs needed have been moved to the top of the page.

What makes this function different from the others so far was that I applied a nested for loop and it wasn't so simple for what I needed to do to get it to work. However, I noticed I could make the function simpler for next time to reduce the number of lines used.

Where is the link for this file? Here:

nintendo-earnings-data-and-other-video-game-companies/sip1fy3-22.py at main · r134x7/nintendo-earnings-data-and-other-video-game-companies

Ever-evolving personal project. Started out in the repo as Python scripts, now it is TypeScript Front-end React App. For displaying financial information of video game companies that provide adequa...

github.com

Code:

+------------------------------+
| Proportion of overseas sales |
+------------------------------+
| 1st Quarter       |    77.9% |
| 2nd Quarter       |    78.7% |
| 3rd Quarter       |    79.6% |
+==============================+
| 1st Half          |    78.3% |
| 1st Three Quarters|    79.0% |
+------------------------------+
(※ Proportion of overseas (outside of Japan)
sales to total sales)
+------------------------------+
| Proportion of hardware sales |
+------------------------------+
| 1st Quarter       |    47.6% |
| 2nd Quarter       |    45.2% |
| 3rd Quarter       |    53.9% |
+==============================+
| 1st Half          |    46.5% |
| 1st Three Quarters|    50.4% |
+------------------------------+
(※ Proportion of hardware (including accessories) sales
to total dedicated videogame platform sales)
+------------------------------+
| Proportion of first party    |
| software sales               |
+------------------------------+
| 1st Quarter       |    72.3% |
| 2nd Quarter       |    68.9% |
| 3rd Quarter       |    84.1% |
+==============================+
| 1st Half          |    70.6% |
| 1st Three Quarters|    77.7% |
+------------------------------+
(※ Proportion of first-party software sales
to total dedicated video game software sales)
+------------------------------+
| Digital Sales                |
+------------------------------+
| 1st Quarter       |   ¥75.9B |
| 2nd Quarter       |   ¥68.2B |
| 3rd Quarter       |  ¥110.8B |
+==============================+
| 1st Half          |  ¥144.2B |
| 1st Three Quarters|  ¥255.0B |
+------------------------------+
("※ Digital sales include a) downloadable versions of packaged software,
b) download-only software, c) add-on content and d) Nintendo Switch Online, etc.
＊ "Downloadable versions of packaged software" indicates the
downloadable version of software that is offered both physically and digitally.")
+------------------------------+
| Proportion of Digital Sales  |
+------------------------------+
| 1st Quarter       |    46.9% |
| 2nd Quarter       |    43.2% |
| 3rd Quarter       |    35.3% |
+==============================+
| 1st Half          |    45.1% |
| 1st Three Quarters|    40.2% |
+------------------------------+
(※ Proportion of digital sales to total dedicated
 video game software sales )
+-------------------------------------+
| Proportion of downloadable versions |
| of Packaged Software Sales          |
+-------------------------------------+
| 1st Quarter       |           52.1% |
| 2nd Quarter       |           49.1% |
| 3rd Quarter       |           56.3% |
+=====================================+
| 1st Half          |           50.7% |
| 1st Three Quarters|           53.1% |
+-------------------------------------+
(※ Proportion of downloadable versions of packaged software sales
 to total digital sales as indicated above: a/(a+b+c+d) )

ggx2ac · Mar 12, 2022

I have added a function to the regional data file. This one has probably the most complex function yet.

The old file used 1800 lines, this updated code uses 256 lines which is approximately an 85% reduction.

After what I have done with this file I will have to go back through the other files to look at changing code.

For example, divide by zero occurs when there is no data for last year to do YoY percentages. Before this I used other methods to get around it but with implementing a function I needed things to be consistent when it's running. You can look at the code to see what method I used.

The other issue that occurred was with printing out the data, to keep things consistent I needed to get the YoY percentages row removed on certain conditions since it makes no sense for it to say 0% if there is no data from last year i.e. Switch OLED.

Where is the link for this file? Here:

nintendo-earnings-data-and-other-video-game-companies/sip2fy3-22.py at main · r134x7/nintendo-earnings-data-and-other-video-game-companies

Ever-evolving personal project. Started out in the repo as Python scripts, now it is TypeScript Front-end React App. For displaying financial information of video game companies that provide adequa...

github.com

Code:

+--------------------------------------------------------------------------+
| Switch                   |  Japan   |The Americas|  Europe   |   Other   |
+--------------------------------------------------------------------------+
| 1st Quarter (Units)      |    0.83M |      1.10M |     0.82M |     0.56M |
| 1st Quarter YoY%         |   +5.06% |    +54.93% |    -1.20% |   -23.29% |
| 1st Quarter WW%          |   25.08% |     33.23% |    24.77% |    16.92% |
+--------------------------------------------------------------------------+
| 2nd Quarter (Units)      |    0.75M |      1.05M |     0.81M |     0.53M |
| 2nd Quarter YoY%         |  -34.21% |    -44.15% |   -39.10% |   -44.21% |
| 2nd Quarter WW%          |   23.89% |     33.44% |    25.80% |    16.88% |
+--------------------------------------------------------------------------+
| 3rd Quarter (Units)      |    0.77M |      1.96M |     2.12M |     0.50M |
| 3rd Quarter YoY%         |  -63.16% |    -34.88% |    +0.95% |   -58.68% |
| 3rd Quarter WW%          |   14.42% |     36.70% |    39.70% |     9.36% |
+==========================================================================+
| First Half (Units)       |    1.58M |      2.15M |     1.63M |     1.09M |
| First Half YoY%          |  -18.13% |    -16.99% |   -24.54% |   -35.12% |
| First Half WW%           |   24.50% |     33.33% |    25.27% |    16.90% |
+--------------------------------------------------------------------------+
| First 3 Quarters (Units) |    2.35M |      4.11M |     3.75M |     1.59M |
| First 3 Qtrs YoY%        |  -41.54% |    -26.61% |   -11.97% |   -44.98% |
| First 3 Qtrs WW%         |   19.93% |     34.86% |    31.81% |    13.49% |
+--------------------------------------------------------------------------+
| FY3/22 Cumulative (Units)|    2.35M |      4.11M |     3.75M |     1.59M |
| FY3/22 Cumulative WW%    |   19.93% |     34.86% |    31.81% |    13.49% |
+--------------------------------------------------------------------------+
| Life-To-Date (Units)     |   18.57M |     30.97M |    21.86M |    10.29M |
| Life-To-Date WW%         |   22.74% |     37.92% |    26.76% |    12.60% |
+--------------------------------------------------------------------------+
###
+--------------------------------------------------------------------------+
| Switch Lite              |  Japan   |The Americas|  Europe   |   Other   |
+--------------------------------------------------------------------------+
| 1st Quarter (Units)      |    0.34M |      0.48M |     0.26M |     0.05M |
| 1st Quarter YoY%         |   -5.56% |    -62.50% |   -67.09% |   -75.00% |
| 1st Quarter WW%          |   29.82% |     42.11% |    22.81% |     4.39% |
+--------------------------------------------------------------------------+
| 2nd Quarter (Units)      |    0.11M |      0.41M |     0.13M |     0.05M |
| 2nd Quarter YoY%         |  -75.00% |    -30.51% |   -62.86% |   -68.75% |
| 2nd Quarter WW%          |   16.18% |     60.29% |    19.12% |     7.35% |
+--------------------------------------------------------------------------+
| 3rd Quarter (Units)      |    0.46M |      0.44M |     0.36M |     0.08M |
| 3rd Quarter YoY%         |  -25.81% |    -72.15% |   -59.09% |   -11.11% |
| 3rd Quarter WW%          |   34.07% |     32.59% |    26.67% |     5.93% |
+==========================================================================+
| First Half (Units)       |    0.45M |      0.89M |     0.39M |     0.10M |
| First Half YoY%          |  -43.75% |    -52.41% |   -65.79% |   -72.22% |
| First Half WW%           |   24.73% |     48.90% |    21.43% |     5.49% |
+--------------------------------------------------------------------------+
| First 3 Quarters (Units) |    0.91M |      1.33M |     0.75M |     0.18M |
| First 3 Qtrs YoY%        |  -35.92% |    -61.45% |   -62.87% |   -60.00% |
| First 3 Qtrs WW%         |   28.71% |     41.96% |    23.66% |     5.68% |
+--------------------------------------------------------------------------+
| FY3/22 Cumulative (Units)|    0.91M |      1.33M |     0.75M |     0.18M |
| FY3/22 Cumulative WW%    |   28.71% |     41.96% |    23.66% |     5.68% |
+--------------------------------------------------------------------------+
| Life-To-Date (Units)     |    4.72M |      7.74M |     4.22M |     1.19M |
| Life-To-Date WW%         |   26.41% |     43.31% |    23.61% |     6.66% |
+--------------------------------------------------------------------------+
###
+--------------------------------------------------------------------------+
| Switch OLED              |  Japan   |The Americas|  Europe   |   Other   |
+--------------------------------------------------------------------------+
| 3rd Quarter (Units)      |    1.07M |      1.41M |     0.91M |     0.61M |
| 3rd Quarter WW%          |   26.82% |     35.34% |    22.81% |    15.29% |
+==========================================================================+
| First 3 Quarters (Units) |    1.07M |      1.41M |     0.91M |     0.61M |
| First 3 Qtrs WW%         |   26.82% |     35.34% |    22.81% |    15.29% |
+--------------------------------------------------------------------------+
| FY3/22 Cumulative (Units)|    1.07M |      1.41M |     0.91M |     0.61M |
| FY3/22 Cumulative WW%    |   26.82% |     35.34% |    22.81% |    15.29% |
+--------------------------------------------------------------------------+
| Life-To-Date (Units)     |    1.07M |      1.41M |     0.91M |     0.61M |
| Life-To-Date WW%         |   26.82% |     35.34% |    22.81% |    15.29% |
+--------------------------------------------------------------------------+
###
+--------------------------------------------------------------------------+
| Switch Hardware          |  Japan   |The Americas|  Europe   |   Other   |
+--------------------------------------------------------------------------+
| 1st Quarter (Units)      |    1.16M |      1.59M |     1.08M |     0.62M |
| 1st Quarter YoY%         |   +0.87% |    -20.10% |   -32.92% |   -32.61% |
| 1st Quarter WW%          |   26.07% |     35.73% |    24.27% |    13.93% |
+--------------------------------------------------------------------------+
| 2nd Quarter (Units)      |    0.87M |      1.45M |     0.94M |     0.57M |
| 2nd Quarter YoY%         |  -44.94% |    -41.30% |   -44.71% |   -49.11% |
| 2nd Quarter WW%          |   22.72% |     37.86% |    24.54% |    14.88% |
+--------------------------------------------------------------------------+
| 3rd Quarter (Units)      |    2.29M |      3.80M |     3.38M |     1.19M |
| 3rd Quarter YoY%         |  -15.50% |    -17.21% |   +13.80% |    -7.75% |
| 3rd Quarter WW%          |   21.46% |     35.61% |    31.68% |    11.15% |
+==========================================================================+
| First Half (Units)       |    2.03M |      3.04M |     2.02M |     1.19M |
| First Half YoY%          |  -25.64% |    -31.84% |   -38.97% |   -41.67% |
| First Half WW%           |   24.52% |     36.71% |    24.40% |    14.37% |
+--------------------------------------------------------------------------+
| First 3 Quarters (Units) |    4.32M |      6.84M |     5.40M |     2.38M |
| First 3 Qtrs YoY%        |  -20.59% |    -24.42% |   -14.01% |   -28.53% |
| First 3 Qtrs WW%         |   22.80% |     36.09% |    28.50% |    12.56% |
+--------------------------------------------------------------------------+
| FY3/22 Cumulative (Units)|    4.32M |      6.84M |     5.40M |     2.38M |
| FY3/22 Cumulative WW%    |   22.80% |     36.09% |    28.50% |    12.56% |
+--------------------------------------------------------------------------+
| Life-To-Date (Units)     |   24.36M |     40.11M |    26.98M |    12.09M |
| Life-To-Date WW%         |   23.53% |     38.74% |    26.06% |    11.68% |
+--------------------------------------------------------------------------+
###
+--------------------------------------------------------------------------+
| Switch Software          |  Japan   |The Americas|  Europe   |   Other   |
+--------------------------------------------------------------------------+
| 1st Quarter (Units)      |    8.13M |     22.35M |    11.35M |     3.46M |
| 1st Quarter YoY%         |  -18.86% |     +4.00% |   -20.68% |   -25.11% |
| 1st Quarter WW%          |   17.95% |     49.35% |    25.06% |     7.64% |
+--------------------------------------------------------------------------+
| 2nd Quarter (Units)      |    8.00M |     22.78M |    14.28M |     3.54M |
| 2nd Quarter YoY%         |   +3.09% |     -5.48% |    +0.42% |    -4.84% |
| 2nd Quarter WW%          |   16.46% |     46.87% |    29.38% |     7.28% |
+--------------------------------------------------------------------------+
| 3rd Quarter (Units)      |   14.85M |     39.51M |    25.22M |     5.83M |
| 3rd Quarter YoY%         |   +6.76% |    +16.38% |    +5.74% |   +40.14% |
| 3rd Quarter WW%          |   17.39% |     46.26% |    29.53% |     6.83% |
+==========================================================================+
| First Half (Units)       |   16.13M |     45.13M |    25.63M |     7.00M |
| First Half YoY%          |   -9.28% |     -1.01% |   -10.16% |   -16.07% |
| First Half WW%           |   17.18% |     48.07% |    27.30% |     7.46% |
+--------------------------------------------------------------------------+
| First 3 Quarters (Units) |   30.98M |     84.64M |    50.85M |    12.83M |
| First 3 Qtrs YoY%        |   -2.24% |     +6.41% |    -2.92% |    +2.64% |
| First 3 Qtrs WW%         |   17.28% |     47.21% |    28.36% |     7.16% |
+--------------------------------------------------------------------------+
| FY3/22 Cumulative (Units)|   30.98M |     84.64M |    50.85M |    12.83M |
| FY3/22 Cumulative WW%    |   17.28% |     47.21% |    28.36% |     7.16% |
+--------------------------------------------------------------------------+
| Life-To-Date (Units)     |  143.20M |    345.64M |   223.00M |    54.57M |
| Life-To-Date WW%         |   18.68% |     45.10% |    29.10% |     7.12% |
+--------------------------------------------------------------------------+
###

ggx2ac · Mar 18, 2022

ggx2ac said:
What's the difference between the table here on the top and the one below?

New code.

Code:

+------------------------------------------------------------------------------+ | Nintendo Co., Ltd.| Net Sales | Operating Income | Op. Margin | Net Profit | +------------------------------------------------------------------------------+ | 1st Quarter | ¥322,647M | ¥119,752M | 37.12% | ¥92,747M | | 1st Quarter YoY% | -9.90% | -17.26% | | -12.90% | +------------------------------------------------------------------------------+ | 2nd Quarter | ¥301,625M | ¥100,207M | 33.22% | ¥79,087M | | 2nd Quarter YoY% | -26.69% | -31.69% | | -25.84% | +------------------------------------------------------------------------------+ | 3rd Quarter | ¥695,947M | ¥252,592M | 36.29% | ¥195,553M | | 3rd Quarter YoY% | +9.61% | +9.97% | | +19.57% | +==============================================================================+ | First Half | ¥624,272M | ¥219,959M | 35.23% | ¥171,834M | | First Half YoY% | -18.88% | -24.52% | | -19.37% | +------------------------------------------------------------------------------+ | First 3 Quarters | ¥1,320,219M | ¥472,551M | 35.79% | ¥367,387M | | First 3 Qtrs YoY% | -6.00% | -9.32% | | -2.46% | +------------------------------------------------------------------------------+ | FY3/22 Cumulative | ¥1,320,219M | ¥472,551M | 35.79% | ¥367,387M | +------------------------------------------------------------------------------+ | FY3/22 Forecast | ¥1,600,000M | ¥500,000M | 31.25% | ¥340,000M | | 1st FCST Revision | ¥1,600,000M | ¥520,000M | 32.50% | ¥350,000M | | 2nd FCST Revision | ¥1,650,000M | ¥560,000M | 33.94% | ¥400,000M | +------------------------------------------------------------------------------+ ### +------------------------------------------------------------------------------+ | Nintendo Co., Ltd.| Net Sales | Operating Income | Op. Margin | Net Profit | +------------------------------------------------------------------------------+ | 1st Quarter | ¥322,647M | ¥119,752M | 37.12% | ¥92,747M | | 1st Quarter YoY% | -9.90% | -17.26% | | -12.90% | +------------------------------------------------------------------------------+ | 2nd Quarter | ¥301,625M | ¥100,207M | 33.22% | ¥79,087M | | 2nd Quarter YoY% | -26.69% | -31.69% | | -25.84% | +------------------------------------------------------------------------------+ | 3rd Quarter | ¥695,947M | ¥252,592M | 36.29% | ¥195,553M | | 3rd Quarter YoY% | +9.61% | +9.97% | | +19.57% | +==============================================================================+ | First Half | ¥624,272M | ¥219,959M | 35.23% | ¥171,834M | | First Half YoY% | -18.88% | -24.52% | | -19.37% | +------------------------------------------------------------------------------+ | First 3 Quarters | ¥1,320,219M | ¥472,551M | 35.79% | ¥367,387M | | First 3 Qtrs YoY% | -6.00% | -9.32% | | -2.46% | +------------------------------------------------------------------------------+ | FY3/22 Cumulative | ¥1,320,219M | ¥472,551M | 35.79% | ¥367,387M | +------------------------------------------------------------------------------+ | FY3/22 Forecast | ¥1,600,000M | ¥500,000M | 31.25% | ¥340,000M | | 1st FCST Revision | ¥1,600,000M | ¥520,000M | 32.50% | ¥350,000M | | 2nd FCST Revision | ¥1,650,000M | ¥560,000M | 33.94% | ¥400,000M | +------------------------------------------------------------------------------+

I said I was going to make improvements to my code, this is the start of it. Just like a few months ago when I announced I would be building new code by moving from Java to Python which took weeks. It is now going to take weeks improving this Python code since I have completed only one of several files.

What have I done? I have finally made use of functions and for loops, what this means is using methods to reduce lines of code that get repeated over and over again.

What benefits does this provide? First, for the one file I have completed so far I have reduced the amount of lines it uses from 224 to 131 which is approximately a 40% reduction. Second, with the use of functions I am now able to move all the variables that require input to the top of the page. This means much less scrolling to search for things.

Why didn't I do this before? I didn't understand how to make functions and for loops until now and even then it was still a matter of trial and error to get it to work.

What about the old code? I have placed it underneath the new code behind comments if you still wanted to view it. When I make the files for next fiscal year the old code won't be in the new files.

What can I do with the single completed file so far? As mentioned before, there are some files here that are applicable for other gaming companies. You could use it for Capcom or Square Enix earnings results for example.

Where is the link for the file? Here:

nintendo-earnings-data-and-other-video-game-companies/Nintendo FY3-2022/earningsfy3-22.py at 8968a02a851b98bc2628afb7270be63980c1b820 · r134x7/nintendo-earnings-data-and-other-video-game-companies

Ever-evolving personal project. Started out in the repo as Python scripts, now it is TypeScript Front-end React App. For displaying financial information of video game companies that provide adequa...

github.com

Edit: I noticed an error where I forgot to use i for the forecast revision for loop. I have just updated the code for that.

I have updated the file linked in this post to change the operating margin function to deal with divide by zeros more easily and then I changed how the whole thing prints because there was an issue where it might not have worked correctly in the fourth quarter.

I still have other files to update.

ggx2ac · Mar 18, 2022

I have added a function to the Hardware/Software, mobile/IP data file.

The old file used around 330 lines, this updated code uses 254 lines which is approximately a 23% reduction which is not much.

Where is the link for this file? Here:

nintendo-earnings-data-and-other-video-game-companies/hwswunitsfy3-22.py at main · r134x7/nintendo-earnings-data-and-other-video-game-companies

Ever-evolving personal project. Started out in the repo as Python scripts, now it is TypeScript Front-end React App. For displaying financial information of video game companies that provide adequa...

github.com

All the files have been updated with new code mainly functions and comments. Now the code should be more easier to understand and all the inputs needed are at the top of the page.

I will look through the files again another time to see if there is anything to fix.

Regarding having these files use import to get the numbers used for input from other files/spreadsheets instead of the input being hardcoded, I will look into that and see if I can apply that before the first quarter results of the next fiscal year.

Code:

+------------------------------------------------------------------------------------+
| Switch (units)    |  Switch  |Switch Lite|Switch OLED|Hardware Total|Software Total|
+------------------------------------------------------------------------------------+
| 1st Quarter       |    3.31M |     1.14M |           |        4.45M |       45.29M |
| 1st Quarter YoY%  |   +8.52% |   -56.49% |           |      -21.65% |      -10.19% |
+------------------------------------------------------------------------------------+
| 2nd Quarter       |    3.14M |     0.68M |           |        3.83M |       48.60M |
| 2nd Quarter YoY%  |  -40.87% |   -56.13% |           |      -44.09% |       -2.45% |
+------------------------------------------------------------------------------------+
| 3rd Quarter       |    5.34M |     1.35M |     3.99M |       10.67M |       85.40M |
| 3rd Quarter YoY%  |  -36.50% |   -57.28% |           |       -7.78% |      +12.59% |
+====================================================================================+
| First Half        |    6.45M |     1.82M |           |        8.28M |       93.89M |
| First Half YoY%   |  -22.85% |   -56.35% |           |      -33.92% |       -6.34% |
+------------------------------------------------------------------------------------+
| First 3 Quarters  |   11.79M |     3.17M |     3.99M |       18.95M |      179.29M |
| First 3 Qtrs YoY% |  -29.70% |   -56.75% |           |      -21.37% |       +1.81% |
+------------------------------------------------------------------------------------+
| FY3/22 Cumulative |   11.79M |     3.17M |     3.99M |       18.95M |      179.29M |
| FY3/22 Cml. YoY%  |  -41.98% |   -62.75% |           |      -34.27% |      -22.34% |
+------------------------------------------------------------------------------------+
| Life-To-Date      |   81.68M |    17.87M |     3.99M |      103.54M |      766.41M |
+------------------------------------------------------------------------------------+
| FY3/22 Forecast   |                                  |       25.50M |      190.00M |
| 1st FCST Revision |                                  |       24.00M |      200.00M |
| 2nd FCST Revision |                                  |       23.00M |      220.00M |
+------------------------------------------------------------------------------------+
(Software sales units include both packaged and downloadable versions of software.)
###
+---------------------------------+
| Mobile, IP related income, etc. |
+---------------------------------+
| 1st Quarter       |    ¥13,199M |
| 1st Quarter YoY%  |      -0.59% |
+---------------------------------+
| 2nd Quarter       |    ¥12,302M |
| 2nd Quarter YoY%  |      -8.53% |
+---------------------------------+
| 3rd Quarter       |    ¥14,324M |
| 3rd Quarter YoY%  |      -6.28% |
+=================================+
| First Half        |    ¥25,501M |
| First Half YoY%   |      -4.59% |
+---------------------------------+
| First 3 Quarters  |    ¥39,825M |
| First 3 Qtrs YoY% |      -5.20% |
+---------------------------------+
| FY3/22 Cumulative |    ¥39,825M |
+---------------------------------+
(Includes income from smart-device content and royalty income.)

ggx2ac · Mar 19, 2022

There was one thing I wanted to add to the top ten selling titles file and I luckily got it to work.

I am having to post the new and old code output in this post just to make sure this worked.

In the old code, I manually arranged each function(variable) so that the top ten selling titles could show up in descending order.

In the new code, I tried to figure out a method using the built-in Python functions for sorting and it worked.

What this means is that I won't have to sort variables manually to get it in descending order, this means I can also use this method to sort the fiscal year million seller titles file.

What this also means is that I have made it easier to create a sorted Capcom platinum titles list. You could make the list like the code output below displaying what each title has done each quarter and you don't have to worry about sorting 100+ titles.

I will probably make a Capcom platinum titles list of the current financial year just to demonstrate it.

Meanwhile, Where is the link for the Nintendo top ten titles list? Here:

nintendo-earnings-data-and-other-video-game-companies/topnswswfy3-22.py at main · r134x7/nintendo-earnings-data-and-other-video-game-companies

Ever-evolving personal project. Started out in the repo as Python scripts, now it is TypeScript Front-end React App. For displaying financial information of video game companies that provide adequa...

github.com

New:

Code:

+------------------------------------------------------+
| Switch - Top Selling Titles              |   Units   |
+------------------------------------------------------+
| Mario Kart 8 Deluxe                      |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.69M |
| 2nd Quarter                              |     1.66M |
| 3rd Quarter                              |     4.61M |
+======================================================+
| FY3/22 Cumulative                        |     7.96M |
| Life-To-Date                             |    43.35M |
+------------------------------------------------------+
| Animal Crossing: New Horizons            |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.26M |
| 2nd Quarter                              |     0.96M |
| 3rd Quarter                              |     2.77M |
+======================================================+
| FY3/22 Cumulative                        |     4.99M |
| Life-To-Date                             |    37.62M |
+------------------------------------------------------+
| Super Smash Bros. Ultimate               |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.93M |
| 2nd Quarter                              |     0.94M |
| 3rd Quarter                              |     1.69M |
+======================================================+
| FY3/22 Cumulative                        |     3.56M |
| Life-To-Date                             |    27.40M |
+------------------------------------------------------+
| The Legend of Zelda: Breath of the Wild  |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.92M |
| 2nd Quarter                              |     0.93M |
| 3rd Quarter                              |     1.67M |
+======================================================+
| FY3/22 Cumulative                        |     3.52M |
| Life-To-Date                             |    25.80M |
+------------------------------------------------------+
| Pokémon Sword/Shield                     |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.75M |
| 2nd Quarter                              |     0.79M |
| 3rd Quarter                              |     1.26M |
+======================================================+
| FY3/22 Cumulative                        |     2.80M |
| Life-To-Date                             |    23.90M |
+------------------------------------------------------+
| Super Mario Odyssey                      |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.57M |
| 2nd Quarter                              |     0.55M |
| 3rd Quarter                              |     1.07M |
+======================================================+
| FY3/22 Cumulative                        |     2.19M |
| Life-To-Date                             |    23.02M |
+------------------------------------------------------+
| Super Mario Party                        |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.93M |
| 2nd Quarter                              |     0.76M |
| 3rd Quarter                              |     0.91M |
+======================================================+
| FY3/22 Cumulative                        |     2.60M |
| Life-To-Date                             |    17.39M |
+------------------------------------------------------+
| Pokémon Let's Go Pikachu/Eevee           |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.29M |
| 2nd Quarter                              |     0.26M |
| 3rd Quarter                              |     0.50M |
+======================================================+
| FY3/22 Cumulative                        |     1.05M |
| Life-To-Date                             |    14.33M |
+------------------------------------------------------+
| Pokémon Brilliant Diamond/Shining Pearl  |           |
+------------------------------------------------------+
| 3rd Quarter                              |    13.97M |
+======================================================+
| FY3/22 Cumulative                        |    13.97M |
| Life-To-Date                             |    13.97M |
+------------------------------------------------------+
| Ring Fit Adventure                       |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.15M |
| 2nd Quarter                              |     0.95M |
| 3rd Quarter                              |     1.32M |
+======================================================+
| FY3/22 Cumulative                        |     3.42M |
| Life-To-Date                             |    13.53M |
+------------------------------------------------------+
| Splatoon 2                               |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.24M |
| 2nd Quarter                              |     0.23M |
+======================================================+
| FY3/22 Cumulative                        |     0.47M |
| Life-To-Date                             |    12.68M |
+------------------------------------------------------+

Old:

Code:

+------------------------------------------------------+
| Switch - Top Selling Titles              |   Units   |
+------------------------------------------------------+
| Mario Kart 8 Deluxe                      |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.69M |
| 2nd Quarter                              |     1.66M |
| 3rd Quarter                              |     4.61M |
+======================================================+
| FY3/22 Cumulative                        |     7.96M |
| Life-To-Date                             |    43.35M |
+------------------------------------------------------+
| Animal Crossing: New Horizons            |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.26M |
| 2nd Quarter                              |     0.96M |
| 3rd Quarter                              |     2.77M |
+======================================================+
| FY3/22 Cumulative                        |     4.99M |
| Life-To-Date                             |    37.62M |
+------------------------------------------------------+
| Super Smash Bros. Ultimate               |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.93M |
| 2nd Quarter                              |     0.94M |
| 3rd Quarter                              |     1.69M |
+======================================================+
| FY3/22 Cumulative                        |     3.56M |
| Life-To-Date                             |    27.40M |
+------------------------------------------------------+
| The Legend of Zelda: Breath of the Wild  |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.92M |
| 2nd Quarter                              |     0.93M |
| 3rd Quarter                              |     1.67M |
+======================================================+
| FY3/22 Cumulative                        |     3.52M |
| Life-To-Date                             |    25.80M |
+------------------------------------------------------+
| Pokémon Sword/Shield                     |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.75M |
| 2nd Quarter                              |     0.79M |
| 3rd Quarter                              |     1.26M |
+======================================================+
| FY3/22 Cumulative                        |     2.80M |
| Life-To-Date                             |    23.90M |
+------------------------------------------------------+
| Super Mario Odyssey                      |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.57M |
| 2nd Quarter                              |     0.55M |
| 3rd Quarter                              |     1.07M |
+======================================================+
| FY3/22 Cumulative                        |     2.19M |
| Life-To-Date                             |    23.02M |
+------------------------------------------------------+
| Super Mario Party                        |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.93M |
| 2nd Quarter                              |     0.76M |
| 3rd Quarter                              |     0.91M |
+======================================================+
| FY3/22 Cumulative                        |     2.60M |
| Life-To-Date                             |    17.39M |
+------------------------------------------------------+
| Pokémon Let's Go Pikachu/Eevee           |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.29M |
| 2nd Quarter                              |     0.26M |
| 3rd Quarter                              |     0.50M |
+======================================================+
| FY3/22 Cumulative                        |     1.05M |
| Life-To-Date                             |    14.33M |
+------------------------------------------------------+
| Pokémon Brilliant Diamond/Shining Pearl  |           |
+------------------------------------------------------+
| 3rd Quarter                              |    13.97M |
+======================================================+
| FY3/22 Cumulative                        |    13.97M |
| Life-To-Date                             |    13.97M |
+------------------------------------------------------+
| Ring Fit Adventure                       |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.15M |
| 2nd Quarter                              |     0.95M |
| 3rd Quarter                              |     1.32M |
+======================================================+
| FY3/22 Cumulative                        |     3.42M |
| Life-To-Date                             |    13.53M |
+------------------------------------------------------+
| Splatoon 2                               |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.24M |
| 2nd Quarter                              |     0.23M |
+======================================================+
| FY3/22 Cumulative                        |     0.47M |
| Life-To-Date                             |    12.68M |
+------------------------------------------------------+

ggx2ac · Mar 19, 2022

ggx2ac said:

There was one thing I wanted to add to the top ten selling titles file and I luckily got it to work.

I am having to post the new and old code output in this post just to make sure this worked.

In the old code, I manually arranged each function(variable) so that the top ten selling titles could show up in descending order.

In the new code, I tried to figure out a method using the built-in Python functions for sorting and it worked.

What this means is that I won't have to sort variables manually to get it in descending order, this means I can also use this method to sort the fiscal year million seller titles file.

What this also means is that I have made it easier to create a sorted Capcom platinum titles list. You could make the list like the code output below displaying what each title has done each quarter and you don't have to worry about sorting 100+ titles.

I will probably make a Capcom platinum titles list of the current financial year just to demonstrate it.

Meanwhile, Where is the link for the Nintendo top ten titles list? Here:

nintendo-earnings-data-python/topnswswfy3-22.py at main · r134x7/nintendo-earnings-data-python

Contribute to r134x7/nintendo-earnings-data-python development by creating an account on GitHub.

github.com

New:

Code:

+------------------------------------------------------+
| Switch - Top Selling Titles              |   Units   |
+------------------------------------------------------+
| Mario Kart 8 Deluxe                      |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.69M |
| 2nd Quarter                              |     1.66M |
| 3rd Quarter                              |     4.61M |
+======================================================+
| FY3/22 Cumulative                        |     7.96M |
| Life-To-Date                             |    43.35M |
+------------------------------------------------------+
| Animal Crossing: New Horizons            |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.26M |
| 2nd Quarter                              |     0.96M |
| 3rd Quarter                              |     2.77M |
+======================================================+
| FY3/22 Cumulative                        |     4.99M |
| Life-To-Date                             |    37.62M |
+------------------------------------------------------+
| Super Smash Bros. Ultimate               |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.93M |
| 2nd Quarter                              |     0.94M |
| 3rd Quarter                              |     1.69M |
+======================================================+
| FY3/22 Cumulative                        |     3.56M |
| Life-To-Date                             |    27.40M |
+------------------------------------------------------+
| The Legend of Zelda: Breath of the Wild  |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.92M |
| 2nd Quarter                              |     0.93M |
| 3rd Quarter                              |     1.67M |
+======================================================+
| FY3/22 Cumulative                        |     3.52M |
| Life-To-Date                             |    25.80M |
+------------------------------------------------------+
| Pokémon Sword/Shield                     |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.75M |
| 2nd Quarter                              |     0.79M |
| 3rd Quarter                              |     1.26M |
+======================================================+
| FY3/22 Cumulative                        |     2.80M |
| Life-To-Date                             |    23.90M |
+------------------------------------------------------+
| Super Mario Odyssey                      |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.57M |
| 2nd Quarter                              |     0.55M |
| 3rd Quarter                              |     1.07M |
+======================================================+
| FY3/22 Cumulative                        |     2.19M |
| Life-To-Date                             |    23.02M |
+------------------------------------------------------+
| Super Mario Party                        |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.93M |
| 2nd Quarter                              |     0.76M |
| 3rd Quarter                              |     0.91M |
+======================================================+
| FY3/22 Cumulative                        |     2.60M |
| Life-To-Date                             |    17.39M |
+------------------------------------------------------+
| Pokémon Let's Go Pikachu/Eevee           |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.29M |
| 2nd Quarter                              |     0.26M |
| 3rd Quarter                              |     0.50M |
+======================================================+
| FY3/22 Cumulative                        |     1.05M |
| Life-To-Date                             |    14.33M |
+------------------------------------------------------+
| Pokémon Brilliant Diamond/Shining Pearl  |           |
+------------------------------------------------------+
| 3rd Quarter                              |    13.97M |
+======================================================+
| FY3/22 Cumulative                        |    13.97M |
| Life-To-Date                             |    13.97M |
+------------------------------------------------------+
| Ring Fit Adventure                       |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.15M |
| 2nd Quarter                              |     0.95M |
| 3rd Quarter                              |     1.32M |
+======================================================+
| FY3/22 Cumulative                        |     3.42M |
| Life-To-Date                             |    13.53M |
+------------------------------------------------------+
| Splatoon 2                               |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.24M |
| 2nd Quarter                              |     0.23M |
+======================================================+
| FY3/22 Cumulative                        |     0.47M |
| Life-To-Date                             |    12.68M |
+------------------------------------------------------+

Old:

Code:

+------------------------------------------------------+
| Switch - Top Selling Titles              |   Units   |
+------------------------------------------------------+
| Mario Kart 8 Deluxe                      |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.69M |
| 2nd Quarter                              |     1.66M |
| 3rd Quarter                              |     4.61M |
+======================================================+
| FY3/22 Cumulative                        |     7.96M |
| Life-To-Date                             |    43.35M |
+------------------------------------------------------+
| Animal Crossing: New Horizons            |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.26M |
| 2nd Quarter                              |     0.96M |
| 3rd Quarter                              |     2.77M |
+======================================================+
| FY3/22 Cumulative                        |     4.99M |
| Life-To-Date                             |    37.62M |
+------------------------------------------------------+
| Super Smash Bros. Ultimate               |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.93M |
| 2nd Quarter                              |     0.94M |
| 3rd Quarter                              |     1.69M |
+======================================================+
| FY3/22 Cumulative                        |     3.56M |
| Life-To-Date                             |    27.40M |
+------------------------------------------------------+
| The Legend of Zelda: Breath of the Wild  |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.92M |
| 2nd Quarter                              |     0.93M |
| 3rd Quarter                              |     1.67M |
+======================================================+
| FY3/22 Cumulative                        |     3.52M |
| Life-To-Date                             |    25.80M |
+------------------------------------------------------+
| Pokémon Sword/Shield                     |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.75M |
| 2nd Quarter                              |     0.79M |
| 3rd Quarter                              |     1.26M |
+======================================================+
| FY3/22 Cumulative                        |     2.80M |
| Life-To-Date                             |    23.90M |
+------------------------------------------------------+
| Super Mario Odyssey                      |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.57M |
| 2nd Quarter                              |     0.55M |
| 3rd Quarter                              |     1.07M |
+======================================================+
| FY3/22 Cumulative                        |     2.19M |
| Life-To-Date                             |    23.02M |
+------------------------------------------------------+
| Super Mario Party                        |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.93M |
| 2nd Quarter                              |     0.76M |
| 3rd Quarter                              |     0.91M |
+======================================================+
| FY3/22 Cumulative                        |     2.60M |
| Life-To-Date                             |    17.39M |
+------------------------------------------------------+
| Pokémon Let's Go Pikachu/Eevee           |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.29M |
| 2nd Quarter                              |     0.26M |
| 3rd Quarter                              |     0.50M |
+======================================================+
| FY3/22 Cumulative                        |     1.05M |
| Life-To-Date                             |    14.33M |
+------------------------------------------------------+
| Pokémon Brilliant Diamond/Shining Pearl  |           |
+------------------------------------------------------+
| 3rd Quarter                              |    13.97M |
+======================================================+
| FY3/22 Cumulative                        |    13.97M |
| Life-To-Date                             |    13.97M |
+------------------------------------------------------+
| Ring Fit Adventure                       |           |
+------------------------------------------------------+
| 1st Quarter                              |     1.15M |
| 2nd Quarter                              |     0.95M |
| 3rd Quarter                              |     1.32M |
+======================================================+
| FY3/22 Cumulative                        |     3.42M |
| Life-To-Date                             |    13.53M |
+------------------------------------------------------+
| Splatoon 2                               |           |
+------------------------------------------------------+
| 1st Quarter                              |     0.24M |
| 2nd Quarter                              |     0.23M |
+======================================================+
| FY3/22 Cumulative                        |     0.47M |
| Life-To-Date                             |    12.68M |
+------------------------------------------------------+

Following from this post I have added even more code to the link I posted above.

Since I was able to get my top ten sellers to sort in descending order I said I might demonstrate making the Capcom Platinum titles list but there was still further improvements to be made.

For example, If I am going to list over 100 titles, how will you know what is ranked 50th? Take a look at the code below.

Now you can tell where something is ranked.

Code:

+------------------------------------------------------+
| Switch - Top Selling Titles              |   Units   |
+------------------------------------------------------+
| Mario Kart 8 Deluxe                      |    Rank 1 |
+------------------------------------------------------+
| 1st Quarter                              |     1.69M |
| 2nd Quarter                              |     1.66M |
| 3rd Quarter                              |     4.61M |
+======================================================+
| FY3/22 Cumulative                        |     7.96M |
| Life-To-Date                             |    43.35M |
+------------------------------------------------------+
| Animal Crossing: New Horizons            |    Rank 2 |
+------------------------------------------------------+
| 1st Quarter                              |     1.26M |
| 2nd Quarter                              |     0.96M |
| 3rd Quarter                              |     2.77M |
+======================================================+
| FY3/22 Cumulative                        |     4.99M |
| Life-To-Date                             |    37.62M |
+------------------------------------------------------+
| Super Smash Bros. Ultimate               |    Rank 3 |
+------------------------------------------------------+
| 1st Quarter                              |     0.93M |
| 2nd Quarter                              |     0.94M |
| 3rd Quarter                              |     1.69M |
+======================================================+
| FY3/22 Cumulative                        |     3.56M |
| Life-To-Date                             |    27.40M |
+------------------------------------------------------+
| The Legend of Zelda: Breath of the Wild  |    Rank 4 |
+------------------------------------------------------+
| 1st Quarter                              |     0.92M |
| 2nd Quarter                              |     0.93M |
| 3rd Quarter                              |     1.67M |
+======================================================+
| FY3/22 Cumulative                        |     3.52M |
| Life-To-Date                             |    25.80M |
+------------------------------------------------------+
| Pokémon Sword/Shield                     |    Rank 5 |
+------------------------------------------------------+
| 1st Quarter                              |     0.75M |
| 2nd Quarter                              |     0.79M |
| 3rd Quarter                              |     1.26M |
+======================================================+
| FY3/22 Cumulative                        |     2.80M |
| Life-To-Date                             |    23.90M |
+------------------------------------------------------+
| Super Mario Odyssey                      |    Rank 6 |
+------------------------------------------------------+
| 1st Quarter                              |     0.57M |
| 2nd Quarter                              |     0.55M |
| 3rd Quarter                              |     1.07M |
+======================================================+
| FY3/22 Cumulative                        |     2.19M |
| Life-To-Date                             |    23.02M |
+------------------------------------------------------+
| Super Mario Party                        |    Rank 7 |
+------------------------------------------------------+
| 1st Quarter                              |     0.93M |
| 2nd Quarter                              |     0.76M |
| 3rd Quarter                              |     0.91M |
+======================================================+
| FY3/22 Cumulative                        |     2.60M |
| Life-To-Date                             |    17.39M |
+------------------------------------------------------+
| Pokémon Let's Go Pikachu/Eevee           |    Rank 8 |
+------------------------------------------------------+
| 1st Quarter                              |     0.29M |
| 2nd Quarter                              |     0.26M |
| 3rd Quarter                              |     0.50M |
+======================================================+
| FY3/22 Cumulative                        |     1.05M |
| Life-To-Date                             |    14.33M |
+------------------------------------------------------+
| Pokémon Brilliant Diamond/Shining Pearl  |    Rank 9 |
+------------------------------------------------------+
| 3rd Quarter                              |    13.97M |
+======================================================+
| FY3/22 Cumulative                        |    13.97M |
| Life-To-Date                             |    13.97M |
+------------------------------------------------------+
| Ring Fit Adventure                       |   Rank 10 |
+------------------------------------------------------+
| 1st Quarter                              |     1.15M |
| 2nd Quarter                              |     0.95M |
| 3rd Quarter                              |     1.32M |
+======================================================+
| FY3/22 Cumulative                        |     3.42M |
| Life-To-Date                             |    13.53M |
+------------------------------------------------------+
| Splatoon 2                               |   Rank 11 |
+------------------------------------------------------+
| 1st Quarter                              |     0.24M |
| 2nd Quarter                              |     0.23M |
+======================================================+
| FY3/22 Cumulative                        |     0.47M |
| Life-To-Date                             |    12.68M |
+------------------------------------------------------+

ggx2ac · Mar 20, 2022

Following from my previous posts where I have been able to add sorting and ranks to the top ten selling Switch titles.

I thought that I could just add those pretty quickly to the Nintendo FY million-seller titles, turns out I was wrong because I forgot that each title has four variables because of regional data. That didn't stop me there though so as I was working through the variable I wanted to sort, I had to figure out how to get the other variables sorted too. I thought of sorting the variables in parallel but I didn't go with that, I thought of putting the variables in matrices, but I didn't go with that either. One thing to note is I keep saying arrays but Python doesn't have built-in functions for arrays and what you think they use as arrays is actually called lists so you can't make matrices either unless you use the NumPY package in Python.

So the solution I arrived at was to just combine the variables of one title together into one array (or list) and then sort the titles by the global fy figures and then split the arrays up back into their original variables so that I don't have to rewrite code to use the function.

Now the million-seller titles are sorted and I added a title count now so it keeps track of the number of titles listed.

See the output below. As usual, the code is here:

nintendo-earnings-data-and-other-video-game-companies/sip3fy3-22.py at main · r134x7/nintendo-earnings-data-and-other-video-game-companies

Ever-evolving personal project. Started out in the repo as Python scripts, now it is TypeScript Front-end React App. For displaying financial information of video game companies that provide adequa...

github.com

Code:

+-------------------------------------------------------------------------------------------+
| Nintendo Switch FY Million-Seller Titles                                                  |
+-------------------------------------------------------------------------------------------+
[ Title: 1 ]
+-------------------------------------------------------------------------------------------+
| Pokémon Brilliant Diamond/Shining Pearl | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    3.79M |      10.18M |    13.97M |     13.97M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    3.79M |      10.18M |    13.97M |     13.97M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   27.13% |      72.87% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
[ Title: 2 ]
+-------------------------------------------------------------------------------------------+
| Mario Kart 8 Deluxe                     | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.20M |       1.50M |     1.69M |     37.08M |
| 2nd Quarter (Units)                     |    0.26M |       1.39M |     1.65M |      1.66M |
| 3rd Quarter (Units)                     |    0.40M |       4.21M |     4.62M |      4.61M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.86M |       7.10M |     7.96M |     43.35M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   10.80% |      89.20% |    18.36% |     81.64% |
+-------------------------------------------------------------------------------------------+
[ Title: 3 ]
+-------------------------------------------------------------------------------------------+
| Mario Party Superstars                  | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    1.13M |       4.30M |     5.43M |      5.43M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    1.13M |       4.30M |     5.43M |      5.43M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   20.81% |      79.19% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
[ Title: 4 ]
+-------------------------------------------------------------------------------------------+
| Animal Crossing: New Horizons           | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.13M |       1.13M |     1.26M |     33.89M |
| 2nd Quarter (Units)                     |    0.12M |       0.84M |     0.96M |      0.96M |
| 3rd Quarter (Units)                     |    0.45M |       2.33M |     2.77M |      2.77M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.70M |       4.30M |     4.99M |     37.62M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   14.03% |      86.17% |    13.26% |     86.74% |
+-------------------------------------------------------------------------------------------+
[ Title: 5 ]
+-------------------------------------------------------------------------------------------+
| The Legend of Zelda: Skyward Sword HD   | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.42M |       3.18M |     3.60M |      3.60M |
| 3rd Quarter (Units)                     |    0.02M |       0.22M |     0.25M |      0.25M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.44M |       3.40M |     3.85M |      3.85M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   11.43% |      88.31% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
[ Title: 6 ]
+-------------------------------------------------------------------------------------------+
| Super Smash Bros. Ultimate              | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.33M |       1.53M |     1.86M |     25.71M |
| 3rd Quarter (Units)                     |    0.44M |       1.26M |     1.70M |      1.69M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.77M |       2.79M |     3.56M |     27.40M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   21.63% |      78.37% |    12.99% |     87.01% |
+-------------------------------------------------------------------------------------------+
[ Title: 7 ]
+-------------------------------------------------------------------------------------------+
| The Legend of Zelda: Breath of the Wild | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.16M |       1.70M |     1.85M |     24.13M |
| 3rd Quarter (Units)                     |    0.24M |       1.41M |     1.67M |      1.67M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.40M |       3.11M |     3.52M |     25.80M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   11.36% |      88.35% |    13.64% |     86.36% |
+-------------------------------------------------------------------------------------------+
[ Title: 8 ]
+-------------------------------------------------------------------------------------------+
| Ring Fit Adventure                      | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.25M |       0.89M |     1.15M |     11.26M |
| 2nd Quarter (Units)                     |    0.27M |       0.69M |     0.95M |      0.95M |
| 3rd Quarter (Units)                     |    0.28M |       1.04M |     1.32M |      1.32M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.80M |       2.62M |     3.42M |     13.53M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   23.39% |      76.61% |    25.28% |     74.72% |
+-------------------------------------------------------------------------------------------+
[ Title: 9 ]
+-------------------------------------------------------------------------------------------+
| Super Mario 3D World + Boswer's Fury    | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.21M |       0.87M |     1.09M |      6.68M |
| 2nd Quarter (Units)                     |    0.15M |       0.63M |     0.77M |      0.77M |
| 3rd Quarter (Units)                     |    0.18M |       1.22M |     1.40M |      1.40M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.54M |       2.72M |     3.26M |      8.85M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   16.56% |      83.44% |    36.84% |     63.16% |
+-------------------------------------------------------------------------------------------+
[ Title: 10 ]
+-------------------------------------------------------------------------------------------+
| Pokémon Sword/Shield                    | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.19M |       1.35M |     1.54M |     22.64M |
| 3rd Quarter (Units)                     |    0.23M |       1.03M |     1.26M |      1.26M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.42M |       2.38M |     2.80M |     23.90M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   15.00% |      85.00% |    11.72% |     88.28% |
+-------------------------------------------------------------------------------------------+
[ Title: 11 ]
+-------------------------------------------------------------------------------------------+
| Metroid Dread                           | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    0.26M |       2.48M |     2.74M |      2.74M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.26M |       2.48M |     2.74M |      2.74M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |    9.49% |      90.51% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
[ Title: 12 ]
+-------------------------------------------------------------------------------------------+
| Super Mario Party                       | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.22M |       1.47M |     1.68M |     16.48M |
| 3rd Quarter (Units)                     |    0.07M |       0.83M |     0.91M |      0.91M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.29M |       2.30M |     2.59M |     17.39M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   11.20% |      88.80% |    14.89% |     85.11% |
+-------------------------------------------------------------------------------------------+
[ Title: 13 ]
+-------------------------------------------------------------------------------------------+
| New Pokémon Snap                        | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.00M |       2.07M |     2.07M |      2.07M |
| 2nd Quarter (Units)                     |    0.00M |       0.12M |     0.12M |      0.12M |
| 3rd Quarter (Units)                     |    0.00M |       0.17M |     0.17M |      0.17M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.00M |       2.36M |     2.36M |      2.36M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |    0.00% |     100.00% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
[ Title: 14 ]
+-------------------------------------------------------------------------------------------+
| New Super Mario Bros. U Deluxe          | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.08M |       0.96M |     1.03M |     11.48M |
| 3rd Quarter (Units)                     |    0.06M |       1.17M |     1.25M |      1.24M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.14M |       2.13M |     2.28M |     12.72M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |    6.14% |      93.42% |    17.92% |     82.08% |
+-------------------------------------------------------------------------------------------+
[ Title: 15 ]
+-------------------------------------------------------------------------------------------+
| Mario Golf: Super Rush                  | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.21M |       1.13M |     1.34M |      1.34M |
| 2nd Quarter (Units)                     |    0.08M |       0.52M |     0.60M |      0.60M |
| 3rd Quarter (Units)                     |    0.01M |       0.31M |     0.32M |      0.32M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.30M |       1.96M |     2.26M |      2.26M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   13.27% |      86.73% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
[ Title: 16 ]
+-------------------------------------------------------------------------------------------+
| Super Mario Odyssey                     | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 2nd Quarter (Units)                     |    0.08M |       1.03M |     1.12M |     21.95M |
| 3rd Quarter (Units)                     |    0.07M |       1.01M |     1.07M |      1.07M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.15M |       2.04M |     2.19M |     23.02M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |    6.85% |      93.15% |     9.51% |     90.49% |
+-------------------------------------------------------------------------------------------+
[ Title: 17 ]
+-------------------------------------------------------------------------------------------+
| Miitopia                                | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 1st Quarter (Units)                     |    0.26M |       0.78M |     1.04M |      1.04M |
| 2nd Quarter (Units)                     |    0.09M |       0.24M |     0.33M |      0.33M |
| 3rd Quarter (Units)                     |    0.03M |       0.23M |     0.26M |      0.26M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.38M |       1.25M |     1.63M |      1.63M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   23.31% |      76.69% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
[ Title: 18 ]
+-------------------------------------------------------------------------------------------+
| Luigi's Mansion 3                       | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    0.09M |       1.36M |     1.45M |     11.04M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.09M |       1.36M |     1.45M |     11.04M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |    6.21% |      93.79% |    13.13% |     86.87% |
+-------------------------------------------------------------------------------------------+
[ Title: 19 ]
+-------------------------------------------------------------------------------------------+
| Big Brain Academy: Brain vs Brain       | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    0.38M |       0.90M |     1.28M |      1.28M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.38M |       0.90M |     1.28M |      1.28M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   29.69% |      70.31% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
[ Title: 20 ]
+-------------------------------------------------------------------------------------------+
| WarioWare: Get It Together!             | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    0.30M |       0.94M |     1.24M |      1.24M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.30M |       0.94M |     1.24M |      1.24M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   24.19% |      75.81% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
[ Title: 21 ]
+-------------------------------------------------------------------------------------------+
| Pokémon: Let's Go, Pikachu!/Eevee!      | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    0.03M |       1.02M |     1.05M |     14.33M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.03M |       1.02M |     1.05M |     14.33M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |    2.86% |      97.14% |     7.33% |     92.67% |
+-------------------------------------------------------------------------------------------+
[ Title: 22 ]
+-------------------------------------------------------------------------------------------+
| Game Builder Garage                     | FY Japan | FY Overseas | FY Global | Global LTD |
+-------------------------------------------------------------------------------------------+
| 3rd Quarter (Units)                     |    0.44M |       0.58M |     1.01M |      1.01M |
+===========================================================================================+
| FY3/22 Cumulative (Units)               |    0.44M |       0.58M |     1.01M |      1.01M |
| FY3/22 Cumulative Area/WW FY, WW FY/LTD |   43.56% |      57.43% |   100.00% |      0.00% |
+-------------------------------------------------------------------------------------------+
###

ggx2ac · Apr 9, 2022

So the next thing I am working on is to refactor my code to make it more human readable and to split up the function into smaller parts. Since I thought of using mobile-friendly output on the code in the Capcom thread linked here , I decided then that I should also add it to the Nintendo earnings code even though no one has even asked.

What will happen when I make the next earnings thread is that there'll be more posts in the beginning because one will have the original output while the other will have the mobile output.

Below is the mobile output for one of the files I have done, the file is already updated on the repository https://github.com/r134x7/nintendo-earnings-data-and-other-video-game-companies/blob/main/Nintendo/Nintendo FY3-2022/earningsfy3-22.py

Edit: I noticed something so I did some further changes to remove rows from the operating margin. See below

Code:

+--------------------------------------+
| Nintendo Co., Ltd.|                  |
+--------------------------------------+
| Net Sales         |                  |
+--------------------------------------+
| 1st Quarter       |        ¥322,647M |
| 1st Quarter YoY%  |           -9.90% |
+--------------------------------------+
| 2nd Quarter       |        ¥301,625M |
| 2nd Quarter YoY%  |          -26.69% |
+--------------------------------------+
| 3rd Quarter       |        ¥695,947M |
| 3rd Quarter YoY%  |           +9.61% |
+======================================+
| First Half        |        ¥624,272M |
| First Half YoY%   |          -18.88% |
+--------------------------------------+
| First 3 Quarters  |      ¥1,320,219M |
| First 3 Qtrs YoY% |           -6.00% |
+--------------------------------------+
| FY3/22 Cumulative |      ¥1,320,219M |
+--------------------------------------+
| FY3/22 Forecast   |      ¥1,600,000M |
| 1st FCST Revision |      ¥1,600,000M |
| 2nd FCST Revision |      ¥1,650,000M |
+--------------------------------------+
###
+--------------------------------------+
| Operating Income  |                  |
+--------------------------------------+
| 1st Quarter       |        ¥119,752M |
| 1st Quarter YoY%  |          -17.26% |
+--------------------------------------+
| 2nd Quarter       |        ¥100,207M |
| 2nd Quarter YoY%  |          -31.69% |
+--------------------------------------+
| 3rd Quarter       |        ¥252,592M |
| 3rd Quarter YoY%  |           +9.97% |
+======================================+
| First Half        |        ¥219,959M |
| First Half YoY%   |          -24.52% |
+--------------------------------------+
| First 3 Quarters  |        ¥472,551M |
| First 3 Qtrs YoY% |           -9.32% |
+--------------------------------------+
| FY3/22 Cumulative |        ¥472,551M |
+--------------------------------------+
| FY3/22 Forecast   |        ¥500,000M |
| 1st FCST Revision |        ¥520,000M |
| 2nd FCST Revision |        ¥560,000M |
+--------------------------------------+
###
+--------------------------------------+
| Operating Margin  |                  |
+--------------------------------------+
| 1st Quarter       |           37.12% |
+--------------------------------------+
| 2nd Quarter       |           33.22% |
+--------------------------------------+
| 3rd Quarter       |           36.29% |
+======================================+
| First Half        |           35.23% |
+--------------------------------------+
| First 3 Quarters  |           35.79% |
+--------------------------------------+
| FY3/22 Cumulative |           35.79% |
+--------------------------------------+
| FY3/22 Forecast   |           31.25% |
| 1st FCST Revision |           32.50% |
| 2nd FCST Revision |           33.94% |
+--------------------------------------+
###
+--------------------------------------+
| Net Profit        |                  |
+--------------------------------------+
| 1st Quarter       |         ¥92,747M |
| 1st Quarter YoY%  |          -12.90% |
+--------------------------------------+
| 2nd Quarter       |         ¥79,087M |
| 2nd Quarter YoY%  |          -25.84% |
+--------------------------------------+
| 3rd Quarter       |        ¥195,553M |
| 3rd Quarter YoY%  |          +19.57% |
+======================================+
| First Half        |        ¥171,834M |
| First Half YoY%   |          -19.37% |
+--------------------------------------+
| First 3 Quarters  |        ¥367,387M |
| First 3 Qtrs YoY% |           -2.46% |
+--------------------------------------+
| FY3/22 Cumulative |        ¥367,387M |
+--------------------------------------+
| FY3/22 Forecast   |        ¥340,000M |
| 1st FCST Revision |        ¥350,000M |
| 2nd FCST Revision |        ¥400,000M |
+--------------------------------------+
###

ggx2ac · Apr 10, 2022

I still did further code refactoring for the file above.

What happened was that as I was trying to use for loops for the quarterly calculations and then for loops to sum up those quarters again to make first half/first three quarters/fiscal year cumulative, there was something wrong that I noticed:

Code:

    for i in range(3):
        if i == 0:
            y1.append(y1[i+1] + y1[i]) # fy first half y1[9]
        elif i == 1:
            y1.append(y1[i+1] + y1[i] + y1[i-1]) # fy three quarters y1[10]
        else: y1.append(y1[i+1] + y1[i] + y1[i-1] + y1[i-2]) # fy cumulative to array becomes y1[11]

What was wrong with this piece of code was that it was really crappy.

This didn't use a for loop and if statements before, it was just the append statements. Why it was crappy was because this didn't make a simpler solution compared to what I had before. However, with the code above I was noticing a pattern, every time a new quarter appeared the formula got longer with a new index requiring an addition, the current quarter and the length of the formula are proportional as the current quarter approaches infinity. So I thought, "Could this be solved with recursion?". I only thought that because I watched a few YouTube videos recently but I had still not made a recursive function.

I then watched a few videos on recursion from this YouTube channel and the one I recommend to watch for anyone curious would be this video:

Of course the video shown uses a completely different recursive function compared to what I had to make to solve the problem with my crappy code. I still had to figure that out myself, I had watched enough videos to get an idea of how a recursive function works. I make a function where it has at least two return statements, one terminates the function if a certain condition is met and the other calls the function over again.

With that in mind I just went to type out what I needed to do. At first I remembered seeing in one of the videos from the channel above a recursive function for factorials, so I first wrote out code based on that since it had a similar structure for what I was going for.

Code:

sum(x):

    if x == 2
        return x
    elif x != 2
        return x + sum(x-1)

Note, this wasn't typed out in an IDE so I had to run the function in my head using sum(4) and that's when I noticed it was too much like the recursive function for factorials since it would be going backwards compared to what the result was that I wanted. So I made some slight changes and also added how I needed this to put the number into an array.

Code:

sum(x):

    if x == 4
        return x
    elif x != 4
        y1.append(x)
        return x + sum(x+1)

I then got onto an IDE and went to make one more adjustment before running the code:

Code:

sum(x):

    if x == y1[3]
        return
    elif x != y1[3]
        y1.append(x)
        print(y1)
        return x + sum(x+1)
        
sum(y1[0])

I then ran the code, and what happened? The terminal was printing out the whole array of y1 an infinite amount of times of which I could see the value of y1[0] appearing repeatedly because it gets added to the end of the array through every loop. It was amazing watching it run up to a thousand loops printing that array repeatedly. Luckily I was using Python because it will stop the recursion with a recursion error if it goes beyond one thousand loops, this is so that it prevents the computer from having a stack overflow (of the memory).

I then went and tried to think up a number of solutions especially to figure out how to get to the other indexes in the list, and then I did this:

The success was that I made progress, instead of it just looping the same number over and over again, it now displayed different numbers in the array. After spending some more time I then got it to work of which I ended up with this code:

Code:

    def sum(x, i): #recursive function to get: fy first half y1[9], fy three quarters y1[10] fy cumulative y1[11]

        if x == (y1[0] + y1[1] + y1[2] + y1[3]): # to end the function
            y1.append(x)
            print(y1)
            return
        elif x != (y1[0] + y1[1] + y1[2] + y1[3]):
            if x == y1[0]: # Q1 alone is not needed
                i += 1
                return sum(x + y1[i], i)
            else:
                y1.append(x)
                i += 1
                print(y1)
                return sum(x + y1[i], i)

    sum(y1[0], 0)

However, the problem I noticed was that it was ending its loop early because I had not created the correct if statement to cover all quarters with no issues.

So after trying to fix things up the final code looks like this:

Code:

    def sum_a(x, i): #recursive function to get: fy first half y1[9], fy three quarters y1[10] fy cumulative y1[11]
        if x == y1[0]: # Q1 alone is not needed
            i += 1
            return sum_a(x + y1[i], i)
        else:
            y1.append(x)
            i += 1
            if x == (y1[0] + y1[1] + y1[2] + y1[3]) and i == 4: # to end the function correctly
                return
            else:
                return sum_a(x + y1[i], i)

    sum_a(y1[0], 0)

That wasn't the only recursive function I made, in that one file there are three recursive functions that are similar but having to deal with different numbers, you can look at the rest of them here: https://github.com/r134x7/nintendo-.../Nintendo/Nintendo FY3-2022/earningsfy3-22.py

Now, was this really needed? No, technically I already had the cumulative numbers in the input figures that I could have just used them instead of coming up with this solution to sum up a bunch of quarters inside the function. So there was a simpler solution that I didn't use.

Why did I do this then? So that I could learn how to use recursion. If you look at the file I linked it still has all my old code in it, you will find in that old code two different segments. The oldest one is at the bottom of which you'll find it uses no for loops and no functions, back then I didn't use them because I didn't know how to use them, once I got to know how to use them then I was able to reduce the lines of code used that I no longer had to maintain files that contained 2000+ lines of code. So as I learn recursion I can probably solve something that I can't figure out how to do well with a for loop.

ggx2ac · Apr 15, 2022

Below is the mobile output for the hwswunitsfy3-22 file, note that it takes time having to refactor code and then add the mobile output. As usual the repository is updated.

Code:

+----------------------------------+
| Switch            |      (units) |
+----------------------------------+
| 1st Quarter       |        3.31M |
| 1st Quarter YoY%  |       +8.52% |
+----------------------------------+
| 2nd Quarter       |        3.14M |
| 2nd Quarter YoY%  |      -40.87% |
+----------------------------------+
| 3rd Quarter       |        5.34M |
| 3rd Quarter YoY%  |      -36.50% |
+==================================+
| First Half        |        6.45M |
| First Half YoY%   |      -22.85% |
+----------------------------------+
| First 3 Quarters  |       11.79M |
| First 3 Qtrs YoY% |      -29.70% |
+----------------------------------+
| FY3/22 Cumulative |       11.79M |
+----------------------------------+
| LTD               |       81.68M |
+----------------------------------+
###
+----------------------------------+
| Switch Lite       |      (units) |
+----------------------------------+
| 1st Quarter       |        1.14M |
| 1st Quarter YoY%  |      -56.49% |
+----------------------------------+
| 2nd Quarter       |        0.68M |
| 2nd Quarter YoY%  |      -56.13% |
+----------------------------------+
| 3rd Quarter       |        1.35M |
| 3rd Quarter YoY%  |      -57.28% |
+==================================+
| First Half        |        1.82M |
| First Half YoY%   |      -56.35% |
+----------------------------------+
| First 3 Quarters  |        3.17M |
| First 3 Qtrs YoY% |      -56.75% |
+----------------------------------+
| FY3/22 Cumulative |        3.17M |
+----------------------------------+
| LTD               |       17.87M |
+----------------------------------+
###
+----------------------------------+
| Switch OLED       |      (units) |
+----------------------------------+
| 3rd Quarter       |        3.99M |
+==================================+
| First 3 Quarters  |        3.99M |
+----------------------------------+
| FY3/22 Cumulative |        3.99M |
+----------------------------------+
| LTD               |        3.99M |
+----------------------------------+
###
+----------------------------------+
| Hardware Total    |      (units) |
+----------------------------------+
| 1st Quarter       |        4.45M |
| 1st Quarter YoY%  |      -21.65% |
+----------------------------------+
| 2nd Quarter       |        3.83M |
| 2nd Quarter YoY%  |      -44.09% |
+----------------------------------+
| 3rd Quarter       |       10.67M |
| 3rd Quarter YoY%  |       -7.78% |
+==================================+
| First Half        |        8.28M |
| First Half YoY%   |      -33.92% |
+----------------------------------+
| First 3 Quarters  |       18.95M |
| First 3 Qtrs YoY% |      -21.37% |
+----------------------------------+
| FY3/22 Cumulative |       18.95M |
+----------------------------------+
| LTD               |      103.54M |
+----------------------------------+
| FY3/22 Forecast   |       25.50M |
| 1st FCST Revision |       24.00M |
| 2nd FCST Revision |       23.00M |
+----------------------------------+
###
+----------------------------------+
| Software Total    |      (units) |
+----------------------------------+
| 1st Quarter       |       45.29M |
| 1st Quarter YoY%  |      -10.19% |
+----------------------------------+
| 2nd Quarter       |       48.60M |
| 2nd Quarter YoY%  |       -2.45% |
+----------------------------------+
| 3rd Quarter       |       85.40M |
| 3rd Quarter YoY%  |      +12.59% |
+==================================+
| First Half        |       93.89M |
| First Half YoY%   |       -6.34% |
+----------------------------------+
| First 3 Quarters  |      179.29M |
| First 3 Qtrs YoY% |       +1.81% |
+----------------------------------+
| FY3/22 Cumulative |      179.29M |
+----------------------------------+
| LTD               |      766.41M |
+----------------------------------+
| FY3/22 Forecast   |      190.00M |
| 1st FCST Revision |      200.00M |
| 2nd FCST Revision |      220.00M |
+----------------------------------+
(Software sales units include both
packaged and downloadable versions
of software.)
###
+----------------------------------+
| Mobile, IP related income, etc.  |
+----------------------------------+
| 1st Quarter       |     ¥13,199M |
| 1st Quarter YoY%  |       -0.59% |
+----------------------------------+
| 2nd Quarter       |     ¥12,302M |
| 2nd Quarter YoY%  |       -8.53% |
+----------------------------------+
| 3rd Quarter       |     ¥14,324M |
| 3rd Quarter YoY%  |       -6.28% |
+==================================+
| First Half        |     ¥25,501M |
| First Half YoY%   |       -4.59% |
+----------------------------------+
| First 3 Quarters  |     ¥39,825M |
| First 3 Qtrs YoY% |       -5.20% |
+----------------------------------+
| FY3/22 Cumulative |     ¥39,825M |
+----------------------------------+
(Includes income from smart-device
content and royalty income.)
###

ggx2ac · Apr 16, 2022

This one is an important update because now that I have fixed the issue which was occurring for the Capcom Platinum Titles (not getting long titles split right into two lines), I can now go back to that file and apply what I have done on the top ten selling Switch titles below.

You will see that now, any long titles will split and go down to the next line and it will not be like the capcom platinum titles output currently where you get something like:

Code:

"The
Title
Split up like this"

Output:
(edit: fixed it)

Code:

+-------------------------------------------+
| Switch - Top Selling Titles    |    Units |
+-------------------------------------------+
| Mario Kart 8 Deluxe            |   Rank 1 |
+-------------------------------------------+
| 1st Quarter                    |    1.69M |
| 2nd Quarter                    |    1.66M |
| 3rd Quarter                    |    4.61M |
+===========================================+
| FY3/22  Cumulative             |    7.96M |
| Life-To-Date                   |   43.35M |
+-------------------------------------------+
| Animal Crossing: New Horizons  |   Rank 2 |
+-------------------------------------------+
| 1st Quarter                    |    1.26M |
| 2nd Quarter                    |    0.96M |
| 3rd Quarter                    |    2.77M |
+===========================================+
| FY3/22  Cumulative             |    4.99M |
| Life-To-Date                   |   37.62M |
+-------------------------------------------+
| Super Smash Bros. Ultimate     |   Rank 3 |
+-------------------------------------------+
| 1st Quarter                    |    0.93M |
| 2nd Quarter                    |    0.94M |
| 3rd Quarter                    |    1.69M |
+===========================================+
| FY3/22  Cumulative             |    3.56M |
| Life-To-Date                   |   27.40M |
+-------------------------------------------+
| The Legend of Zelda: Breath of |          |
| the Wild                       |   Rank 4 |
+-------------------------------------------+
| 1st Quarter                    |    0.92M |
| 2nd Quarter                    |    0.93M |
| 3rd Quarter                    |    1.67M |
+===========================================+
| FY3/22  Cumulative             |    3.52M |
| Life-To-Date                   |   25.80M |
+-------------------------------------------+
| Pokémon Sword / Pokémon Shield |   Rank 5 |
+-------------------------------------------+
| 1st Quarter                    |    0.75M |
| 2nd Quarter                    |    0.79M |
| 3rd Quarter                    |    1.26M |
+===========================================+
| FY3/22  Cumulative             |    2.80M |
| Life-To-Date                   |   23.90M |
+-------------------------------------------+
| Super Mario Odyssey            |   Rank 6 |
+-------------------------------------------+
| 1st Quarter                    |    0.57M |
| 2nd Quarter                    |    0.55M |
| 3rd Quarter                    |    1.07M |
+===========================================+
| FY3/22  Cumulative             |    2.19M |
| Life-To-Date                   |   23.02M |
+-------------------------------------------+
| Super Mario Party              |   Rank 7 |
+-------------------------------------------+
| 1st Quarter                    |    0.93M |
| 2nd Quarter                    |    0.76M |
| 3rd Quarter                    |    0.91M |
+===========================================+
| FY3/22  Cumulative             |    2.60M |
| Life-To-Date                   |   17.39M |
+-------------------------------------------+
| Pokémon Let's Go Pikachu /     |          |
| Pokémon Let's Go Eevee         |   Rank 8 |
+-------------------------------------------+
| 1st Quarter                    |    0.29M |
| 2nd Quarter                    |    0.26M |
| 3rd Quarter                    |    0.50M |
+===========================================+
| FY3/22  Cumulative             |    1.05M |
| Life-To-Date                   |   14.33M |
+-------------------------------------------+
| Pokémon Brilliant Diamond /    |          |
| Pokémon Shining Pearl          |   Rank 9 |
+-------------------------------------------+
| 3rd Quarter                    |   13.97M |
+===========================================+
| FY3/22  Cumulative             |   13.97M |
| Life-To-Date                   |   13.97M |
+-------------------------------------------+
| Ring Fit Adventure             |  Rank 10 |
+-------------------------------------------+
| 1st Quarter                    |    1.15M |
| 2nd Quarter                    |    0.95M |
| 3rd Quarter                    |    1.32M |
+===========================================+
| FY3/22  Cumulative             |    3.42M |
| Life-To-Date                   |   13.53M |
+-------------------------------------------+
| Splatoon 2                     |  Rank 11 |
+-------------------------------------------+
| 1st Quarter                    |    0.24M |
| 2nd Quarter                    |    0.23M |
+===========================================+
| FY3/22  Cumulative             |    0.47M |
| Life-To-Date                   |   12.68M |
+-------------------------------------------+

ggx2ac · Apr 16, 2022

Next, the mobile output for the Nintendo Switch FY Million-Seller Titles.

Code:

+------------------------------------------+
| Nintendo Switch FY Million-Seller Titles |
+------------------------------------------+
+------------------------------------------+
| Title and Rank                           |
+------------------------------------------+
| Units                                    |
+------------------------------------------+
+------------------------------------------+
| Pokémon Brilliant Diamond /    |         |
| Pokémon Shining Pearl          | Rank 1  |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       3.79M |      10.18M |
+==========================================+
| FY3/22 Cml.  |       3.79M |      10.18M |
| Area/WW FY % |      27.13% |      72.87% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |      13.97M |      13.97M |
+==========================================+
| FY3/22 Cml.  |      13.97M |      13.97M |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Mario Kart 8 Deluxe            | Rank 2  |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.20M |       1.50M |
| 2nd Quarter  |       0.26M |       1.39M |
| 3rd Quarter  |       0.40M |       4.21M |
+==========================================+
| FY3/22 Cml.  |       0.86M |       7.10M |
| Area/WW FY % |      10.80% |      89.20% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       1.69M |      37.08M |
| 2nd Quarter  |       1.65M |       1.66M |
| 3rd Quarter  |       4.62M |       4.61M |
+==========================================+
| FY3/22 Cml.  |       7.96M |      43.35M |
| WW FY/LTD %  |      18.36% |      81.64% |
+------------------------------------------+
+------------------------------------------+
| Mario Party Superstars         | Rank 3  |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       1.13M |       4.30M |
+==========================================+
| FY3/22 Cml.  |       1.13M |       4.30M |
| Area/WW FY % |      20.81% |      79.19% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       5.43M |       5.43M |
+==========================================+
| FY3/22 Cml.  |       5.43M |       5.43M |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Animal Crossing: New Horizons  | Rank 4  |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.13M |       1.13M |
| 2nd Quarter  |       0.12M |       0.84M |
| 3rd Quarter  |       0.45M |       2.33M |
+==========================================+
| FY3/22 Cml.  |       0.70M |       4.30M |
| Area/WW FY % |      14.03% |      86.17% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       1.26M |      33.89M |
| 2nd Quarter  |       0.96M |       0.96M |
| 3rd Quarter  |       2.77M |       2.77M |
+==========================================+
| FY3/22 Cml.  |       4.99M |      37.62M |
| WW FY/LTD %  |      13.26% |      86.74% |
+------------------------------------------+
+------------------------------------------+
| The Legend of Zelda: Skyward   |         |
| Sword HD                       | Rank 5  |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.42M |       3.18M |
| 3rd Quarter  |       0.02M |       0.22M |
+==========================================+
| FY3/22 Cml.  |       0.44M |       3.40M |
| Area/WW FY % |      11.43% |      88.31% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       3.60M |       3.60M |
| 3rd Quarter  |       0.25M |       0.25M |
+==========================================+
| FY3/22 Cml.  |       3.85M |       3.85M |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Super Smash Bros. Ultimate     | Rank 6  |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.33M |       1.53M |
| 3rd Quarter  |       0.44M |       1.26M |
+==========================================+
| FY3/22 Cml.  |       0.77M |       2.79M |
| Area/WW FY % |      21.63% |      78.37% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       1.86M |      25.71M |
| 3rd Quarter  |       1.70M |       1.69M |
+==========================================+
| FY3/22 Cml.  |       3.56M |      27.40M |
| WW FY/LTD %  |      12.99% |      87.01% |
+------------------------------------------+
+------------------------------------------+
| The Legend of Zelda: Breath of |         |
| the Wild                       | Rank 7  |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.16M |       1.70M |
| 3rd Quarter  |       0.24M |       1.41M |
+==========================================+
| FY3/22 Cml.  |       0.40M |       3.11M |
| Area/WW FY % |      11.36% |      88.35% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       1.85M |      24.13M |
| 3rd Quarter  |       1.67M |       1.67M |
+==========================================+
| FY3/22 Cml.  |       3.52M |      25.80M |
| WW FY/LTD %  |      13.64% |      86.36% |
+------------------------------------------+
+------------------------------------------+
| Ring Fit Adventure             | Rank 8  |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.25M |       0.89M |
| 2nd Quarter  |       0.27M |       0.69M |
| 3rd Quarter  |       0.28M |       1.04M |
+==========================================+
| FY3/22 Cml.  |       0.80M |       2.62M |
| Area/WW FY % |      23.39% |      76.61% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       1.15M |      11.26M |
| 2nd Quarter  |       0.95M |       0.95M |
| 3rd Quarter  |       1.32M |       1.32M |
+==========================================+
| FY3/22 Cml.  |       3.42M |      13.53M |
| WW FY/LTD %  |      25.28% |      74.72% |
+------------------------------------------+
+------------------------------------------+
| Super Mario 3D World +         |         |
| Boswer's Fury                  | Rank 9  |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.21M |       0.87M |
| 2nd Quarter  |       0.15M |       0.63M |
| 3rd Quarter  |       0.18M |       1.22M |
+==========================================+
| FY3/22 Cml.  |       0.54M |       2.72M |
| Area/WW FY % |      16.56% |      83.44% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       1.09M |       6.68M |
| 2nd Quarter  |       0.77M |       0.77M |
| 3rd Quarter  |       1.40M |       1.40M |
+==========================================+
| FY3/22 Cml.  |       3.26M |       8.85M |
| WW FY/LTD %  |      36.84% |      63.16% |
+------------------------------------------+
+------------------------------------------+
| Pokémon Sword / Pokémon Shield | Rank 10 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.19M |       1.35M |
| 3rd Quarter  |       0.23M |       1.03M |
+==========================================+
| FY3/22 Cml.  |       0.42M |       2.38M |
| Area/WW FY % |      15.00% |      85.00% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       1.54M |      22.64M |
| 3rd Quarter  |       1.26M |       1.26M |
+==========================================+
| FY3/22 Cml.  |       2.80M |      23.90M |
| WW FY/LTD %  |      11.72% |      88.28% |
+------------------------------------------+
+------------------------------------------+
| Metroid Dread                  | Rank 11 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       0.26M |       2.48M |
+==========================================+
| FY3/22 Cml.  |       0.26M |       2.48M |
| Area/WW FY % |       9.49% |      90.51% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       2.74M |       2.74M |
+==========================================+
| FY3/22 Cml.  |       2.74M |       2.74M |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Super Mario Party              | Rank 12 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.22M |       1.47M |
| 3rd Quarter  |       0.07M |       0.83M |
+==========================================+
| FY3/22 Cml.  |       0.29M |       2.30M |
| Area/WW FY % |      11.20% |      88.80% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       1.68M |      16.48M |
| 3rd Quarter  |       0.91M |       0.91M |
+==========================================+
| FY3/22 Cml.  |       2.59M |      17.39M |
| WW FY/LTD %  |      14.89% |      85.11% |
+------------------------------------------+
+------------------------------------------+
| New Pokémon Snap               | Rank 13 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.00M |       2.07M |
| 2nd Quarter  |       0.00M |       0.12M |
| 3rd Quarter  |       0.00M |       0.17M |
+==========================================+
| FY3/22 Cml.  |       0.00M |       2.36M |
| Area/WW FY % |       0.00% |     100.00% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       2.07M |       2.07M |
| 2nd Quarter  |       0.12M |       0.12M |
| 3rd Quarter  |       0.17M |       0.17M |
+==========================================+
| FY3/22 Cml.  |       2.36M |       2.36M |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| New Super Mario Bros. U Deluxe | Rank 14 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.08M |       0.96M |
| 3rd Quarter  |       0.06M |       1.17M |
+==========================================+
| FY3/22 Cml.  |       0.14M |       2.13M |
| Area/WW FY % |       6.14% |      93.42% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       1.03M |      11.48M |
| 3rd Quarter  |       1.25M |       1.24M |
+==========================================+
| FY3/22 Cml.  |       2.28M |      12.72M |
| WW FY/LTD %  |      17.92% |      82.08% |
+------------------------------------------+
+------------------------------------------+
| Mario Golf: Super Rush         | Rank 15 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.21M |       1.13M |
| 2nd Quarter  |       0.08M |       0.52M |
| 3rd Quarter  |       0.01M |       0.31M |
+==========================================+
| FY3/22 Cml.  |       0.30M |       1.96M |
| Area/WW FY % |      13.27% |      86.73% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       1.34M |       1.34M |
| 2nd Quarter  |       0.60M |       0.60M |
| 3rd Quarter  |       0.32M |       0.32M |
+==========================================+
| FY3/22 Cml.  |       2.26M |       2.26M |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Super Mario Odyssey            | Rank 16 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.08M |       1.03M |
| 3rd Quarter  |       0.07M |       1.01M |
+==========================================+
| FY3/22 Cml.  |       0.15M |       2.04M |
| Area/WW FY % |       6.85% |      93.15% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       1.12M |      21.95M |
| 3rd Quarter  |       1.07M |       1.07M |
+==========================================+
| FY3/22 Cml.  |       2.19M |      23.02M |
| WW FY/LTD %  |       9.51% |      90.49% |
+------------------------------------------+
+------------------------------------------+
| Miitopia                       | Rank 17 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.26M |       0.78M |
| 2nd Quarter  |       0.09M |       0.24M |
| 3rd Quarter  |       0.03M |       0.23M |
+==========================================+
| FY3/22 Cml.  |       0.38M |       1.25M |
| Area/WW FY % |      23.31% |      76.69% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       1.04M |       1.04M |
| 2nd Quarter  |       0.33M |       0.33M |
| 3rd Quarter  |       0.26M |       0.26M |
+==========================================+
| FY3/22 Cml.  |       1.63M |       1.63M |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Luigi's Mansion 3              | Rank 18 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       0.09M |       1.36M |
+==========================================+
| FY3/22 Cml.  |       0.09M |       1.36M |
| Area/WW FY % |       6.21% |      93.79% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       1.45M |      11.04M |
+==========================================+
| FY3/22 Cml.  |       1.45M |      11.04M |
| WW FY/LTD %  |      13.13% |      86.87% |
+------------------------------------------+
+------------------------------------------+
| Big Brain Academy: Brain vs    |         |
| Brain                          | Rank 19 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       0.38M |       0.90M |
+==========================================+
| FY3/22 Cml.  |       0.38M |       0.90M |
| Area/WW FY % |      29.69% |      70.31% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       1.28M |       1.28M |
+==========================================+
| FY3/22 Cml.  |       1.28M |       1.28M |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| WarioWare: Get It Together!    | Rank 20 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       0.30M |       0.94M |
+==========================================+
| FY3/22 Cml.  |       0.30M |       0.94M |
| Area/WW FY % |      24.19% |      75.81% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       1.24M |       1.24M |
+==========================================+
| FY3/22 Cml.  |       1.24M |       1.24M |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Pokémon: Let's Go, Pikachu! /  |         |
| Pokémon: Let's Go, Eevee!      | Rank 21 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       0.03M |       1.02M |
+==========================================+
| FY3/22 Cml.  |       0.03M |       1.02M |
| Area/WW FY % |       2.86% |      97.14% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       1.05M |      14.33M |
+==========================================+
| FY3/22 Cml.  |       1.05M |      14.33M |
| WW FY/LTD %  |       7.33% |      92.67% |
+------------------------------------------+
+------------------------------------------+
| Game Builder Garage            | Rank 22 |
+------------------------------------------+
| Area (units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       0.44M |       0.58M |
+==========================================+
| FY3/22 Cml.  |       0.44M |       0.58M |
| Area/WW FY % |      43.56% |      57.43% |
+------------------------------------------+
| WW (units)   |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       1.01M |       1.01M |
+==========================================+
| FY3/22 Cml.  |       1.01M |       1.01M |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
###

ggx2ac · Apr 17, 2022

All my files have been refactored and have had mobile friendly outputs added.

When the next earnings result occurs, there will probably be at least three posts needed to cover posting everything in the mobile output and the original output.

Below is the last of the mobile outputs. This is for the regional data which takes up a lot of space and characters.
I wanted to compress everything down to keep the amount of tables the same and not have the regions take up different rows.

Code:

+--------------------------------------------+
| Switch | Japan  |The     | Europe | Other  |
|        |        |Americas|        |        |
+--------------------------------------------+
|Quarters|                                   |
+--------------------------------------------+
|1. Units|  0.83M |  1.10M |  0.82M |  0.56M |
|1. YoY% | +5.06% |+54.93% | -1.20% |-23.29% |
|1. WW%  | 25.08% | 33.23% | 24.77% | 16.92% |
+--------------------------------------------+
|2. Units|  0.75M |  1.05M |  0.81M |  0.53M |
|2. YoY% |-34.21% |-44.15% |-39.10% |-44.21% |
|2. WW%  | 23.89% | 33.44% | 25.80% | 16.88% |
+--------------------------------------------+
|3. Units|  0.77M |  1.96M |  2.12M |  0.50M |
|3. YoY% |-63.16% |-34.88% | +0.95% |-58.68% |
|3. WW%  | 14.42% | 36.70% | 39.70% |  9.36% |
+============================================+
|First Half                                  |
+--------------------------------------------+
| Units  |  1.58M |  2.15M |  1.63M |  1.09M |
| YoY%   |-18.13% |-16.99% |-24.54% |-35.12% |
| WW%    | 24.50% | 33.33% | 25.27% | 16.90% |
+--------------------------------------------+
|First Three Quarters                        |
+--------------------------------------------+
| Units  |  2.35M |  4.11M |  3.75M |  1.59M |
| YoY%   |-41.54% |-26.61% |-11.97% |-44.98% |
| WW%    | 19.93% | 34.86% | 31.81% | 13.49% |
+--------------------------------------------+
|FY3/22 Cumulative                           |
+--------------------------------------------+
| Units  |  2.35M |  4.11M |  3.75M |  1.59M |
| WW%    | 19.93% | 34.86% | 31.81% | 13.49% |
+--------------------------------------------+
|Life-To-Date                                |
+--------------------------------------------+
| Units  | 18.57M | 30.97M | 21.86M | 10.29M |
| WW%    | 22.74% | 37.92% | 26.76% | 12.60% |
+--------------------------------------------+
###
+--------------------------------------------+
| Switch | Japan  |The     | Europe | Other  |
| Lite   |        |Americas|        |        |
+--------------------------------------------+
|Quarters|                                   |
+--------------------------------------------+
|1. Units|  0.34M |  0.48M |  0.26M |  0.05M |
|1. YoY% | -5.56% |-62.50% |-67.09% |-75.00% |
|1. WW%  | 29.82% | 42.11% | 22.81% |  4.39% |
+--------------------------------------------+
|2. Units|  0.11M |  0.41M |  0.13M |  0.05M |
|2. YoY% |-75.00% |-30.51% |-62.86% |-68.75% |
|2. WW%  | 16.18% | 60.29% | 19.12% |  7.35% |
+--------------------------------------------+
|3. Units|  0.46M |  0.44M |  0.36M |  0.08M |
|3. YoY% |-25.81% |-72.15% |-59.09% |-11.11% |
|3. WW%  | 34.07% | 32.59% | 26.67% |  5.93% |
+============================================+
|First Half                                  |
+--------------------------------------------+
| Units  |  0.45M |  0.89M |  0.39M |  0.10M |
| YoY%   |-43.75% |-52.41% |-65.79% |-72.22% |
| WW%    | 24.73% | 48.90% | 21.43% |  5.49% |
+--------------------------------------------+
|First Three Quarters                        |
+--------------------------------------------+
| Units  |  0.91M |  1.33M |  0.75M |  0.18M |
| YoY%   |-35.92% |-61.45% |-62.87% |-60.00% |
| WW%    | 28.71% | 41.96% | 23.66% |  5.68% |
+--------------------------------------------+
|FY3/22 Cumulative                           |
+--------------------------------------------+
| Units  |  0.91M |  1.33M |  0.75M |  0.18M |
| WW%    | 28.71% | 41.96% | 23.66% |  5.68% |
+--------------------------------------------+
|Life-To-Date                                |
+--------------------------------------------+
| Units  |  4.72M |  7.74M |  4.22M |  1.19M |
| WW%    | 26.41% | 43.31% | 23.61% |  6.66% |
+--------------------------------------------+
###
+--------------------------------------------+
| Switch | Japan  |The     | Europe | Other  |
| OLED   |        |Americas|        |        |
+--------------------------------------------+
|3. Units|  1.07M |  1.41M |  0.91M |  0.61M |
|3. WW%  | 26.82% | 35.34% | 22.81% | 15.29% |
+============================================+
|First Three Quarters                        |
+--------------------------------------------+
| Units  |  1.07M |  1.41M |  0.91M |  0.61M |
| WW%    | 26.82% | 35.34% | 22.81% | 15.29% |
+--------------------------------------------+
|FY3/22 Cumulative                           |
+--------------------------------------------+
| Units  |  1.07M |  1.41M |  0.91M |  0.61M |
| WW%    | 26.82% | 35.34% | 22.81% | 15.29% |
+--------------------------------------------+
|Life-To-Date                                |
+--------------------------------------------+
| Units  |  1.07M |  1.41M |  0.91M |  0.61M |
| WW%    | 26.82% | 35.34% | 22.81% | 15.29% |
+--------------------------------------------+
###
+--------------------------------------------+
| Switch | Japan  |The     | Europe | Other  |
|Hardware|        |Americas|        |        |
+--------------------------------------------+
|Quarters|                                   |
+--------------------------------------------+
|1. Units|  1.16M |  1.59M |  1.08M |  0.62M |
|1. YoY% | +0.87% |-20.10% |-32.92% |-32.61% |
|1. WW%  | 26.07% | 35.73% | 24.27% | 13.93% |
+--------------------------------------------+
|2. Units|  0.87M |  1.45M |  0.94M |  0.57M |
|2. YoY% |-44.94% |-41.30% |-44.71% |-49.11% |
|2. WW%  | 22.72% | 37.86% | 24.54% | 14.88% |
+--------------------------------------------+
|3. Units|  2.29M |  3.80M |  3.38M |  1.19M |
|3. YoY% |-15.50% |-17.21% |+13.80% | -7.75% |
|3. WW%  | 21.46% | 35.61% | 31.68% | 11.15% |
+============================================+
|First Half                                  |
+--------------------------------------------+
| Units  |  2.03M |  3.04M |  2.02M |  1.19M |
| YoY%   |-25.64% |-31.84% |-38.97% |-41.67% |
| WW%    | 24.52% | 36.71% | 24.40% | 14.37% |
+--------------------------------------------+
|First Three Quarters                        |
+--------------------------------------------+
| Units  |  4.32M |  6.84M |  5.40M |  2.38M |
| YoY%   |-20.59% |-24.42% |-14.01% |-28.53% |
| WW%    | 22.80% | 36.09% | 28.50% | 12.56% |
+--------------------------------------------+
|FY3/22 Cumulative                           |
+--------------------------------------------+
| Units  |  4.32M |  6.84M |  5.40M |  2.38M |
| WW%    | 22.80% | 36.09% | 28.50% | 12.56% |
+--------------------------------------------+
|Life-To-Date                                |
+--------------------------------------------+
| Units  | 24.36M | 40.11M | 26.98M | 12.09M |
| WW%    | 23.53% | 38.74% | 26.06% | 11.68% |
+--------------------------------------------+
###
+--------------------------------------------+
| Switch | Japan  |The     | Europe | Other  |
|Software|        |Americas|        |        |
+--------------------------------------------+
|Quarters|                                   |
+--------------------------------------------+
|1. Units|  8.13M | 22.35M | 11.35M |  3.46M |
|1. YoY% |-18.86% | +4.00% |-20.68% |-25.11% |
|1. WW%  | 17.95% | 49.35% | 25.06% |  7.64% |
+--------------------------------------------+
|2. Units|  8.00M | 22.78M | 14.28M |  3.54M |
|2. YoY% | +3.09% | -5.48% | +0.42% | -4.84% |
|2. WW%  | 16.46% | 46.87% | 29.38% |  7.28% |
+--------------------------------------------+
|3. Units| 14.85M | 39.51M | 25.22M |  5.83M |
|3. YoY% | +6.76% |+16.38% | +5.74% |+40.14% |
|3. WW%  | 17.39% | 46.26% | 29.53% |  6.83% |
+============================================+
|First Half                                  |
+--------------------------------------------+
| Units  | 16.13M | 45.13M | 25.63M |  7.00M |
| YoY%   | -9.28% | -1.01% |-10.16% |-16.07% |
| WW%    | 17.18% | 48.07% | 27.30% |  7.46% |
+--------------------------------------------+
|First Three Quarters                        |
+--------------------------------------------+
| Units  | 30.98M | 84.64M | 50.85M | 12.83M |
| YoY%   | -2.24% | +6.41% | -2.92% | +2.64% |
| WW%    | 17.28% | 47.21% | 28.36% |  7.16% |
+--------------------------------------------+
|FY3/22 Cumulative                           |
+--------------------------------------------+
| Units  | 30.98M | 84.64M | 50.85M | 12.83M |
| WW%    | 17.28% | 47.21% | 28.36% |  7.16% |
+--------------------------------------------+
|Life-To-Date                                |
+--------------------------------------------+
| Units  |143.20M |345.64M |223.00M | 54.57M |
| WW%    | 18.68% | 45.10% | 29.10% |  7.12% |
+--------------------------------------------+
###

ggx2ac · May 7, 2022

From the last things I added in my capcom platinum titles code is now being added to the Nintendo FY million seller titles. The yoy percentages that will be shown and the category summations found at the bottom will only appear during the 4th quarters. The below code is just an example with 4th quarter data not used.

Code:

+------------------------------------------+
| Nintendo Switch FY Million-Seller Titles |
+------------------------------------------+
+------------------------------------------+
| Title and Rank                           |
+------------------------------------------+
| Units                                    |
+------------------------------------------+
+------------------------------------------+
| Pokémon Brilliant Diamond /    |         |
| Pokémon Shining Pearl          | Rank 1  |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       3.79M |      10.18M |
+==========================================+
| FY3/22 Cml.  |       3.79M |      10.18M |
| FY3/22 YoY%  |        New! |        New! |
| Area/WW FY % |      27.13% |      72.87% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |      13.97M |      13.97M |
+==========================================+
| FY3/22 Cml.  |      13.97M |      13.97M |
| FY3/22 YoY%  |        New! |        New! |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Mario Kart 8 Deluxe            | Rank 2  |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.20M |       1.50M |
| 2nd Quarter  |       0.26M |       1.39M |
| 3rd Quarter  |       0.40M |       4.21M |
+==========================================+
| FY3/22 Cml.  |       0.86M |       7.10M |
| FY3/22 YoY%  |     -33.85% |     -23.82% |
| Area/WW FY % |      10.80% |      89.20% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       1.69M |      37.08M |
| 2nd Quarter  |       1.65M |      38.74M |
| 3rd Quarter  |       4.62M |      43.35M |
+==========================================+
| FY3/22 Cml.  |       7.96M |      43.35M |
| FY3/22 YoY%  |     -25.05% |     +22.49% |
| WW FY/LTD %  |      18.36% |      81.64% |
+------------------------------------------+
+------------------------------------------+
| Mario Party Superstars         | Rank 3  |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       1.13M |       4.30M |
+==========================================+
| FY3/22 Cml.  |       1.13M |       4.30M |
| FY3/22 YoY%  |        New! |        New! |
| Area/WW FY % |      20.81% |      79.19% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       5.43M |       5.43M |
+==========================================+
| FY3/22 Cml.  |       5.43M |       5.43M |
| FY3/22 YoY%  |        New! |        New! |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Animal Crossing: New Horizons  | Rank 4  |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.13M |       1.13M |
| 2nd Quarter  |       0.12M |       0.84M |
| 3rd Quarter  |       0.45M |       2.33M |
+==========================================+
| FY3/22 Cml.  |       0.70M |       4.30M |
| FY3/22 YoY%  |     -87.34% |     -71.93% |
| Area/WW FY % |      14.03% |      86.17% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       1.26M |      33.89M |
| 2nd Quarter  |       0.96M |      34.85M |
| 3rd Quarter  |       2.77M |      37.62M |
+==========================================+
| FY3/22 Cml.  |       4.99M |      37.62M |
| FY3/22 YoY%  |     -76.07% |     +15.29% |
| WW FY/LTD %  |      13.26% |      86.74% |
+------------------------------------------+
+------------------------------------------+
| The Legend of Zelda: Skyward   |         |
| Sword HD                       | Rank 5  |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.42M |       3.18M |
| 3rd Quarter  |       0.02M |       0.22M |
+==========================================+
| FY3/22 Cml.  |       0.44M |       3.40M |
| FY3/22 YoY%  |        New! |        New! |
| Area/WW FY % |      11.43% |      88.31% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       3.60M |       3.60M |
| 3rd Quarter  |       0.25M |       3.85M |
+==========================================+
| FY3/22 Cml.  |       3.85M |       3.85M |
| FY3/22 YoY%  |        New! |        New! |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Super Smash Bros. Ultimate     | Rank 6  |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.33M |       1.53M |
| 3rd Quarter  |       0.44M |       1.26M |
+==========================================+
| FY3/22 Cml.  |       0.77M |       2.79M |
| FY3/22 YoY%  |     -21.43% |     -30.77% |
| Area/WW FY % |      21.63% |      78.37% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       1.86M |      25.71M |
| 3rd Quarter  |       1.70M |      27.40M |
+==========================================+
| FY3/22 Cml.  |       3.56M |      27.40M |
| FY3/22 YoY%  |     -28.94% |     +14.93% |
| WW FY/LTD %  |      12.99% |      87.01% |
+------------------------------------------+
+------------------------------------------+
| The Legend of Zelda: Breath of |         |
| the Wild                       | Rank 7  |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.16M |       1.70M |
| 3rd Quarter  |       0.24M |       1.41M |
+==========================================+
| FY3/22 Cml.  |       0.40M |       3.11M |
| FY3/22 YoY%  |     -18.37% |     -28.83% |
| Area/WW FY % |      11.36% |      88.35% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       1.85M |      24.13M |
| 3rd Quarter  |       1.67M |      25.80M |
+==========================================+
| FY3/22 Cml.  |       3.52M |      25.80M |
| FY3/22 YoY%  |     -27.57% |     +15.80% |
| WW FY/LTD %  |      13.64% |      86.36% |
+------------------------------------------+
+------------------------------------------+
| Ring Fit Adventure             | Rank 8  |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.25M |       0.89M |
| 2nd Quarter  |       0.27M |       0.69M |
| 3rd Quarter  |       0.28M |       1.04M |
+==========================================+
| FY3/22 Cml.  |       0.80M |       2.62M |
| FY3/22 YoY%  |     -58.33% |     -52.01% |
| Area/WW FY % |      23.39% |      76.61% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       1.15M |      11.26M |
| 2nd Quarter  |       0.95M |      12.21M |
| 3rd Quarter  |       1.32M |      13.53M |
+==========================================+
| FY3/22 Cml.  |       3.42M |      13.53M |
| FY3/22 YoY%  |     -53.66% |     +33.83% |
| WW FY/LTD %  |      25.28% |      74.72% |
+------------------------------------------+
+------------------------------------------+
| Super Mario 3D World +         |         |
| Boswer's Fury                  | Rank 9  |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.21M |       0.87M |
| 2nd Quarter  |       0.15M |       0.63M |
| 3rd Quarter  |       0.18M |       1.22M |
+==========================================+
| FY3/22 Cml.  |       0.54M |       2.72M |
| FY3/22 YoY%  |     -37.21% |     -42.49% |
| Area/WW FY % |      16.56% |      83.44% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       1.09M |       6.68M |
| 2nd Quarter  |       0.77M |       7.45M |
| 3rd Quarter  |       1.40M |       8.85M |
+==========================================+
| FY3/22 Cml.  |       3.26M |       8.85M |
| FY3/22 YoY%  |     -41.68% |     +58.32% |
| WW FY/LTD %  |      36.84% |      63.16% |
+------------------------------------------+
+------------------------------------------+
| Pokémon Sword / Pokémon Shield | Rank 10 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.19M |       1.35M |
| 3rd Quarter  |       0.23M |       1.03M |
+==========================================+
| FY3/22 Cml.  |       0.42M |       2.38M |
| FY3/22 YoY%  |     -32.26% |     -23.47% |
| Area/WW FY % |      15.00% |      85.00% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       1.54M |      22.64M |
| 3rd Quarter  |       1.26M |      23.90M |
+==========================================+
| FY3/22 Cml.  |       2.80M |      23.90M |
| FY3/22 YoY%  |     -24.93% |     +13.27% |
| WW FY/LTD %  |      11.72% |      88.28% |
+------------------------------------------+
+------------------------------------------+
| Metroid Dread                  | Rank 11 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       0.26M |       2.48M |
+==========================================+
| FY3/22 Cml.  |       0.26M |       2.48M |
| FY3/22 YoY%  |        New! |        New! |
| Area/WW FY % |       9.49% |      90.51% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       2.74M |       2.74M |
+==========================================+
| FY3/22 Cml.  |       2.74M |       2.74M |
| FY3/22 YoY%  |        New! |        New! |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Super Mario Party              | Rank 12 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.22M |       1.47M |
| 3rd Quarter  |       0.07M |       0.83M |
+==========================================+
| FY3/22 Cml.  |       0.29M |       2.30M |
| FY3/22 YoY%  |     -52.46% |     -43.63% |
| Area/WW FY % |      11.20% |      88.80% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       1.68M |      16.48M |
| 3rd Quarter  |       0.91M |      17.39M |
+==========================================+
| FY3/22 Cml.  |       2.59M |      17.39M |
| FY3/22 YoY%  |     -44.78% |     +17.58% |
| WW FY/LTD %  |      14.89% |      85.11% |
+------------------------------------------+
+------------------------------------------+
| New Pokémon Snap               | Rank 13 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.00M |       2.07M |
| 2nd Quarter  |       0.00M |       0.12M |
| 3rd Quarter  |       0.00M |       0.17M |
+==========================================+
| FY3/22 Cml.  |       0.00M |       2.36M |
| FY3/22 YoY%  |        New! |        New! |
| Area/WW FY % |       0.00% |     100.00% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       2.07M |       2.07M |
| 2nd Quarter  |       0.12M |       2.19M |
| 3rd Quarter  |       0.17M |       2.36M |
+==========================================+
| FY3/22 Cml.  |       2.36M |       2.36M |
| FY3/22 YoY%  |        New! |        New! |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| New Super Mario Bros. U Deluxe | Rank 14 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.08M |       0.96M |
| 3rd Quarter  |       0.06M |       1.17M |
+==========================================+
| FY3/22 Cml.  |       0.14M |       2.13M |
| FY3/22 YoY%  |     -51.72% |     -40.00% |
| Area/WW FY % |       6.14% |      93.42% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       1.03M |      11.48M |
| 3rd Quarter  |       1.25M |      12.72M |
+==========================================+
| FY3/22 Cml.  |       2.28M |      12.72M |
| FY3/22 YoY%  |     -40.62% |     +21.84% |
| WW FY/LTD %  |      17.92% |      82.08% |
+------------------------------------------+
+------------------------------------------+
| Mario Golf: Super Rush         | Rank 15 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.21M |       1.13M |
| 2nd Quarter  |       0.08M |       0.52M |
| 3rd Quarter  |       0.01M |       0.31M |
+==========================================+
| FY3/22 Cml.  |       0.30M |       1.96M |
| FY3/22 YoY%  |        New! |        New! |
| Area/WW FY % |      13.27% |      86.73% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       1.34M |       1.34M |
| 2nd Quarter  |       0.60M |       1.94M |
| 3rd Quarter  |       0.32M |       2.26M |
+==========================================+
| FY3/22 Cml.  |       2.26M |       2.26M |
| FY3/22 YoY%  |        New! |        New! |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Super Mario Odyssey            | Rank 16 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 2nd Quarter  |       0.08M |       1.03M |
| 3rd Quarter  |       0.07M |       1.01M |
+==========================================+
| FY3/22 Cml.  |       0.15M |       2.04M |
| FY3/22 YoY%  |     -25.00% |     -36.65% |
| Area/WW FY % |       6.85% |      93.15% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 2nd Quarter  |       1.12M |      21.95M |
| 3rd Quarter  |       1.07M |      23.02M |
+==========================================+
| FY3/22 Cml.  |       2.19M |      23.02M |
| FY3/22 YoY%  |     -35.96% |     +10.51% |
| WW FY/LTD %  |       9.51% |      90.49% |
+------------------------------------------+
+------------------------------------------+
| Miitopia                       | Rank 17 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 1st Quarter  |       0.26M |       0.78M |
| 2nd Quarter  |       0.09M |       0.24M |
| 3rd Quarter  |       0.03M |       0.23M |
+==========================================+
| FY3/22 Cml.  |       0.38M |       1.25M |
| FY3/22 YoY%  |        New! |        New! |
| Area/WW FY % |      23.31% |      76.69% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 1st Quarter  |       1.04M |       1.04M |
| 2nd Quarter  |       0.33M |       1.37M |
| 3rd Quarter  |       0.26M |       1.63M |
+==========================================+
| FY3/22 Cml.  |       1.63M |       1.63M |
| FY3/22 YoY%  |        New! |        New! |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Luigi's Mansion 3              | Rank 18 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       0.09M |       1.36M |
+==========================================+
| FY3/22 Cml.  |       0.09M |       1.36M |
| FY3/22 YoY%  |     -47.06% |     -55.99% |
| Area/WW FY % |       6.21% |      93.79% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       1.45M |      11.04M |
+==========================================+
| FY3/22 Cml.  |       1.45M |      11.04M |
| FY3/22 YoY%  |     -55.52% |     +15.12% |
| WW FY/LTD %  |      13.13% |      86.87% |
+------------------------------------------+
+------------------------------------------+
| Big Brain Academy: Brain vs    |         |
| Brain                          | Rank 19 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       0.38M |       0.90M |
+==========================================+
| FY3/22 Cml.  |       0.38M |       0.90M |
| FY3/22 YoY%  |        New! |        New! |
| Area/WW FY % |      29.69% |      70.31% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       1.28M |       1.28M |
+==========================================+
| FY3/22 Cml.  |       1.28M |       1.28M |
| FY3/22 YoY%  |        New! |        New! |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| WarioWare: Get It Together!    | Rank 20 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       0.30M |       0.94M |
+==========================================+
| FY3/22 Cml.  |       0.30M |       0.94M |
| FY3/22 YoY%  |        New! |        New! |
| Area/WW FY % |      24.19% |      75.81% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       1.24M |       1.24M |
+==========================================+
| FY3/22 Cml.  |       1.24M |       1.24M |
| FY3/22 YoY%  |        New! |        New! |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
+------------------------------------------+
| Pokémon: Let's Go, Pikachu! /  |         |
| Pokémon: Let's Go, Eevee!      | Rank 21 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       0.03M |       1.02M |
+==========================================+
| FY3/22 Cml.  |       0.03M |       1.02M |
| FY3/22 YoY%  |     -62.50% |     -17.07% |
| Area/WW FY % |       2.86% |      97.14% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       1.05M |      14.33M |
+==========================================+
| FY3/22 Cml.  |       1.05M |      14.33M |
| FY3/22 YoY%  |     -19.85% |      +7.91% |
| WW FY/LTD %  |       7.33% |      92.67% |
+------------------------------------------+
+------------------------------------------+
| Game Builder Garage            | Rank 22 |
+------------------------------------------+
| Area (Units) |       Japan |    Overseas |
+------------------------------------------+
| 3rd Quarter  |       0.44M |       0.58M |
+==========================================+
| FY3/22 Cml.  |       0.44M |       0.58M |
| FY3/22 YoY%  |        New! |        New! |
| Area/WW FY % |      43.56% |      57.43% |
+------------------------------------------+
|              |   Global FY |  Global LTD |
+------------------------------------------+
| 3rd Quarter  |       1.01M |       1.01M |
+==========================================+
| FY3/22 Cml.  |       1.01M |       1.01M |
| FY3/22 YoY%  |        New! |        New! |
| WW FY/LTD %  |     100.00% |       0.00% |
+------------------------------------------+
###
+--------------------------------+
| Nintendo Switch FY             |
| Million-Seller Titles          |
+--------------------------------+
| Japan                          |
+--------------------------------+
| FY3/22 Cml. | Titles |   Units |
+--------------------------------+
| New!        |     10 |   7.42M |
| Recurring   |     12 |   5.19M |
+--------------------------------+
| Total       |     22 |  12.61M |
+--------------------------------+
| Percentages | Titles |   Units |
+--------------------------------+
| New!        | 45.45% |  58.84% |
| Recurring   | 54.55% |  41.16% |
+--------------------------------+
+--------------------------------+
| Nintendo Switch FY             |
| Million-Seller Titles          |
+--------------------------------+
| Overseas                       |
+--------------------------------+
| FY3/22 Cml. | Titles |   Units |
+--------------------------------+
| New!        |     10 |  28.35M |
| Recurring   |     12 |  33.87M |
+--------------------------------+
| Total       |     22 |  62.22M |
+--------------------------------+
| Percentages | Titles |   Units |
+--------------------------------+
| New!        | 45.45% |  45.56% |
| Recurring   | 54.55% |  54.44% |
+--------------------------------+
+--------------------------------+
| Nintendo Switch FY             |
| Million-Seller Titles          |
+--------------------------------+
| Global FY                      |
+--------------------------------+
| FY3/22 Cml. | Titles |   Units |
+--------------------------------+
| New!        |     10 |  35.77M |
| Recurring   |     12 |  39.07M |
+--------------------------------+
| Total       |     22 |  74.84M |
+--------------------------------+
| Percentages | Titles |   Units |
+--------------------------------+
| New!        | 45.45% |  47.80% |
| Recurring   | 54.55% |  52.20% |
+--------------------------------+
+--------------------------------+
| Nintendo Switch FY             |
| Million-Seller Titles          |
+--------------------------------+
| Global LTD                     |
+--------------------------------+
| FY3/22 Cml. | Titles |   Units |
+--------------------------------+
| New!        |     10 |  35.77M |
| Recurring   |     12 | 258.95M |
+--------------------------------+
| Total       |     22 | 294.72M |
+--------------------------------+
| Percentages | Titles |   Units |
+--------------------------------+
| New!        | 45.45% |  12.14% |
| Recurring   | 54.55% |  87.86% |
+--------------------------------+
###

Lelouch0612 · May 8, 2022

All is set for an exciting week then

bellydrum · May 14, 2022

This is all pretty interesting data. What exactly is your source?

Also, I take it you're punching it in directly to the code?

What if instead of files containing data, you have a database, and instead of adding new lines of code every time a new report comes out, you could just plug the report into a function that parses, calculates, and organizes the data and then saves it to the database automatically?

And if you ever want to retrieve data from the database, you could have functions that access the database that are called by other functions that format the data back into visible displays

ggx2ac · May 14, 2022

bellydrum said:
This is all pretty interesting data. What exactly is your source?

Also, I take it you're punching it in directly to the code?

What if instead of files containing data, you have a database, and instead of adding new lines of code every time a new report comes out, you could just plug the report into a function that parses, calculates, and organizes the data and then saves it to the database automatically?

And if you ever want to retrieve data from the database, you could have functions that access the database that are called by other functions that format the data back into visible displays

Thanks for the suggestion but automating the data extraction and input is low on my priority list currently.

I understand that I could make use of databases like SQL and parse the data from the earnings releases using third party libraries.

When I learn these things to apply them myself, then I will assess it and decide whether I will make use of it.

I know that my current methods of manually entering in numbers into the code from reading off the PDF files is inefficient because it's not automated and can be prone to error.

Right now though, there's other things I need to focus on or that have my interest. I had already been posting earnings releases on forums without automating the data extraction and input for the last several years so I'm not in a rush.

Akira Toriyama passed away

You can now download my Nintendo earnings FY3/22 Python code from GitHub (Up: mobile-friendly output done)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)

(They publish Dark Souls)