Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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.txtimage text in transcribed and display an ordered list similar to the screen shown below.

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions