Thematic Portfolio Construction Using Latent Semantic Analysis _ Method Results and Conclusion

Method and Results:

In this paper we are going to construct four themes – hydrogen, water, clean energy, and ocean sustainability- using LSA.

First, use Russell 3000 base universe and go through all databases to find available documents within last 9 months that have keyword "hydrogen", controlling the length of target text to be of ideal number of words. There are 2786 records generated from a wide array of document sources including  'MCT', 'DJNS', 'BW', 'FCIS', 'SA', 'BAML', 'GNW', 'AWF', 'EDG', 'DJBT', 'DGAP', 'PRN', 'DJCM', 'TWTR', 'SDR', 'FBLK', 'EDGSEC',  'FT', 'FCST', 'DJCS', 'MTNA', 'DJPR', 'PRNE', 'FCSTEV', 'RSDAM',  'DJES', 'DJGQ', 'FFR', 'WSJ', 'CRN', 'PRNA', 'TDN', 'AWP', 'ASX', 'MTEMEA', 'BRF', 'ACW', 'AFP', 'IA', 'ECMT', 'FSWA', 'SW', 'FFW', 'AFPE', 'RJ', 'DJIN', 'OMX', 'CNW', 'RF', 'FINW', 'FGP', 'AWG', 'PNCV', 'NAR'.

Take the first document for example, “‘particular has seemed to be focused on electric and hydrogen technology. Boeing, on the other hand, have recently that the use of electric or hybrid technology or hydrogen technology in the mainline aircraft, the bread’

A is the document to term/word matrix, A*At is the word/term to term matrix;

while At*A is the document to document matrix

And this is the word/term matrix

After cleansing it removing repetitive stop words, this text is converted to ‘particular seemed focused electric hydrogen technology boeing hand recentlythat use electric hybrid technology hydrogen technology mainline aircraft bread’.

After vectorizing the corpora of these documents, we formed a large-scale matrix with a shape of (2786, 12527). After applying the SVD computation, we set the parameter to be top 3 topics/features,

Further, to know what this top topic or feature is

While topic 2 are composed of different set of words:

Now we have the ranking of every document, which is associated to a company, next, we need to identify the most relevant company accordingly. Since some documents are related to multiple stocks/companies, we remove them only keep document pointing to single stock. Additionally, we found FCST (transcript database) brought back the most number of documents(250), so we filter only FCST sourced documents for each company, take average of their topic score, keep those with topic1 score is equal or greater than the (mean-standard deviation) value, we obtained a US hydrogen portfolio (market cap >= $300m):

