Data mining for fun and interest

C2 Explorer
1

Here’s an interesting query:
H2=“Popular systems by monthly subscription take”;
TABLE = (from stat in C2STATS
where stat.StatName==“numSubsNow” && stat.StatValueVal > 5
join sys in C2SYSTEMS on stat.SystemId equals sys.SystemId
select new {
Name = sys.SystemName,
Age = (DateTime.Now - sys.Started).Days,
Subs = stat.StatValueVal,
MonthlyFee = sys.MonthlyFee,
SubValue = stat.StatValueVal * sys.MonthlyFee,
}).OrderByDescending(x=>x.SubValue).Take(20);

It yields (3-Aug-18):

34%20AM
Screen Shot 2018-08-03 at 9.51.34 AM.png1824×1480 313 KB

There’s a couple of big numbers there. I understand why number 2 might have sold some subscriptions but not number 1!!

The rest are remarkably consistent.

C

1 Like
2

Now thats a very interesting find. Are these the current top subscribed systems?

3

That list is by subscription income, the list by number of subscribers is a little different:

02%20AM
Screen Shot 2018-08-03 at 10.48.02 AM.png1506×1170 103 KB

4

It brought ‘Bijagual’ to my attention and I have 0.2x to my model portfolio (see code#493) - it’s had a ‘positive’ effect…

5

There definitely something to be had by looking at stats!

6

Where exactly do you see the number of subscribers?

7

C2STATS.Where(stat=>stat.StatName==“numSubsNow")

8

VIXTrader Intelligent tho ???

Where would 35 subscribers that want to part with $1000/m for that strategy come from ??
And with 35 subscribers and 24 trades made you might think there would be more than 54 auto trades placed huh? (24x35 = 840 possible)

Weird one that…

9

Nice work Chris Bayley. In the not too distant past C2 used to provide sub #'s for its subscribers but then they removed them to avoid “herding instinct”. Pffffttttttt.

1 Like