Windows 10: Excel stock lookup gives wrong data

Discus and support Excel stock lookup gives wrong data in Windows 10 Software and Apps to solve the problem; [ATTACH] 2.85 is not the right answer for GAN... Discussion in 'Windows 10 Software and Apps' started by GaryBowers5, Jan 8, 2021.

  1. GARYBOWERS5
    GaryBowers5 Win User

    Excel stock lookup gives wrong data


    Excel stock lookup gives wrong data ce5ee425-668a-4d0e-9c81-d6ec65410c1a?upload=true.png

    2.85 is not the right answer for GAN

    :)
     
    GaryBowers5, Jan 8, 2021
    #1
  2. JIMBO45
    jimbo45 Win User

    EXCEL automate download stock prices at end of day

    Hi folks.

    anybody got suggestions on how to download end of day data for around 30 - 40 stocks (or more) using EXCEL and its Internet services.

    Basic data is OPEN/CLOSE/HIGH/LOW/VOLUME

    This can be downloaded from GOOGLE or YAHOO finance but it's a bit of a manual process and has to be done individually for each share / stock.

    There used to be an API from YAHOO which one could use to automate this process -- I don't think that works any more or is so changed that any old app would need a total re-write.

    Anybody got an easy system to do this -- I've no problem say in loading up an input file which contains the list of stocks for which I want to get the data.

    There are stock data services around but usually they require payments and registration which exposes you to a never ending stream of "Get Rich Quick" and "Try these trading schemes" type of spam and other junk email.

    Cheers
    jimbo
     
    jimbo45, Jan 8, 2021
    #2
  3. JIMBO45
    jimbo45 Win User
    EXCEL 2019 Stock and Geograpghy Data types missing

    Hi folks

    Is this only now an Office 365 feature -- for stock quotes the Stock and Geography data types aren't available it seems in current versions of Office 2019

    Any body messing around with Stock Exchange type of stuff on EXCEL --the old yahoo used to have excellent Free API but I think Corporate Greed is everywhere now so this type of stuff doesn't seem to be free any more

    Cheers
    jimbo
     
    jimbo45, Jan 8, 2021
    #3
  4. BRINK
    Brink Win User

    Excel stock lookup gives wrong data

    Windows Insider Fast - Speedy-lookup in Excel Information

    Source: Windows Insider Fast - Speedy-lookup in Excel Information - Microsoft Community
     
    Brink, Jan 8, 2021
    #4
Thema:

Excel stock lookup gives wrong data

Loading...

  1. Excel stock lookup gives wrong data - Similar Threads - Excel stock lookup

  2. What is the best setup for large Excel files and having instructions formulas, lookups,...

    in Windows 10 BSOD Crashes and Debugging
    What is the best setup for large Excel files and having instructions formulas, lookups,...: Currently running Windows Pro 10, version 22H2. Have the Intel W-2135 processor with 128GB of RAM. and a 64-bit operating system. When I do a Fuzzy look up with under 40,000 rows, current system works fine, takes less than 30 seconds. When I do a Fuzzy look up with 170,000+...

  3. What is the best setup for large Excel files and having instructions formulas, lookups,...

    in Windows 10 Gaming
    What is the best setup for large Excel files and having instructions formulas, lookups,...: Currently running Windows Pro 10, version 22H2. Have the Intel W-2135 processor with 128GB of RAM. and a 64-bit operating system. When I do a Fuzzy look up with under 40,000 rows, current system works fine, takes less than 30 seconds. When I do a Fuzzy look up with 170,000+...

  4. What is the best setup for large Excel files and having instructions formulas, lookups,...

    in Windows 10 Software and Apps
    What is the best setup for large Excel files and having instructions formulas, lookups,...: Currently running Windows Pro 10, version 22H2. Have the Intel W-2135 processor with 128GB of RAM. and a 64-bit operating system. When I do a Fuzzy look up with under 40,000 rows, current system works fine, takes less than 30 seconds. When I do a Fuzzy look up with 170,000+...

  5. Why is the Stock Data Type not pulling correct prices?

    in Windows 10 Gaming
    Why is the Stock Data Type not pulling correct prices?: I'm online using the free Excel. I converted some tickers into Stock Data Types in col B. Over in Col J, I inserted "=B2.Price" using the dropdown from the data card. I copied that celll down my column.My first ticker was SHOPIFY INC. XNYS:SHOP and ties in with Yahoo Finance...

  6. Why is the Stock Data Type not pulling correct prices?

    in Windows 10 Software and Apps
    Why is the Stock Data Type not pulling correct prices?: I'm online using the free Excel. I converted some tickers into Stock Data Types in col B. Over in Col J, I inserted "=B2.Price" using the dropdown from the data card. I copied that celll down my column.My first ticker was SHOPIFY INC. XNYS:SHOP and ties in with Yahoo Finance...

  7. Wrong Codec for Adobe Stock Motion Graphics etc.

    in Windows 10 Drivers and Hardware
    Wrong Codec for Adobe Stock Motion Graphics etc.: I am using Windows 10 along with Microsoft 365. I have downloaded several motion graphics from Adobe Stock that do not work due to the wrong Codec on the CPU ... Please HELP as I have no idea how to correct the situation! Thank you. -jb- Moved from: Microsoft 365...

  8. Data Mining Module for excel

    in Windows 10 Customization
    Data Mining Module for excel: I am trying to help my son with Univ assignment and he has to do PCA. It appears that he needs to have the Data Mining Module installed. He has a 64 bit system but the module wont load. Does this mean he needs SQL server?...

  9. EXCEL automate download stock prices at end of day

    in Microsoft Office and 365
    EXCEL automate download stock prices at end of day: Hi folks. anybody got suggestions on how to download end of day data for around 30 - 40 stocks (or more) using EXCEL and its Internet services. Basic data is OPEN/CLOSE/HIGH/LOW/VOLUME This can be downloaded from GOOGLE or YAHOO finance but it's a bit of a manual process...

  10. EXCEL 2019 Stock and Geograpghy Data types missing

    in Microsoft Office and 365
    EXCEL 2019 Stock and Geograpghy Data types missing: Hi folks Is this only now an Office 365 feature -- for stock quotes the Stock and Geography data types aren't available it seems in current versions of Office 2019 Any body messing around with Stock Exchange type of stuff on EXCEL --the old yahoo used to have excellent Free...