入力
出力
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg==
ウィークリーチャレンジ #72
C:\Users\mtokimatsu\AppData\Local\Alteryx\Engine\Engine_4836_8f2b6bf6fa09419a9ee3a558c5583a1c_\Engine_10468_9a781ce9685a4d0bb142661782c3fb40_.yxdb
Single
プロファイル
C:\Users\mtokimatsu\AppData\Local\Alteryx\Engine\Engine_4836_8f2b6bf6fa09419a9ee3a558c5583a1c_\Engine_10468_fedf455d923b40c8a9e344b7f7d6b8c1_.yxdb
Single
プロファイル
Ranks as of August 11, 2015
TNA Latest
month-end ($mil)
Fund
1 day
1 month
3 month
Y-T-D
1 yr
3 yrs
5 yrs
10 yrs
15 yrs
Taxable - A shares
1110.0999999999999
A - FBLI
32
47.5
9.5
8
6
6868.3
A - TVG
10
54.5
20
13.5
44
48.5
39
48
48
10874.3
A - AFBI
10
13.5
6.5
20.5
27
63.5
63
68.5
69.5
1757.5
A - FMFA
71.5
71.5
54.5
26.5
42.5
15
28378.5
A - AFB
30.5
38.5
30.5
40.5
44
52
56.5
83
75.5
4728.1000000000004
A - FBTS
38.5
74
53
53.5
52
68
70.5
12831.3
A - FBW
43
51
57
59.5
60.5
60
52
55.5
31
18396.2
A - TIHA
94.5
90.5
93
91
82
80.5
81
69.5
48
Taxable - R6 shares
6868.3
6R - TVG
8
49
8.5
3.5
24
22.5
22.5
1110.0999999999999
6R - FBLI
33
49.5
3.5
6
5.5
10874.3
6R - AFBI
7.5
11.5
3.5
9
11.5
44.5
48
1757.5
6R - FMFA
27
55
29
11.5
16
5
28378.5
6R - AFB
29
32.5
22.5
22.5
28
34.5
40
4728.1000000000004
6R - FBTS
33.5
69
40
29
35
52.5
59
12831.3
6R - FBW
21.5
48.5
52
53
54.5
55.5
44.5
18396.2
6R - TIHA
94
90
92
89
78.5
69
69.5
Tax-Exempt - A shares
10475.1
A - FBET
79
26.5
28.5
20.5
26
18
22.5
23.5
22
726.2
A - XETS
60
19.5
38
34
64
46.5
51.5
3601.6
A - MIHA
34
39
45.5
39.5
51.5
12
16.5
20.5
27.5
3183.1
A - XETL
83
85.5
58.5
40.5
85.5
72
75.5
74.5
82
1661.9
A - ACFET
59.5
64
61
43
56
33
32.5
32.5
37
155.69999999999999
A - YNFET
16.5
38
78
60.5
65
44
314.39999999999998
A - DMFET
77
48
65.5
64
61.5
34
36
60
54.5
468
A - AVFET
86
48.5
72.5
71.5
54
43
42
45.5
44
Tax-Exempt - F2 shares
10475.1
2F - FBET
79
25.5
25.5
16
21.5
13
17.5
726.2
2F - XETS
60
18.5
35.5
30.5
59
43.5
48.5
3183.1
2F - XETL
82
84
53
31.5
80
64.5
71
3601.6
2F - MIHA
33.5
35.5
42.5
33.5
46
8
11.5
1661.9
2F - ACFET
58.5
61
58
34.5
49.5
28
29.5
155.69999999999999
2F - YNFET
15.5
36
73.5
51
50.5
41
314.39999999999998
2F - DMFET
75.5
45
61
58
55.5
29.5
26.5
468
2F - AVFET
84
46
69
66.5
48.5
34.5
35.5
AFIS - Class 1
3218.1
1 - TVGIV
344.8
1 - FMIV
2528.5
1 - FBGIV
9957.7999999999993
1 - FBIV
1987.9
1 - BIHIV
Internally launched
28.311739679999999
FOSGC
6
16.500000000000004
1.5000000000000013
2.0000000000000018
1.0000000000000009
50.452931479999997
FBC
65
28.5
31.5
16.000000000000004
13.999999999999996
44.678267649999995
IHG
91
97
96
93.5
99
August 11, 2015
Taxable - A shares
A - FBLI
1110.0999999999999
32
47.5
9.5
8
6
August 11, 2015
Taxable - A shares
A - TVG
6868.3
10
54.5
20
13.5
44
48.5
39
48
48
August 11, 2015
Taxable - A shares
A - AFBI
10874.3
10
13.5
6.5
20.5
27
63.5
63
68.5
69.5
August 11, 2015
Taxable - A shares
A - FMFA
1757.5
71.5
71.5
54.5
26.5
42.5
15
August 11, 2015
Taxable - A shares
A - AFB
28378.5
30.5
38.5
30.5
40.5
44
52
56.5
83
75.5
August 11, 2015
Taxable - A shares
A - FBTS
4728.1000000000004
38.5
74
53
53.5
52
68
70.5
August 11, 2015
Taxable - A shares
A - FBW
12831.3
43
51
57
59.5
60.5
60
52
55.5
31
August 11, 2015
Taxable - A shares
A - TIHA
18396.2
94.5
90.5
93
91
82
80.5
81
69.5
48
August 11, 2015
Taxable - R6 shares
6R - TVG
6868.3
8
49
8.5
3.5
24
22.5
22.5
August 11, 2015
Taxable - R6 shares
6R - FBLI
1110.0999999999999
33
49.5
3.5
6
5.5
August 11, 2015
Taxable - R6 shares
6R - AFBI
10874.3
7.5
11.5
3.5
9
11.5
44.5
48
August 11, 2015
Taxable - R6 shares
6R - FMFA
1757.5
27
55
29
11.5
16
5
August 11, 2015
Taxable - R6 shares
6R - AFB
28378.5
29
32.5
22.5
22.5
28
34.5
40
August 11, 2015
Taxable - R6 shares
6R - FBTS
4728.1000000000004
33.5
69
40
29
35
52.5
59
August 11, 2015
Taxable - R6 shares
6R - FBW
12831.3
21.5
48.5
52
53
54.5
55.5
44.5
August 11, 2015
Taxable - R6 shares
6R - TIHA
18396.2
94
90
92
89
78.5
69
69.5
August 11, 2015
Tax-Exempt - A shares
A - FBET
10475.1
79
26.5
28.5
20.5
26
18
22.5
23.5
22
August 11, 2015
Tax-Exempt - A shares
A - XETS
726.2
60
19.5
38
34
64
46.5
51.5
August 11, 2015
Tax-Exempt - A shares
A - MIHA
3601.6
34
39
45.5
39.5
51.5
12
16.5
20.5
27.5
August 11, 2015
Tax-Exempt - A shares
A - XETL
3183.1
83
85.5
58.5
40.5
85.5
72
75.5
74.5
82
August 11, 2015
Tax-Exempt - A shares
A - ACFET
1661.9
59.5
64
61
43
56
33
32.5
32.5
37
August 11, 2015
Tax-Exempt - A shares
A - YNFET
155.69999999999999
16.5
38
78
60.5
65
44
August 11, 2015
Tax-Exempt - A shares
A - DMFET
314.39999999999998
77
48
65.5
64
61.5
34
36
60
54.5
August 11, 2015
Tax-Exempt - A shares
A - AVFET
468
86
48.5
72.5
71.5
54
43
42
45.5
44
August 11, 2015
Tax-Exempt - F2 shares
2F - FBET
10475.1
79
25.5
25.5
16
21.5
13
17.5
August 11, 2015
Tax-Exempt - F2 shares
2F - XETS
726.2
60
18.5
35.5
30.5
59
43.5
48.5
August 11, 2015
Tax-Exempt - F2 shares
2F - XETL
3183.1
82
84
53
31.5
80
64.5
71
August 11, 2015
Tax-Exempt - F2 shares
2F - MIHA
3601.6
33.5
35.5
42.5
33.5
46
8
11.5
August 11, 2015
Tax-Exempt - F2 shares
2F - ACFET
1661.9
58.5
61
58
34.5
49.5
28
29.5
August 11, 2015
Tax-Exempt - F2 shares
2F - YNFET
155.69999999999999
15.5
36
73.5
51
50.5
41
August 11, 2015
Tax-Exempt - F2 shares
2F - DMFET
314.39999999999998
75.5
45
61
58
55.5
29.5
26.5
August 11, 2015
Tax-Exempt - F2 shares
2F - AVFET
468
84
46
69
66.5
48.5
34.5
35.5
August 11, 2015
AFIS - Class 1
1 - TVGIV
3218.1
August 11, 2015
AFIS - Class 1
1 - FMIV
344.8
August 11, 2015
AFIS - Class 1
1 - FBGIV
2528.5
August 11, 2015
AFIS - Class 1
1 - FBIV
9957.7999999999993
August 11, 2015
AFIS - Class 1
1 - BIHIV
1987.9
August 11, 2015
Internally launched
FOSGC
28.311739679999999
6
16.500000000000004
1.5000000000000013
2.0000000000000018
1.0000000000000009
August 11, 2015
Internally launched
FBC
50.452931479999997
65
28.5
31.5
16.000000000000004
13.999999999999996
August 11, 2015
Internally launched
IHG
44.678267649999995
91
97
96
93.5
99
Date
String
15
NULL
IIF(IsNull([Row-1:Date]), right([American Funds Fixed Income Funds Daily Mstar/Lipper Blended Percent Ranks],15), [Row-1:Date])
IIF(IsNull([Row-1:Date]), right([American Funds Fixed Income ...
Skip
2
最初をスキップする 2
FirstRow
Warn
TNA Latest
month-end ($mil)
ShareClass
String
22
Empty
IIF(IsNull([Fund]), [TNA Latest
month-end ($mil)], [Row-1:ShareClass])
IIF(IsNull([Fund]), [TNA Latest
month-end ($mil)], [Row-1:Sh...
Simple
IsNotNull
Fund
True
fixed
2020-07-14 10:05:23
0
2020-07-14 10:05:23
2020-07-14 10:05:23
!IsNull([Fund])
Horizontal
challenge_ja_72_toki