22SEP3 sentiment analysis.xlsx

	B	C	D	E	F	G	H	I	J
1
2	company basics			sentiment stuff
3	ticker	twitter handle	p/e	:(	:\|	:)	pos/total	neg/total	total
4	AAPL	@Apple	25.8	353	329	318	0.32	0.35	1000
5	AMGN	@Amgen	20.6	15	53	62	0.48	0.12	130
6	AXP	@AmericanExpress	15.3	512	333	155	0.16	0.51	1000
7	BA	@Boeing	-17.2	106	152	42	0.14	0.35	300
8	CAT	@CaterpillarInc	14.5	67	307	626	0.63	0.07	1000
9	CRM	@Salesforce	301.4	67	309	624	0.62	0.07	1000
10	CSCO	@Cisco	15.8	62	231	706	0.71	0.06	999
11	CVX	@Chevron	10.5	232	225	118	0.21	0.40	575
12	DIS	@Disney	63.5	255	334	411	0.41	0.26	1000
13	DOW	@DowJones	5.5	66	106	28	0.14	0.33	200
14	GS	@GoldmanSachs	7.5	168	215	69	0.15	0.37	452
15	HD	@HomeDepot	17.9	453	285	262	0.26	0.45	1000
16	HON	@Honeywell	25.5	43	105	47	0.24	0.22	195
17	IBM	@IBM	21.0	175	370	455	0.46	0.18	1000
18	INTC	@Intel	6.7	170	341	488	0.49	0.17	999
19	JNJ	@JNJNews	23.7	92	119	40	0.16	0.37	251
20	JPM	@JPMorgan	9.1	34	45	35	0.31	0.30	114
21	KO	@CocaCola	27.8	229	441	330	0.33	0.23	1000
22	MCD	@McDonalds	31.3	388	414	198	0.20	0.39	1000
23	MMM	@3M	17.0	50	118	98	0.37	0.19	266
24	MRK	@Merck	13.2	24	101	73	0.37	0.12	198
25	MSFT	@Microsoft	26.5	304	403	293	0.29	0.30	1000
26	NKE	@Nike	28.2	165	345	489	0.49	0.17	999
27	PG	@ProcterGamble	23.6	162	115	72	0.21	0.46	349
28	TRV	@Travelers	11.3	47	41	32	0.27	0.39	120
29	UNH	@UHC	27.0	181	110	97	0.25	0.47	388
30	V	@Visa	29.1	513	331	156	0.16	0.51	1000
31	VZ	@Verizon	8.3	592	225	182	0.18	0.59	999
32	WBA	@Walgreens	6.0	541	247	212	0.21	0.54	1000
33	WMT	@Walmart	26.6	403	291	306	0.31	0.40	1000
34
35	sources:
36	tweets retrieved sep 2, 2022 with tweepy & twitter API (sep 3 for V, VZ, WMB, and WMT)
37	p/e ratios retrieved sep 2, 2022 with yahoo finance API
38	sentiment analysis with RoBERTa base model & huggingface inference API
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100