24 hours from last update :

- Amazon :

1 (-) - Nintendo Switch Neon - 11 (+4) - 299.00$
2 (+1) - Nintendo Switch Grey - 22 (+6) - 299.00$
3 (-1) - Playstation 4 Slim 1Tb Black - 23 (+3) - 314.95$
4 (-) - Xbox One S 500Gb White - 30 (-1) - 239.00$
5 (-) - Playstation 4 Pro 1 Tb - 33 (+3) - 399.00$
6 (-) - XBox One X 1 Tb - 56 (-1) - 484.99$
7 (+1) - Playstation 4 Pro 1Tb Star Wars - 65 (+8) - ??
8 (-1) - Playstation 4 Slim 500Gb Black - 87 (-27) - Third Party
9 (-) - Playstation 4 Pro 1 Tb God of Wars - 94 (+1) - Third Party

Out of Top 100 :

-

PS4 : 78 + 68 + 36 + 14 + 7 = 203 points (-12) ; XBO : 71 + 45 = 117 points (-2) ; NS : 90 + 79 = 169 points (+10) ; 3DS : 0 points (-)


- Best Buy :

1 (+1) - Playstation 4 Slim 1Tb Black - 4 (+3) - 299.99$
2 (+1) - Playstation 4 Pro 1 Tb - 5 (+6) - 399.00$
3 (+1) - Nintendo Switch Neon - 6 (+6) - 299.00$
4 (-3) - Playstation 4 Pro 1 Tb God of Wars - 9 (-7) - 399.99$
5 (+1) - Nintendo Switch Grey - 18 (+27) - 299.00$
6 (-1) - XBox One X 1 Tb - 23 (+10) - 499.99$
7 (-) - XBox One S 1Tb Playerunknown's Battlegrounds - 45 (+8) - 299.99$
8 (-) - XBox One S 1Tb Sea of Thieves - 74 (+7) - 299.99$

Out of Top 100 :

-

PS4 : 97 + 96 + 92 = 285 points (+2) ; XBO : 78 + 56 + 27 = 161 points (+25) ; NS : 95 + 83 = 178 points (+33) ; 3DS : 0 points (-)


- Gamestop :

1 (-) - Playstation 4 Pro 1Tb Destiny 2 LE - 10 (+10) - 449.99$
2 (-) - Playstation 4 Pro 1Tb Glacier White - 30 (+6) - 399.99$
3 (+1) - Playstation 4 Slim 1 Tb - 44 (+27) - 299.99$
4 (-1) - Playstation 4 Pro 1Tb Star Wars - 55 (-1) - 399.99$
5 (+1) - Nintendo Switch Neon + Zelda Bundle - 80 (+35) - 359.99$
6 (-1) - Nintendo Switch Neon - 101 (+9) - 299.00$
7 (+1) - Nintendo Switch Neon + Zelda Bundle 2 - 147 (+1) - 359.99$
8 (-1) - XBox One X 1 Tb - 155 (-17) - 499.99$
9 (R) - Playstation 4 Slim 500Gb COD IW - 176 (R) - 299.99$

Out of Top 100 :

-

PS4 : 96 + 86 + 79 + 73 + 13 = 347 points (+34) ; XBO : 23 points (-9) ; NS : 61 + 50 + 27 = 138 points (+22) ; 3DS : 0 points (-)


- Walmart :

1 (R) - Nintendo 2DS Mario Kart 7 - 9 (R) - 79.99$
2 (-1) - Nintendo 2DS XL New White and Orange - 18 (-4) - 129.99$
3 (-1) - XBox One S 1Tb Playerunknown's Battlegrounds - 21 (-4) - 299.99$
4 (-1) - XBox One S 1Tb Rocket League - 30 (-) - 299.00$
5 (-1) - Playstation 4 Slim 500Gb Black - 44 (-2) - 269.00$
6 (-1) - Xbox One S 500Gb White - 46 (-2) - 241.22$
7 (-1) - Nintendo Switch Splatoon 2 - 47 (-1) - 379.99$
8 (-1) - XBox One X 1 Tb - 48 (-1) - 499.00$
9 (-1) - Nintendo Switch Neon - 49 (-1) - 299.00$
10 (-1) - Playstation 4 Pro 1Tb Black - 51 (-1) - 399.00$
11 (-1) - Nintendo Switch Grey - 52 (-1) - 299.00$
12 (-1) - Playstation 4 Pro 1 Tb Star Wars - 53 (-1) - 399.00$
13 (-) - Nintendo 2DS XL New Black and Turquoise - 55 (+1) - 129.99$
14 (R) - Nintendo 3DS XL New Black - 60 (R) - 186.99$