IdDatep_symbolp_symbol.1p_symbol.2ff_co_namep_market_val_secp_exchangeadtvtopic_1
PLUG-US2/22/2021US72919P20202508386PLUG-USPlug Power, Inc.28085.7NAS18510.478346
FCEL-US2/22/2021US35952H6018BK6S6J8FCEL-USFuelCell Energy, Inc.6519.221NAS790.95320.475276
APD-US2/22/2021US00915810682011602APD-USAir Products & Chemicals, Inc.58390.55NYS329.08460.413747
BE-US2/22/2021US0937121079BDD1BB8BE-USBloom Energy Corp.4431.369NYS162.75630.394135
NJR-US2/22/2021US64602510682630513NJR-USNew Jersey Resources Corp.3811.517NYS19.250940.374612
GTLS-US2/22/2021US16115Q3083B19HNF4GTLS-USChart Industries, Inc.4832.831NYS44.408890.36377
ATI-US2/22/2021US01741R10232526117ATI-USAllegheny Technologies, Inc.2457.702NYS26.811740.352432
LIN-US2/22/2021IE00BZ12WP82BZ12WP8LIN-USLinde Plc131676.1NYS412.17470.348215
DUK-US2/22/2021US26441C2044B7VD3F2DUK-USDuke Energy Corp.68002.67NYS247.31410.331449
PCAR-US2/22/2021US69371810882665861PCAR-USPACCAR, Inc.33024.91NAS147.49110.319731
LXFR-US2/22/2021GB00BNK03D49BF5GRT5LXFR-USLuxfer Holdings Plc515.4283NYS1.5483030.314576
BKR-US2/22/2021US05722G1004BDHLTQ5BKR-USBaker Hughes Co.16048.12NYS126.23610.299677
WMB-US2/22/2021US96945710042967181WMB-USThe Williams Cos., Inc.27475.58NYS184.65940.279647
CMI-US2/22/2021US23102110632240202CMI-USCummins, Inc.36522.11NYS242.09750.279477
SRE-US2/22/2021US81685110902138158SRE-USSempra Energy37651.45NYS190.39790.278915
NEE-US2/22/2021US65339F10122328915NEE-USNextEra Energy, Inc.153066.2NYS554.42320.277359
CF-US2/22/2021US1252691001B0G4K50CF-USCF Industries Holdings, Inc.9792.64NYS90.935230.276364
KBR-US2/22/2021US48242W1062B1HHB18KBR-USKBR, Inc.4597.922NYS33.577740.265426
WEC-US2/22/2021US92939U1060BYY8XK8WEC-USWEC Energy Group, Inc.26253.62NYS110.14520.264127
EMR-US2/22/2021US29101110442313405EMR-USEmerson Electric Co.51272.54NYS203.04240.263428
AGR-US2/22/2021US05351W1036BYP0CD9AGR-USAvangrid, Inc.13930.19NYS27.297430.255663
MTRX-US2/22/2021US57685310562572068MTRX-USMatrix Service Co.346.2235NAS2.9376730.255432
RUSHA-US2/22/2021US78184620922966876RUSHA-USRush Enterprises, Inc.1750.737NAS8.1772290.252914
KMI-US2/22/2021US49456B1017B3NQ4P8KMI-USKinder Morgan, Inc.33866.36NYS245.76930.24455
OGS-US2/22/2021US68235P1084BJ0KXV4OGS-USONE Gas, Inc.3932.356NYS18.447670.240674
PSX-US2/22/2021US7185461040B78C4Y8PSX-USPhillips 6635953.02NYS205.90260.238571
DAN-US2/22/2021US2358252052B2PFJR3DAN-USDana, Inc.3223.261NYS26.269790.238432
DOV-US2/22/2021US26000310802278407DOV-USDover Corp.17561.12NYS85.921940.217643
BEPC-US2/22/2021CA11284V1058BMW8YT2BEPC-USBrookfield Renewable Corp.8469.609NYS44.287240.217028
XOM-US2/22/2021US30231G10222326618XOM-USExxon Mobil Corp.221682.2NYS1212.7710.216212
SLB-US2/22/2021AN80685710862779201SLB-USSchlumberger NV36367.56NYS281.78260.215069
AZPN-US2/22/2021US04532710352051868AZPN-USAspen Technology, Inc.10537.36NAS51.475380.21272
TSLA-US2/22/2021US88160R1014B616C79TSLA-USTesla, Inc.749933.5NAS26729.570.207524
HY-US2/22/2021US4491721050B7LG306HY-USHyster-Yale Materials Handling, Inc.1246.51NYS5.9774560.207209
NFG-US2/22/2021US63618010112626103NFG-USNational Fuel Gas Co.4144.29NYS18.881970.199536
LAZ-US2/22/2021BMG540501027B081VQ7LAZ-USLazard Ltd.4641.453NYS27.899170.199406
ATO-US2/22/2021US04956010582315359ATO-USAtmos Energy Corp.11990.71NYS90.414020.195311
J-US2/22/2021US46981410782469052J-USJacobs Engineering Group, Inc.14622.99NYS67.328130.194618
SJI-US2/22/2021US83851810812825933SJI-USSouth Jersey Industries, Inc.2440.321NYS19.194880.190869
CC-US2/22/2021US1638511089BZ0CTP8CC-USThe Chemours Co.4286.212NYS29.733140.189885
CAT-US2/22/2021US14912310152180201CAT-USCaterpillar, Inc.114464.7NYS510.41170.188521
CMS-US2/22/2021US12589610022219224CMS-USCMS Energy Corp.16175.05NYS99.265980.186496
OKE-US2/22/2021US68268010362130109OKE-USONEOK, Inc.20362.29NYS119.09310.186074
VLO-US2/22/2021US91913Y10012041364VLO-USValero Energy Corp.29169.16NYS224.59730.185284
XEL-US2/22/2021US98389B10082614807XEL-USXcel Energy, Inc.33371.86NAS154.88650.185053
RTX-US2/22/2021US75513E1010BM5M5Y3RTX-USRaytheon Technologies Corp.112836.4NYS459.65140.178425
NWN-US2/22/2021US66765N1054BFNR303NWN-USNorthwest Natural Holding Co.1494.192NYS14.113950.178126
ETR-US2/22/2021US29364G10312317087ETR-USEntergy Corp.18657.67NYS128.17040.176371
GM-US2/22/2021US37045V1008B665KZ5GM-USGeneral Motors Co.75748.79NYS991.47990.171622
AMRC-US2/22/2021US02361E1082B3SWPT2AMRC-USAmeresco, Inc.1919.791NYS22.210050.167686
ETN-US2/22/2021IE00B8KQN827B8KQN82ETN-USEaton Corp. Plc50941.08NYS228.14940.162775
HON-US2/22/2021US43851610662020459HON-USHoneywell International, Inc.141576.2NYS518.07620.160773
CNP-US2/22/2021US15189T10792440637CNP-USCenterPoint Energy, Inc.11675.52NYS95.80310.158457
ALSN-US2/22/2021US01973R1014B4PZ892ALSN-USAllison Transmission Holdings, Inc.4269.581NYS37.740420.157128
NOV-US2/22/2021US62955J1034BN2RYW9NOV-USNOV, Inc.5446.604NYS70.771020.156641
CVX-US2/22/2021US16676410052838555CVX-USChevron Corp.184420NYS856.66110.156143
WAB-US2/22/2021US92974010882955733WAB-USWestinghouse Air Brake Technologies Corp.13970.75NYS81.671420.155003
BA-US2/22/2021US09702310582108601BA-USThe Boeing Co.126784.3NYS3091.6030.154109
NEM-US2/22/2021US65163910662636607NEM-USNewmont Corp.45353.81NYS355.1040.15371
CMCO-US2/22/2021US19933310572211071CMCO-USColumbus McKinnon Corp.1149.692NAS3.307570.153693
LAD-US2/22/2021US53679710342515030LAD-USLithia Motors, Inc.10062.54NYS85.050160.151705
IR-US2/22/2021US45687V1061BL5GZ82IR-USIngersoll Rand, Inc.18330.91NYS75.648190.149595
FLT-US2/22/2021US3390411052B4R28B3FLT-USFLEETCOR Technologies, Inc.22872.66NYS158.8640.147923
FLS-US2/22/2021US34354P10572288406FLS-USFlowserve Corp.5111.537NYS28.420580.14479
DCI-US2/22/2021US25765110992276467DCI-USDonaldson Co., Inc.7705.685NYS26.485340.140336
UGI-US2/22/2021US90268110522910118UGI-USUGI Corp.8402.635NYS33.494690.139997
GE-US2/22/2021US36960410332380498GE-USGeneral Electric Co.105390.7NYS821.65110.139869
HAYN-US2/22/2021US4208772016B02WVH7HAYN-USHaynes International, Inc.369.8114NAS2.6843210.137949
SR-US2/22/2021US84857L1017BYXJQG9SR-USSpire Inc.3496.14NYS19.323820.136633
THR-US2/22/2021US88362T1034B3N6F00THR-USThermon Group Holdings, Inc.592.5712NYS2.3250630.130383
FLR-US2/22/2021US34341210222696838FLR-USFluor Corp.2434.373NYS31.811620.129712
SNDR-US2/22/2021US80689H1023BYVN953SNDR-USSchneider National, Inc.2210.975NYS12.604890.128699
NI-US2/22/2021US65473P10572645409NI-USNiSource, Inc.8950.076NYS60.862710.126539
AES-US2/22/2021US00130H10592002479AES-USThe AES Corp.18829.86NYS144.54940.119861
TPIC-US2/22/2021US87266J1043BYYGK12TPIC-USTPI Composites, Inc.2519.726NAS41.51750.11437
SO-US2/22/2021US84258710712829601SO-USThe Southern Co.62667.52NYS201.15520.114074
ENS-US2/22/2021US29275Y1029B020GQ5ENS-USEnerSys3898.603NYS19.748590.113874
WERN-US2/22/2021US95075510862948852WERN-USWerner Enterprises, Inc.2955.709NAS23.466650.108954
ADM-US2/22/2021US03948310202047317ADM-USArcher-Daniels-Midland Co.31338.2NYS117.72020.10666
ASPN-US2/22/2021US04523Y1055BN65SM7ASPN-USAspen Aerogels, Inc.638.6505NYS4.758750.104615
HASI-US2/22/2021US41068X1000B9HHD96HASI-USHannon Armstrong Sustainable Infrastructure Capital, Inc.4847.081NYS43.00330.10375
PBF-US2/22/2021US69318G1067B7F4TJ7PBF-USPBF Energy, Inc.1623.798NYS51.754310.103303
GTES-US2/22/2021GB00BD9G2S12BD9G2S1GTES-USGates Industrial Corp. Plc4941.593NYS3.3515950.101966
EQIX-US2/22/2021US29444U7000BVLZX12EQIX-USEquinix, Inc.60735.38NAS343.9330.101727
IDA-US2/22/2021US45110710642296937IDA-USIDACORP, Inc.4450.377NYS27.235980.100936
TT-US2/22/2021IE00BK9ZQ967BK9ZQ96TT-USTrane Technologies Plc36708.48NYS173.72510.098733
ACM-US2/22/2021US00766T1007B1VZ431ACM-USAECOM8443.192NYS55.00990.09789
REVG-US2/22/2021US7495271071BDRW1P1REVG-USREV Group, Inc.784.92NYS2.7236620.097737
MDU-US2/22/2021US55269010962547323MDU-USMDU Resources Group, Inc.5698.835NYS23.497030.097626
SPGI-US2/22/2021US78409V1044BYV2325SPGI-USS&P Global, Inc.81655.06NYS546.53090.097095
PWR-US2/22/2021US74762E10292150204PWR-USQuanta Services, Inc.10727.01NYS77.1580.094897
INFO-US2/22/2021BMG475671050BD0Q558INFO-USIHS Markit Ltd.36962.36NYS285.41820.094232
DOW-US2/22/2021US2605571031BHXCF84DOW-USDow, Inc.44925NYS206.12390.093536
REGI-US2/22/2021US75972A3014B7577T2REGI-USRenewable Energy Group, Inc.3813.307NAS84.502220.09342
CVI-US2/22/2021US12662P1084B23PS12CVI-USCVR Energy, Inc.2302.151NYS9.3934560.091302
WTRG-US2/22/2021US29670G1022BLCF3J9WTRG-USEssential Utilities, Inc.11177.03NYS46.775270.091217
CLF-US2/22/2021US1858991011BYVZ186CLF-USCleveland-Cliffs, Inc.8490.291NYS210.69240.090391
WOR-US2/22/2021US98181110262981932WOR-USWorthington Industries, Inc.3294.414NYS13.304050.090075
MPC-US2/22/2021US56585A1025B3K3L40MPC-USMarathon Petroleum Corp.34503NYS253.62270.08948
VNT-US2/22/2021US9288811014BH4GV32VNT-USVontier Corp.5284.069NYS81.302910.088447
MTZ-US2/22/2021US57632310902155306MTZ-USMasTec, Inc.6343.693NYS52.902160.088215
OLN-US2/22/2021US68066520522658526OLN-USOlin Corp.4732.704NYS33.215980.086323
MNR-US2/22/2021US60972010722504072MNR-USMonmouth Real Estate Investment Corp.1758.598NYS9.6515290.084795

Next, we’d try the same method on Korean stock market.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.