Gathering of Stock Info in Excel

  • Durum: Closed
  • Ödül: $40
  • Alınan Girdiler: 5
  • Kazanan: sithalchordia

Yarışma Özeti

I am looking to create a stock screener using information that can be imported from Yahoo!Finance. It is a fairly simple stock screener, where it would list stock lists of the NASDAQ, S&P500, OTCBB, etc along with the information provided in the chart below.

All information for the chart can be found on the following websites (keep in mind XOM is the stock ticker):

[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]

Thank you in advance.

These are the column criteria i am looking for. Column 'A' (stock ticker)will have to be coded so that I can copy and paste a list of stock tickers and upon running the program, it will gather the following information(each designating it's own column):
Stock Ticker
Industry
Price
Volume
Market Cap
P/E
Avg Est Next Year
Industry P/E
Beta



Attached is a screenshot of approximately what I have in mind, but I welcome all other ideas.

Tavsiye Edilen Beceriler

İşveren Geribildirimi

“Great communication. Delivered exactly what I asked for and in a very timely fashion.”

Profil Görüntüsü kyleoconnell, United States.

Bu yarışmadan başlıca girdiler

Daha Fazla Katılım Görüntüle

Genel Açıklama Panosu

  • sithalchordia
    sithalchordia
    • 2 yıl önce

    Dear contest holder, any comments/feedback for Entry #4 ?

    • 2 yıl önce
  • sithalchordia
    sithalchordia
    • 2 yıl önce

    Dear contest holder can you please increase the contest prize...#increaseprize

    • 2 yıl önce
  • l8house
    l8house
    • 2 yıl önce

    where can we find Industry P/E ?

    • 2 yıl önce
  • hardikshah83
    hardikshah83
    • 2 yıl önce

    Please see entry # 1. I will transfer the sheet to you on award of project, its fully functional sheet already coded for you.

    • 2 yıl önce
  • humayoonsheikh4u
    humayoonsheikh4u
    • 2 yıl önce

    dear i have hands on expertise on such data scraping from yahoo finance, google finance and morning star i can do it can you make it as a project please.

    • 2 yıl önce

Daha fazla yorum göster

Yarışmalara nasıl başlanır

  • Projenizi ilan edin

    Yarışmanızı İlan Edin Hızlı ve kolay

  • Tonlarca girdi alın

    Tonlarca Girdi Alın Bütün dünyadan

  • En iyi girdiyi seçin

    En iyi girdiyi seçin Dosyaları indirin - Kolay!

Şimdi bir Yarışma İlan Et ya da Bugün Bize Katılın!