Out of Top 100 :

12 (+1) - Nintendo 2DS New New Super Mario Bros 2 - 54 (+3) - 79.96$

PS4 : 57 + 50 + 48 = 155 points (-4) ; XBO : 80 + 71 + 55 + 53 = 259 points (-7) ; NS : 54 + 52 + 49 = 155 points (-3) ; 3DS : 92 + 83 + 46 + 41 = 262 points (+83)


-Target :

1 (-) - Nintendo Switch Neon - 3 (-)
2 (-) - Playstation 4 Pro 1Tb God of War - 13 (-)
3 (-) - Playstation 4 Slim 1Tb Black - 16 (-)
4 (-) - Nintendo Switch Grey - 17 (-)
5 (-) - Playstation 4 Pro 1 Tb - 44 (-)
6 (-) - XBox One S 1Tb Playerunknown's Battlegrounds - 48 (-)
7 (-) - XBox One X 1 Tb - 57 (-1)
8 (-) - XBox One S 1Tb Sea of Thieves - 60 (-3) - 299.99$
9 (-) - Xbox One S 500Gb Minecraft - 69 (-3)
10 (-) - Nintendo 2DS Mario Kart 7 - 72 (+2)
11 (R) - Nintendo New 2DS XL Black and Turquoise - 93 (R)

Out of Top 100 :

-

PS4 : 88 + 85 + 57 = 230 points (-) ; XBO : 53 + 44 + 41 + 32 = 170 points (-7) ; NS : 98 + 84 = 182 points (-) ; 3DS : 29 + 8 = 37 points (+10)

Overall (Today) :

1 (-) - PS4 : 1220 points (+20)
2 (-) - NS : 822 points (+62)
3 (-) - XBO : 730 points (+1)
4 (-) - 3DS : 299 points (+93)

I had some fun twisting the formula yesterday.

To get numbers matching more or less NPD march results, I did three main changes :

