These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, April 14, 2016

Equity Stock Ticker: Scraping The Web

Executive Summary



The project I did was based on a company I would like to eventually start. I plan to open up an investment fund in the future once I’ve gained more experience the industry and have a reputable name. There are multiple types of ways to run a fund, it can be passive or active, it can be long or it can be short, it can have equity and bonds or many other asset classes. This project focused specifically on a tool for an analyst, portfolio manager, or fund manager who wants to look up information on a publicly traded company and have some of the basic and important information returned to them. The project involved web scraping using the agent class that Professor Gove developed, along with scraping information from a Bloomberg Computer. Most investment funds will have access to a Bloomberg Terminal and so this would still be a very useful tool. The system I built takes one input, a stock ticker, and from there gives you the options to fill the spreadsheet with all the information you might want through the click of a few macro-linked buttons.


**Just remember that if you want the numbers to show up on the Quarterly Trend Ratios, Annual Trend Ratios, and Competitor Ratios sheets, you need to be on a Bloomberg terminal. It's w237 in the Tanner Building and there are multiple terminals there.

http://files.gove.net/shares/files/16w/julioce/vba_project.xlsm
http://files.gove.net/shares/files/16w/julioce/Final_Project_Write_Up.pdf

3 comments:

  1. Thanks for this relevant information. I will also share information Where you can find good info about Projects For MBA.

    ReplyDelete
  2. I want to share a testimony on how Le_Meridian funding service helped me with loan of 2,000,000.00 USD to finance my marijuana farm project , I'm very grateful and i promised to share this legit funding company to anyone looking for way to expand his or her business project.the company is UK/USA funding company. Anyone seeking for finance support should contact them on lfdsloans@outlook.com Or lfdsloans@lemeridianfds.com Mr Benjamin is also on whatsapp 1-989-394-3740 to make things easy for any applicant. 

    ReplyDelete
  3. Contact: pedroloanss@gmail.com / WhatsApp Number+1-8632310632 for loan offer,
    Mr Pedro enabled me to take advantage of an incredible opportunity to relocate and expand my business with his loan offer, at a pivotal time. The support I received from the Loan Firm Pedro working for it was priceless.

    ReplyDelete

Blog Archive