+ Reply to Thread
Results 1 to 4 of 4

Need help with sorting and filtering, stock tickers and price to economic book value

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    Tennessee
    MS-Off Ver
    2007
    Posts
    3

    Need help with sorting and filtering, stock tickers and price to economic book value

    I have five columns: Column A-the first is a set of ticker symbols, Column B-the Price to economic book value, Column C- Free Cash Flow Yield, Column D-a selected few ticker symbols from column A, and Column E- Which asks to Use excel to find the price to economic book value for the tickers in column E that were selected from column A. How do I get this information using excel?

  2. #2
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    608

    Re: Need help with sorting and filtering...stock tickers and price to economic book value

    It would help if you could upload a sample workbook
    If I helped, please don't forget to add to my reputation. (click on the star below the post)

    If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.

    Failure is not falling down but refusing to get up.

  3. #3
    Registered User
    Join Date
    05-17-2012
    Location
    Tennessee
    MS-Off Ver
    2007
    Posts
    3

    Re: Need help with sorting and filtering...stock tickers and price to economic book value

    here is a sample:
    Ticker-Price to economic book value-Free cash flow yield
    A 1 -5% AAJ
    AAD 0.4 -4% AAK
    AAE 1.4 -5% AB
    AAG 1.7 8%
    AAJ 1.1 -10%
    AAK 1.4 -5%
    AAL 1.1 -15%
    AAR 1.3 -15%
    AB 1.4 -11%

    Use excel to find the price to economic book value for the tickers in column E (aaj, aak, ab) that were selected from column A

  4. #4
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    608

    Re: Need help with sorting and filtering...stock tickers and price to economic book value

    Hi

    If I understand correctly,

    =VLOOKUP(D1,$A$1:$C$9,3)

    in E1 and copy down

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1