- Getting rid of Walmart and Target numbers ; those are neither hourly nor daily best selling lists meaning there are kind of useless for our future "tool".
- Twisting the point system to award more point to high ranking items (#100 = 1 point, #51 = 50 points, #49 = 52 points, #21 = 110 points, #20 = 115 points, #1 = 210 points)
- Formula used was : Gamestop*1 + Best Buy*0.3 + Amazon*0.5

I don't have my excel sheet in front of me but I am pretty sure this is what I did (will double check later).

What do you think of those changes ? We have to keep in mind that we only have one week of data for March though...

I will finish April with all 5 lists and will calculate month average with both old and new system...

Sounds good, can't wait to see the results

I feel like each retailer should be tracked seperately, then at the end of the month see which one has the data closest to NPD. Combining them seems to really skew the data. We know Amazon hasn't been the most reliable, maybe Best Buy and/or Gamestop are the key?? Just my .02 though

I honestly think there is no key, just wait till NPD, and looks at NPD trends.

24 hours from last update :

- Amazon :

1 (-) - Nintendo Switch Neon - 12 (-1) - 299.00$
2 (-) - Nintendo Switch Grey - 22 (-) - 299.00$
3 (-) - Playstation 4 Slim 1Tb Black - 24 (-1) - 299.00$
4 (-) - Xbox One S 500Gb White - 29 (+1) - 239.00$
5 (-) - Playstation 4 Pro 1 Tb - 30 (+3) - 399.00$
6 (-) - XBox One X 1 Tb - 46 (+10) - 484.99$
7 (-) - Playstation 4 Pro 1Tb Star Wars - 57 (+7) - ??

Out of Top 100 :

8 (-1) - Playstation 4 Slim 500Gb Black - 87 (-27) - Third Party
9 (-) - Playstation 4 Pro 1 Tb God of Wars - 94 (+1) - Third Party

PS4 : 77 + 71 + 44 = 192 points (-11) ; XBO : 72 + 55 = 128 points (+11) ; NS : 89 + 79 = 168 points (-1) ; 3DS : 0 points (-)


- Best Buy :

1 (-) - Playstation 4 Slim 1Tb Black - 4 (-) - 299.99$
2 (+1) - Nintendo Switch Neon - 6 (-) - 299.00$
3 (-1) - Playstation 4 Pro 1 Tb - 8 (-3) - 399.00$
4 (+1) - Nintendo Switch Grey - 20 (-2) - 299.00$
5 (+1) - XBox One X 1 Tb - 28 (-5) - 499.99$
6 (-2) - Playstation 4 Pro 1 Tb God of Wars - 33 (-24) - Out of Stock
7 (-) - XBox One S 1Tb Playerunknown's Battlegrounds - 35 (+10) - 299.99$
8 (-) - XBox One S 1Tb Sea of Thieves - 62 (+12) - 299.99$

Out of Top 100 :

-

PS4 : 97 + 93 + 68 = 258 points (-27) ; XBO : 73 + 66 + 39 = 178 points (+17) ; NS : 95 + 81 = 176 points (-2) ; 3DS : 0 points (-)


- Gamestop :

1 (-) - Playstation 4 Pro 1Tb Destiny 2 LE - 5 (+5) - 449.99$
2 (-) - Playstation 4 Pro 1Tb Glacier White - 28 (+2) - 399.99$
3 (-) - Playstation 4 Slim 1 Tb - 47 (-3) - 299.99$
4 (-) - Playstation 4 Pro 1Tb Star Wars - 69 (-14) - 399.99$
5 (+1) - Nintendo Switch Neon + Zelda Bundle - 80 (-) - 359.99$
6 (+3) - Playstation 4 Slim 500Gb COD IW - 131 (+45) - 299.99$
7 (-1) - Nintendo Switch Neon - 135 (-34) - 299.00$
8 (R) - Nintendo Switch Neon + Mario Odyssey Bundle - 139 (R) - 359.99$
9 (-1) - XBox One X 1 Tb - 146 (+9) - 499.99$
10 (-1) - Nintendo Switch Neon + Zelda Bundle 2 - 160 (-13) - 359.99$

Out of Top 100 :

-

PS4 : 98 + 87 + 77 + 66 + 35 = 363 points (+16) ; XBO : 28 points (+5) ; NS : 61 + 35 + 31 + 21 = 148 points (+10) ; 3DS : 0 points (-)


- Walmart :

1 (+2) - XBox One S 1Tb Playerunknown's Battlegrounds - 16 (+5) - 299.99$
2 (-) - Nintendo 2DS XL New White and Orange - 17 (+1) - 129.99$
3 (+1) - XBox One S 1Tb Rocket League - 30 (-) - 299.00$
4 (+1) - Playstation 4 Slim 500Gb Black - 42 (+2) - 269.00$
5 (+1) - Xbox One S 500Gb White - 44 (+2) - 241.22$
6 (+1) - Nintendo Switch Splatoon 2 - 46 (+1) - 379.99$
7 (+1) - XBox One X 1 Tb - 47 (+1) - 499.00$
8 (+1) - Nintendo Switch Neon - 48 (+1) - 299.00$
9 (+1) - Playstation 4 Pro 1Tb Black - 50 (+1) - 399.00$
10 (+1) - Nintendo Switch Grey - 51 (+1) - 299.00$
11 (+1) - Playstation 4 Pro 1 Tb Star Wars - 52 (+1) - 399.00$
12 (+1) - Nintendo 2DS XL New Black and Turquoise - 55 (-) - 129.99$

Out of Top 100 :

1 (R) - Nintendo 2DS Mario Kart 7 - 9 (R) - 79.99$
14 (R) - Nintendo 3DS XL New Black - 60 (R) - 186.99$

PS4 : 59 + 51 + 49 = 159 points (+4) ; XBO : 85 + 71 + 57 + 54 = 267 points (+8) ; NS : 55 + 53 + 50 = 158 points (+3) ; 3DS : 84 + 46 = 130 points (-132)


-Target :

1 (-) - Nintendo Switch Neon - 3 (-)
2 (-) - Playstation 4 Pro 1Tb God of War - 13 (-)
3 (-) - Playstation 4 Slim 1Tb Black - 15 (+1)
4 (-) - Nintendo Switch Grey - 18 (-1)
5 (-) - Playstation 4 Pro 1 Tb - 24 (+20)
6 (-) - XBox One S 1Tb Playerunknown's Battlegrounds - 47 (+1)
7 (-) - XBox One X 1 Tb - 58 (-1)
8 (-) - XBox One S 1Tb Sea of Thieves - 61 (-1) - 299.99$
9 (+2) - Nintendo New 2DS XL Black and Turquoise - 67 (+26)
10 (-1) - Xbox One S 500Gb Minecraft - 72 (-3)
11 (-1) - Nintendo 2DS Mario Kart 7 - 73 (-1)

Out of Top 100 :

-

PS4 : 88 + 86 + 77 = 251 points (+21) ; XBO : 54 + 43 + 40 + 29 = 166 points (-4) ; NS : 98 + 83 = 181 points (-1) ; 3DS : 34 + 28 = 62 points (+25)

Overall (Today) :

1 (-) - PS4 : 1223 points (+3)
2 (-) - NS : 831 points (+9)
3 (-) - XBO : 767 points (+37)
4 (-) - 3DS : 192 points (-107)

48 hours from last update :

- Amazon :

1 (-) - Nintendo Switch Neon - 13 (-1) - 299.00$
2 (-) - Nintendo Switch Grey - 22 (-) - 299.00$
3 (+1) - Xbox One S 500Gb White - 28 (+1) - 239.00$
4 (-1) - Playstation 4 Slim 1Tb Black - 32 (-6) - TP
5 (-) - Playstation 4 Pro 1 Tb - 45 (-15) - TP
6 (-) - XBox One X 1 Tb - 49 (-3) - 484.75$
7 (-) - Playstation 4 Pro 1Tb Star Wars - 53 (+4) - ??

Out of Top 100 :

-

PS4 : 69 + 56 + 48 = 173 points (-19) ; XBO : 73 + 52 = 126 points (-2) ; NS : 88 + 79 = 167 points (-1) ; 3DS : 0 points (-)


- Best Buy :

1 (-) - Playstation 4 Slim 1Tb Black - 2 (+2) - 299.99$
2 (+1) - Playstation 4 Pro 1 Tb - 4 (+4) - 399.00$
3 (-1) - Nintendo Switch Neon - 5 (+1) - 299.00$
4 (-) - Nintendo Switch Grey - 12 (+8) - 299.00$
5 (-) - XBox One X 1 Tb - 18 (+10) - 499.99$
6 (+1) - XBox One S 1Tb Playerunknown's Battlegrounds - 21 (+14) - 299.99$
7 (+1) - XBox One S 1Tb Sea of Thieves - 49 (+13) - 299.99$

Out of Top 100 :

6 (-2) - Playstation 4 Pro 1 Tb God of Wars - 33 (-24) - Out of Stock

PS4 : 99 + 97 = 196 points (-62) ; XBO : 83 + 80 + 62 = 215 points (+37) ; NS : 96 + 89 = 185 points (+9) ; 3DS : 0 points (-)


- Gamestop :

1 (+1) - Playstation 4 Pro 1Tb Glacier White - 26 (+2) - 399.99$
2 (-1) - Playstation 4 Pro 1Tb Destiny 2 LE - 45 (-40) - 449.99$
3 (-) - Playstation 4 Slim 1 Tb - 57 (-10) - 299.99$
4 (-) - Playstation 4 Pro 1Tb Star Wars - 64 (+5) - 399.99$
5 (+3) - Nintendo Switch Neon + Mario Odyssey Bundle - 101 (+38) - 359.99$
6 (+1) - Nintendo Switch Neon - 102 (+33) - 299.00$
7 (-1) - Playstation 4 Slim 500Gb COD IW - 108 (+23) - 299.99$
8 (+1) - XBox One X 1 Tb - 116 (+30) - 499.99$
9 (-4) - Nintendo Switch Neon + Zelda Bundle - 117 (-37) - 359.99$
10 (-) - Nintendo Switch Neon + Zelda Bundle 2 - 162 (-2) - 359.99$

Out of Top 100 :

-

PS4 : 88 + 78 + 72 + 69 + 47 = 354 points (-9) ; XBO : 43 points (+15) ; NS : 50 + 50 + 42 + 20 = 162 points (+14) ; 3DS : 0 points (-)


- Walmart :

1 (R) - Nintendo 2DS Mario Kart 7 - 8 (R) - 79.99$
2 (-) - Nintendo 2DS XL New White and Orange - 20 (-3) - 129.99$
3 (-2) - XBox One S 1Tb Playerunknown's Battlegrounds - 22 (-6) - 299.99$
4 (-1) - XBox One S 1Tb Rocket League - 33 (-3) - 299.00$
5 (R) - Playstation 4 Slim 1Tb Black - 45 (R) - 339.95$
6 (R) - Xbox One S 500Gb Forza + Hot Wheels Bundle - 48 (R) - 251.43$
7 (-3) - Playstation 4 Slim 500Gb Black - 49 (-7) - 269.00$
8 (-3) - Xbox One S 500Gb White - 50 (-6) - 241.22$
9 (-2) - XBox One X 1 Tb - 51 (-4) - 499.00$
10 (-2) - Nintendo Switch Neon - 52 (-4) - 299.00$
11 (-2) - Playstation 4 Pro 1Tb Black - 54 (-4) - 399.00$
12 (-2) - Nintendo Switch Grey - 55 (-4) - 299.00$
13 (-2) - Playstation 4 Pro 1 Tb Star Wars - 56 (-4) - 399.00$
14 (-8) - Nintendo Switch Splatoon 2 - 57 (-11) - 449.99$
15 (R) - Playstation 4 Pro 1 Tb God of Wars - 60 (R) - 523.99$
16 (R) - Nintendo 2DS New Super Mario Bros 2 - 61 (R) - 79.96$
17 (-5) - Nintendo 2DS XL New Black and Turquoise - 63 (-8) - 129.99$

Out of Top 100 :

14 (R) - Nintendo 3DS XL New Black - 60 (R) - 186.99$

PS4 : 56 + 52 + 47 + 45 + 41 = 241 points (+82) ; XBO : 79 + 68 + 53 + 51 + 50 = 301 points (+34) ; NS : 49 + 46 + 44 = 139 points (-19) ; 3DS : 93 + 81 + 40 + 38 = 252 points (+122)


-Target :

1 (-) - Nintendo Switch Neon - 3 (-)
2 (-) - Playstation 4 Pro 1Tb God of War - 13 (-)
3 (-) - Playstation 4 Slim 1Tb Black - 16 (-1)
4 (+1) - Playstation 4 Pro 1 Tb - 17 (+7)
5 (-1) - Nintendo Switch Grey - 18 (-)
6 (-) - XBox One S 1Tb Playerunknown's Battlegrounds - 50 (-3)
7 (+2) - Nintendo New 2DS XL Black and Turquoise - 52 (+15)
7 (-) - XBox One X 1 Tb - 60 (-2)
8 (-) - XBox One S 1Tb Sea of Thieves - 64 (-3) - 299.99$
10 (+1) - Nintendo 2DS Mario Kart 7 - 70 (+3)
11 (-1) - Xbox One S 500Gb Minecraft - 73 (-1)

Out of Top 100 :

-

PS4 : 88 + 85 + 84 = 257 points (+6) ; XBO : 51 + 41 + 37 + 28 = 157 points (-9) ; NS : 98 + 83 = 181 points (-) ; 3DS : 49 + 31 = 80 points (+18)

Overall (Today) :

1 (-) - PS4 : 1221 points (-2)
2 (+1) - XBO : 842 points (+75)
3 (-1) - NS : 834 points (+3)
4 (-) - 3DS : 332 points (+140)

Switch and Xbox duking it out

04/29/18 :

- Amazon :

1 (-) - Nintendo Switch Neon - 16 (-3) - 299.00$
2 (+1) - Xbox One S 500Gb White - 28 (-) - 229.00$
3 (-1) - Nintendo Switch Grey - 30 (-8) - 299.00$
4 (-) - Playstation 4 Slim 1Tb Black - 46 (-14) - TP
5 (+1) - XBox One X 1 Tb - 57 (-8) - 484.75$
6 (+1) - Playstation 4 Pro 1Tb Star Wars - 59 (-6) - ??
7 (-1) - Playstation 4 Pro 1 Tb - 63 (-18) - TP

Out of Top 100 :

-

PS4 : 55 + 41 + 38 = 134 points (-39) ; XBO : 73 + 44 = 118 points (-8) ; NS : 85 + 71 = 156 points (-11) ; 3DS : 0 points (-)


- Best Buy :

1 (-) - Playstation 4 Slim 1Tb Black - 2 (-) - 299.99$
2 (-) - Playstation 4 Pro 1 Tb - 4 (-) - 399.00$
3 (-) - Nintendo Switch Neon - 5 (-) - 299.00$
4 (-) - Nintendo Switch Grey - 45 (-33) - 299.00$
5 (-) - XBox One X 1 Tb - 47 (-29) - 499.99$
6 (+1) - XBox One S 1Tb Playerunknown's Battlegrounds - 48 (-27) - 299.99$


Out of Top 100 :

7 (+1) - XBox One S 1Tb Sea of Thieves - 49 (+13) - 299.99$

PS4 : 99 + 97 = 196 points (-) ; XBO : 54 + 53 = 107 points (-108) ; NS : 96 + 56 = 152 points (-33) ; 3DS : 0 points (-)


- Gamestop :

1 (-) - Playstation 4 Pro 1Tb Glacier White - 40 (-14) - 399.99$
2 (-) - Playstation 4 Pro 1Tb Destiny 2 LE - 44 (+1) - 449.99$
3 (-) - Playstation 4 Slim 1 Tb - 50 (+7) - 299.99$
4 (-) - Playstation 4 Pro 1Tb Star Wars - 67 (-3) - 399.99$
5 (+1) - Nintendo Switch Neon - 107 (-5) - 299.00$
6 (+1) - Playstation 4 Slim 500Gb COD IW - 115 (-7) - 299.99$
7 (+1) - XBox One X 1 Tb - 123 (-7) - 499.99$
8 (-3) - Nintendo Switch Neon + Mario Odyssey Bundle - 151 (-50) - 359.99$
9 (-) - Nintendo Switch Neon + Zelda Bundle - 152 (-35) - 359.99$
10 (-) - Nintendo Switch Neon + Zelda Bundle 2 - 170 (-8) - 359.99$

Out of Top 100 :

-

PS4 : 81 + 79 + 76 + 67 + 43 = 346 points (-8) ; XBO : 39 points (-4) ; NS : 47 + 25 + 25 + 16 = 113 points (-39) ; 3DS : 0 points (-)


- Walmart :

1 (+2) - XBox One S 1Tb Playerunknown's Battlegrounds - 16 (+6) - 299.99$
2 (-) - Nintendo 2DS XL New White and Orange - 18 (+2) - 129.99$
3 (+1) - XBox One S 1Tb Rocket League - 31 (+2) - 299.00$
4 (+3) - Playstation 4 Slim 500Gb Black - 44 (+5) - 269.00$
5 (-) - Playstation 4 Slim 1Tb Black - 46 (-1) - 339.95$
6 (+2) - Xbox One S 500Gb White - 47 (+3) - 241.22$
7 (+2) - XBox One X 1 Tb - 48 (+3) - 499.00$
8 (+2) - Nintendo Switch Neon - 49 (+3) - 299.00$
9 (+2) - Playstation 4 Pro 1Tb Black - 51 (+3) - 399.00$
10 (+2) - Nintendo Switch Grey - 52 (+3) - 299.00$
11 (+2) - Playstation 4 Pro 1 Tb Star Wars - 53 (+3) - 399.00$
12 (R) - Nintendo 3DS XL New Galaxy - 55 (R) - 194.00$
13 (+2) - Playstation 4 Pro 1 Tb God of Wars - 56 (+4) - 523.99$
14 (+3) - Nintendo 2DS XL New Black and Turquoise - 58 (+5) - 129.99$

Out of Top 100 :

6 (R) - Xbox One S 500Gb Forza + Hot Wheels Bundle - 48 (R) - 251.43$
14 (-8) - Nintendo Switch Splatoon 2 - 57 (-11) - 449.99$
16 (R) - Nintendo 2DS New Super Mario Bros 2 - 61 (R) - 79.96$

PS4 : 57 + 55 + 50 + 48 + 45 = 255 points (+14) ; XBO : 85 + 70 + 54 + 53 = 262 points (-39) ; NS : 52 + 49 = 101 points (-38) ; 3DS : 83 + 46 + 43 = 172 points (-80)


-Target :

1 (-) - Nintendo Switch Neon - 3 (-)
2 (+2) - Playstation 4 Pro 1 Tb - 11 (+6)
3 (-1) - Playstation 4 Pro 1Tb God of War - 15 (-2)
4 (-1) - Playstation 4 Slim 1Tb Black - 16 (-)
5 (-) - Nintendo Switch Grey - 18 (-)
6 (+1) - Nintendo New 2DS XL Black and Turquoise - 44 (+8)
7 (-1) - XBox One S 1Tb Playerunknown's Battlegrounds - 51 (-1)
8 (-1) - XBox One X 1 Tb - 60 (-)
8 (-) - XBox One S 1Tb Sea of Thieves - 65 (-1) - 299.99$
10 (+1) - Nintendo 2DS Mario Kart 7 - 72 (-2)
11 (-1) - Xbox One S 500Gb Minecraft - 84 (-11)

Out of Top 100 :

-

PS4 : 90 + 86 + 85 = 261 points (+4) ; XBO : 50 + 41 + 36 + 17 = 144 points (-13) ; NS : 98 + 83 = 181 points (-) ; 3DS : 57 + 29 = 86 points (+6)

Overall (Today) :

1 (-) - PS4 : 1192 points (-29)
2 (+1) - NS : 703 points (-121)
3 (-1) - XBO : 670 points (-172)
4 (-) - 3DS : 258 points (-74)

So, going forward, here is a detailed explanation on the changes to come and why I do them :

As mentionned in a previous post :

March Overview (Only 8 days of data) :

Amazon :
PS4 : 99.1 ; XBO : 97.2 ; NS : 155.6 ; 3DS : 0
Best Buy :
PS4 : 184.2 ; XBO : 221.9 ; NS : 163.0 ; 3DS : 6.5
Gamestop :
PS4 : 153.8 ; XBO : 142.8 ; NS : 80.2 ; 3DS : 29.6
Walmart :
PS4 : 261.2 ; XBO : 375.4 ; NS : 168.5 ; 3DS : 45.5
Target :
PS4 : 179.9 ; XBO : 177.4 ; NS : 189.9 ; 3DS : 38.0

Overall :

1 - XBO : 961.6 points/day (1.0)
2 - PS4 832.5 points/day (0.87)
3 - NS : 727.1 points/day (0.76)

NPD results :

1 - PS4 : 354k (1.18)
2 - NS : 308k (1.03)
3 - XBO : 299k (1.0)

So we were dead wrong here. While doing the updates, I noticed two lists out of the 5 are not suited for what we try to do : Walmart list is really strange with items going in and out all the time and ranking not really moving as it should. Target list is more easy to understand but ranking takes into account a long period of time.

So what if I remove them ?

Overall :

1 - XBO : 408.4 points/day (1.0)
2 - PS4 379.5 points/day (0.93)
3 - NS : 368.7 points/day (0.90)

Slightly better, the artifactual lead on XBO is less, but we are still far from the truth...

XBO get a lot of point by having many SKU ranking in top 100, even if not very high on the list. So I changed the point system to award more point to high ranking items (#100 = 1 point, #51 = 50 points, #49 = 52 points, #21 = 110 points, #20 = 115 points, #1 = 210 points) :

1 - NS : 551.7 points/day (1.0)
2 - PS4 519.6 points/day (0.94)
3 - XBO : 506.5 points/day (0.92)

Ok, so indeed, XBO lead is gone but now switch is first... I went with the idea that switch might be too high on amazon and best buy and decided to weight retailers as follow : Gamestop : 1, Best Buy : 0.2, Amazon, 0.5.

1 - PS4 : 237.3 points/day (1.12)
2 - NS 216.9 points/day (1.02)
3 - XBO : 212.6 points/day (1.0)

This does look a lot better !

However, by focusing on the only 5 days for which I have all 3 retailers (I have no gamestop numbers for first 3 days...) the "working weighting" becomes : Gamestop : 1, Best Buy : 0.2, Amazon, 0.8 :

1 - PS4 : 363.6 points/day (1.15)
2 - NS 326 points/day (1.03)
3 - XBO : 315.2 points/day (1.0)

So this is probably how I will go from now on. I will post soon to give April summary with both old and new system...
If you have ideas/suggestions...