Windows 10: EXCEL 2019 Stock and Geograpghy Data types missing

Discus and support EXCEL 2019 Stock and Geograpghy Data types missing in Microsoft Office and 365 to solve the problem; 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... Discussion in 'Microsoft Office and 365' started by jimbo45, May 5, 2020.

  1. 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, May 5, 2020
    #1
  2. 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, May 23, 2020
    #2
  3. jimbo45 Win User
    EXCEL 2019 Stock and Geograpghy Data types missing

    Hi there
    @ignatzatsonic

    Basically just the basics for EOD (End of Day) Historical data prices -- OPEN, CLOSE, HIGH, LOW, VOLUME

    Indices -- E.G FTSE 100 (London), US NASDAQ, S&P 500, S&P30, Sectors e,g Gas/Oil. utilities etc etc.

    The Stock Connector addin is still available but I remember the stock and geographic data types from EXCEL 2016 -- maybe that was only a trial --I think now it's only available in Office/365 now.

    Fortunately get data from web still works but the old nice api's that Yahoo used to have are finished and I'm not signing up to anything "Googley" to use the api in Google docs !!!!

    For Day trading I already use a "Level 1" real time service -- the excel stuff is really for "Homework" / later analysis e.g "Technical Analysis" in "Trader speak".

    Cheers
    jimbo
     
    jimbo45, May 23, 2020
    #3
  4. EXCEL 2019 Stock and Geograpghy Data types missing

    EXCEL 2019 Stock and Geograpghy Data types missing

    I don't day trade, but I need closing prices for several dozen items every day and have for decades.

    I've always tried to track and record this stuff through Excel--dating back at least as far as Excel 2007.

    My experience has been that none of the so-called sources work more than a year or two. Then something will go haywire---a change in Excel, a change in behind-the-scenes coding at a website, an unexplained failure of a previously good ticker symbol, etc, etc.

    Maybe 3 years ago, I just quit fighting trying to get this done in any semi-automated way......out of frustration.

    Here's what I do instead:

    I set up a portfolio of my 30 or 40 desired tickers at bigcharts.marketwatch.com. The default columns are for last, change, percentage change, high, low, volume, and time. All I really care about is the closing price, but I look at it during market hours off and on.

    It takes about 2 hours after the close for the prices of mutual funds to arrive. Stocks and indexes are at most 15 minutes delayed.

    Two hours or so after the close, I use my mouse to swipe over all the tickers and columns and do a copy/paste into cell A1 of the "Pricing" tab in my Portfolio Tracking Excel file. Tuesday's copy/paste will overwrite Monday prices, etc.

    The other tabs in my Excel file contain formulas that correspond to certain cells in this Pricing tab. For instance, cell B3 of the Pricing tab is ALWAYS the SP 500 close.........so I have a formula "=prices!b3" for anywhere else in the other tabs that needs the closing value for that day's SP 500.

    If I want to track some new ticker, I add it to my portfolio at Bigcharts and make the appropriate change in my formulas.

    The only drawback is that it takes 30 seconds a day.

    On the plus side, it has been foolproof---Bigcharts is consistent, reliable, always up, and the tickers don't fail.

    I'd be interested in anything you know of that's better for my purposes. I've been down a lot of rabbit holes----but they've all eventually failed. Thus I'm willing to spend the 30 seconds.
     
    ignatzatsonic, May 23, 2020
    #4
Thema:

EXCEL 2019 Stock and Geograpghy Data types missing

Loading...
  1. EXCEL 2019 Stock and Geograpghy Data types missing - Similar Threads - EXCEL 2019 Stock

  2. data missing

    in Windows 10 Network and Sharing
    data missing: Hi, I was using an application when suddenly all the data from my desktop went missing. All the files and folders. I have done extensive searching but its not showing. Only shortcuts are visible after clicking on which it says 'file must have been moved or renamed.' Can...
  3. Data Supplied of Wrong type

    in Windows 10 Network and Sharing
    Data Supplied of Wrong type: I've been researching for weeks regarding this problem. I have a Samsung Galaxy S8+ and have tried with various USB2.0 and 3.0 and firewire cables to copy documents and photos from both internal and external storage to Windows 10 laptops. Every other version of Windows...
  4. Converting Excel Data to Powershell Script

    in Windows 10 Network and Sharing
    Converting Excel Data to Powershell Script: How would I go about converting Excel Data to Powershell Script? https://answers.microsoft.com/en-us/windows/forum/all/converting-excel-data-to-powershell-script/5c4fc5ae-3d65-4f9e-aef3-f6daad5910de"
  5. Missing data

    in Windows 10 Network and Sharing
    Missing data: just had a microsoft update and everything is gone. Also my pc did not recognize my user name and password. what happened https://answers.microsoft.com/en-us/windows/forum/all/missing-data/9e4ff4e8-50f0-4295-a359-a6ee5269ff4c"
  6. Text, inking, and typing data.

    in AntiVirus, Firewalls and System Security
    Text, inking, and typing data.: Does Text, inking, and typing data send screenshot to server or store data before sending ??? https://answers.microsoft.com/en-us/windows/forum/all/text-inking-and-typing-data/a7713b35-750b-4f22-9e8c-36f6aaa2fc4f"
  7. Use Power Pivot data in excel

    in Windows 10 Installation and Upgrade
    Use Power Pivot data in excel: Install Office 365 on my computer and I want to use Power Pivot data, I think I install an add-on but I'm not sure if it works in excel for external data control so I do not have to repeatedly copy the data. Someone knows how I can make use of this function that will help...
  8. BUG? : Excel forgets the Data Types of Table Columns in Data Model

    in Windows 10 Installation and Upgrade
    BUG? : Excel forgets the Data Types of Table Columns in Data Model: Microsoft Office 365, Version 1809 (Build 10827.20181 Click-to-Run) on Windows 10 Pro, 64-bit, Version 1803, OS Build 17134.345 I have a workbook with three tables in the Data Model, drawn from three tables on separate sheets in the workbook. Whenever I close and re-open...
  9. Excel Using control to copy data

    in Microsoft Office and 365
    Excel Using control to copy data: Hi ,,I want to copy =e7,=e9,=e11,, you know what I mean, select a cell, press Ctrl and select down a part of a column, but each cell says =e7,=e8,=e9,=e10,,,what I want is =e7,=e9,=e11,=e13,,can someone tell me how please instead of me having to type in each cell. 120274
  10. New Data Types in Excel for Office 365

    in Windows 10 News
    New Data Types in Excel for Office 365: Every day, millions of Office 365 subscribers rely on Excel to perform complex tasks with intelligent tools like Insights and advanced data transformation. This month, we rolled out several updates, which harnesses the power of the Microsoft Cloud, to make Excel even more...