Question
The Dogs of the Dow is an investment strategy popularized by Michael B. O'Higgins in 1991, which proposes that an investor annually select for investment
The Dogs of the Dow is an investment strategy popularized by Michael B. O'Higgins in 1991, which proposes that an investor annually select for investment the ten Dow Jones Industrial Average (DJIA) stocks whose dividend is the highest fraction of their price.
The purpose of this project is to read in all values from DOW2014.txt and display an ordered list similar to the screen shown below.
Create a Structure named Stock consisting of the below members. The data record structure matches the displayed order of the members.
company
symbol
exchange
industry
price2013 'price at end of 2013
price2014 'price at end of 2014
earningsPerShare
dividend
Read in all values from the input file into an array of type Stock. Use a LINQ query to determine each dividend ratio (dividend / price2014). Order the equities in descending order by their dividend ratio.
Display the results in a DataGridview control. Rename the columns as:
company = "Company"
symbol = "Symbol"
ratio = "Yield as of 12/31/2014"
DOW2014.txt
American Express,AXP,NYSE,Consumer finance,90.73,93.04,5.56,1.01
Boeing,BA,NYSE,Aerospace & defense,136.49,129.98,7.38,3.1
Caterpillar,CAT,NYSE,Construction & mining equipment,90.81,91.53,5.88,2.7
Cisco Systems,CSCO,NASDAQ,Computer networking,22.43,27.82,1.49,0.72
Chevron Corporation,CVX,NYSE,Oil & gas,124.91,112.18,10.14,4.28
DuPont,DD,NYSE,Chemical industry,64.97,71.26,3.92,1.79
Walt Disney,DIS,NYSE,Broadcasting & entertainment,76.4,71.26,4.26,0.86
General Electric,GE,NYSE,Conglomerate,28.03,25.27,1.5,0.89
Goldman Sachs,GS,NYSE,Banking,177.26,193.83,17.07,2.25
The Home Depot,HD,NYSE,Home improvement retailer,61.85,104.97,4.71,2
International Business Machines,IBM,NYSE,Computers &
technology,187.57,160.44,11.9,4.4
Intel,INTC,NASDAQ,Semiconductors,25.95,36.29,2.31,0.915
Johnson & Johnson,JNJ,NYSE,Pharmaceuticals,91.59,104.57,5.7,2.76
JPMorgan Chase,JPM,NYSE,Banking,58.48,62.58,5.29,1.58
Coca-Cola,KO,NYSE,Beverages,41.31,42.22,1.6,1.22
McDonald's,MCD,NYSE,Fast food,97.03,93.7,4.82,3.28
3M,MMM,NYSE,Conglomerate,140.25,164.32,7.49,3.59
Merck,MRK,NYSE,Pharmaceuticals,50.05,56.79,4.04,1.77
Microsoft,MSFT,NASDAQ,Software,37.41,46.45,2.63,1.07
Nike,NKE,NYSE,Consumer goods,78.64,96.15,2.97,0.93
Pfizer,PFE,NYSE,Pharmaceuticals,30.63,31.15,1.42,1.06
Procter & Gamble,PG,NYSE,Consumer goods,81.41,91.09,4.11,2.49
AT&T,T,NYSE,Telecommunication,35.16,33.59,1.19,1.85
Travelers,TRV,NYSE,Insurance,90.54,105.85,10.7,2.15
UnitedHealth Group,UNH,NYSE,Managed health care,75.3,101.09,5.7,1.405
United Technologies Corp.,UTX,NYSE,Conglomerate,113.8,115,6.82,2.41
Verizon,VZ,NYSE,Telecommunication,49.14,46.78,2.42,2.16
Visa,V,NYSE,Consumer finance,55.67,65.55,2.155,0.42
Walmart,WMT,NYSE,Retail,78.69,85.88,5.05,0.48
ExxonMobil,XOM,NYSE,Oil & gas,101.2,92.45,7.6,2.76
i want code in Visual Basic
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started