Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

Have no real experience with this API. However data can be gotten in JSON or CSV format. A quick test using their samples shows for CSV:

image description

which is a simple Text Import into Calc.

If you are looking for more automation (for example updates every x minutes) you will probably need to use the JSON format:

{
    "Meta Data": {
        "1. Information": "Batch Stock Market Quotes",
        "2. Notes": "IEX Real-Time Price provided for free by IEX (https://iextrading.com/developer/).",
        "3. Time Zone": "US/Eastern"
    },
    "Stock Quotes": [
        {
            "1. symbol": "MSFT",
            "2. price": "100.1500",
            "3. volume": "65641398",
            "4. timestamp": "2018-06-15 16:43:56"
        },
        {
            "1. symbol": "FB",
            "2. price": "195.8100",
            "3. volume": "21828955",
            "4. timestamp": "2018-06-15 16:30:08"
        },
        {
            "1. symbol": "AAPL",
            "2. price": "189.0700",
            "3. volume": "61564949",
            "4. timestamp": "2018-06-15 16:33:26"
        }
    ]
}

Unfortunately in order to use this you will need to write code (python most likely) specific to your needs which will extract the data, move it to a spreadsheet and update it at intervals. The product itself is documented with samples. The interface to LO depends upon your approach - simple (CSV) or complex with added features (JSON).