### Install Nasdaq Data Link Pro (Windows) Source: https://docs.data.nasdaq.com/docs/excel-installation Instructions for downloading and installing the Nasdaq Data Link Pro executable for Windows Excel. Ensure Excel is closed before running the setup file. ```bash 1. Download the executable file here. 2. Please close Excel before installing the setup file. 3. Follow the setup instructions once the .exe file starts to run. ``` -------------------------------- ### SQL Installation & Authentication for Nasdaq Data Link Source: https://docs.data.nasdaq.com/docs/data-organization This section provides instructions on installing and authenticating for SQL access to Nasdaq Data Link. It covers the setup required to query data using SQL clients. ```sql -- Example of connecting to Nasdaq Data Link via a SQL client -- (Specific connection string and authentication method may vary by client) -- CONNECT TO 'jdbc:nasdaqdatalink://your_host:port/your_database' -- USER 'YOUR_USERNAME' PASSWORD 'YOUR_API_KEY'; ``` -------------------------------- ### Request Data with Date Collapse and Return Type (zoo) Source: https://docs.data.nasdaq.com/docs/r-installation Shows an example of requesting data with a collapsed date format ('quarterly') and specifying the return type as 'zoo'. The example also includes a limit on the number of returned data points. ```R data <- NasdaqDataLink('NSE/OIL', collapse = "quarterly", type = "zoo", limit = 3) ``` -------------------------------- ### Python - Installation and Authentication Source: https://docs.data.nasdaq.com/docs/sql-installation-authentication This section outlines the steps for installing and authenticating the Python client for Nasdaq Data Link. It typically involves setting up API keys and necessary libraries. -------------------------------- ### R Installation and Authentication for Nasdaq Data Link Source: https://docs.data.nasdaq.com/docs/getting-started This section outlines the process for installing and authenticating the Nasdaq Data Link R package. It usually involves installing the package from a repository and configuring API credentials. ```r install.packages("nasdaqdata") # Set your API key Sys.setenv(NASDAQ_DATA_LINK_API_KEY = "YOUR_API_KEY") ``` -------------------------------- ### Excel Installation and Authentication for Nasdaq Data Link Pro Source: https://docs.data.nasdaq.com/docs/sql Guides users on installing and authenticating the Nasdaq Data Link Pro add-in for Excel to access financial data. ```text 1. Download the Nasdaq Data Link Pro add-in installer from the Nasdaq Data Link website. 2. Run the installer and follow the on-screen prompts. 3. Open Microsoft Excel. 4. Navigate to the 'Nasdaq Data Link' tab on the ribbon. 5. Click 'Sign In' and enter your Nasdaq Data Link API Key. 6. You can now use the add-in functions to import data into your spreadsheets. ``` -------------------------------- ### Install and Authenticate Nasdaq Data Link R Package Source: https://docs.data.nasdaq.com/docs/r This section covers the installation and authentication process for the Nasdaq Data Link R package. It guides users on how to set up the package to access financial and economic datasets from Nasdaq. ```R install.packages("nasdaqdata") # For authentication, you would typically set an environment variable or use a configuration file. # Example using environment variable (replace with your actual API key): # Sys.setenv(NASDAQ_DATA_LINK_API_KEY = "YOUR_API_KEY") ``` -------------------------------- ### Bulk Download Response Example (JSON) Source: https://docs.data.nasdaq.com/docs/in-depth-usage-1 An example of the JSON response received when requesting a bulk download, containing file link, status, and snapshot time. ```JSON { "datatable_bulk_download": { "file": { "link": "https://duf9k3nptkna3.cloudfront.net/ZACKS/EE/ZACKS_EE_99456f7bd6584ef9c0d21f3804f27f44.zip?api_key=...", "status": "regenerating", "data_snapshot_time": "2017-04-26 14:33:02 UTC" }, "datatable": { "last_refreshed_time": "2017-10-12 09:03:36 UTC" } } } ``` -------------------------------- ### SQL Installation and Usage for Nasdaq Data Link Source: https://docs.data.nasdaq.com/docs/getting-started This section covers the installation and usage of SQL clients with Nasdaq Data Link. It explains how to connect to data sources and query tabular data using SQL. ```sql -- Example SQL query (syntax may vary based on client) SELECT * FROM nasdaq_data_link.some_table LIMIT 10; ``` -------------------------------- ### SQL Installation and Usage Source: https://docs.data.nasdaq.com/docs/excel-add-in Information on installing and using SQL clients with Nasdaq Data Link. This section covers authentication and general usage patterns for querying table data via SQL. ```SQL INSTALLATION & AUTHENTICATION SQL CLIENTS & USAGE ``` -------------------------------- ### R - Installation and Authentication Source: https://docs.data.nasdaq.com/docs/sql-installation-authentication This section details the process of installing and authenticating the R client for Nasdaq Data Link. It covers package management and API key configuration for R users. -------------------------------- ### Bulk Download Response Example (XML) Source: https://docs.data.nasdaq.com/docs/in-depth-usage-1 An example of the XML response for a bulk download request, detailing the file link, status, and data snapshot time. ```XML https://duf9k3nptkna3.cloudfront.net/ZACKS/EE/ZACKS_EE_99456f7bd6584ef9c0d21f3804f27f44.zip?api_key=... fresh 2017-10-12T21:13:54Z 2017-10-12T09:03:36Z ``` -------------------------------- ### Example XML API Response Structure Source: https://docs.data.nasdaq.com/docs/quick-start-examples-9 Provides an example of the XML output received from a Nasdaq Data Link API call. The structure includes a root element, a datatable containing data entries, and column definitions. ```xml 2005-12-31 7.832008 2006-12-31 10.121263 2007-12-31 13.140962 2008-12-31 13.508695 2009-12-31 11.061462 2010-12-31 11.444623 2011-12-31 10.420364 2012-12-31 8.109622 2013-12-31 3.423688 2014-12-31 3.442269 2015-12-31 3.404856 reportdate Date amount BigDecimal(36,14) ``` -------------------------------- ### SQL Installation and Usage Source: https://docs.data.nasdaq.com/docs/parameters-1 Guidance on setting up and using SQL clients to access Nasdaq data. This section covers the necessary steps for SQL-based data analysis. ```SQL -- Example SQL query structure SELECT column1, column2 FROM your_table_name WHERE filter_condition; ``` -------------------------------- ### Python Installation and Authentication for Nasdaq Data Link Source: https://docs.data.nasdaq.com/docs/getting-started This section details the steps required to install and authenticate the Nasdaq Data Link Python library. It typically involves installing the library via pip and setting up API keys or credentials for accessing data. ```bash pip install nasdaq-data-link ``` ```python import nasdaq_data_link # Set your API key nasdaq_data_link.api_key = "YOUR_API_KEY" ``` -------------------------------- ### R Installation and Authentication Source: https://docs.data.nasdaq.com/docs/parameters-1 Instructions for installing and authenticating the Nasdaq Data Link library for R. This enables R users to interact with Nasdaq data. ```R install.packages("nasdaqdata") ``` -------------------------------- ### R Installation & Authentication for Nasdaq Data Link Tables Source: https://docs.data.nasdaq.com/docs/data-organization This section details the installation and authentication procedures for accessing Nasdaq Data Link Tables data using the R programming language. It guides users through setting up the R environment and authenticating API calls. ```r install.packages("nasdaqdata") library(nasdaqdata) # Set your API key set_nasdaq_api_key("YOUR_API_KEY") ``` -------------------------------- ### R Installation and Authentication for Nasdaq Data Link Source: https://docs.data.nasdaq.com/docs/index This section outlines the process for installing and authenticating the Nasdaq Data Link R package. It usually involves installing the package from a repository and configuring API credentials. ```r install.packages("nasdaqdata") # Set your API key Sys.setenv(NASDAQ_DATA_LINK_API_KEY = "YOUR_API_KEY") ``` -------------------------------- ### SQL Installation and Usage for Nasdaq Data Link Source: https://docs.data.nasdaq.com/docs/index This section covers the installation and usage of SQL clients with Nasdaq Data Link. It explains how to connect to data sources and query tabular data using SQL. ```sql -- Example SQL query (syntax may vary based on client) SELECT * FROM nasdaq_data_link.some_table LIMIT 10; ``` -------------------------------- ### Constructing a Nasdaq Data Link API Call (XML) Source: https://docs.data.nasdaq.com/docs/quick-start-examples-9 Demonstrates how to build a GET request to the Nasdaq Data Link API to retrieve data from a specific table (MER/F1). It shows how to specify the output format (XML), apply filters to narrow down results (e.g., by mapcode, company number, report type), select specific columns, and include the API key for authentication. ```bash curl "https://data.nasdaq.com/api/v3/datatables/MER/F1.xml?&mapcode=-5370&compnumber=39102&reporttype=A&qopts.columns=reportdate,amount&api_key=" ``` -------------------------------- ### Install Nasdaq Data Link Python Package Source: https://docs.data.nasdaq.com/docs/python-installation Installs the Nasdaq Data Link Python package from PyPI. This package is necessary for interacting with the Nasdaq Data Link API in Python. Ensure you have pip or pip3 installed. ```Python pip install nasdaq-data-link import nasdaqdatalink ``` ```Python pip3 install nasdaq-data-link import nasdaqdatalink ``` -------------------------------- ### Install NasdaqDataLink R Package from GitHub Source: https://docs.data.nasdaq.com/docs/r-installation Installs the NasdaqDataLink R package from GitHub using the devtools package. This method is useful for installing the latest development version. ```R install.packages("devtools") library(devtools) install_github("nasdaq/data-link-r") library(NasdaqDataLink) ``` -------------------------------- ### Python Installation and Authentication for Nasdaq Data Link Source: https://docs.data.nasdaq.com/docs/index This section details the steps required to install and authenticate the Nasdaq Data Link Python library. It typically involves installing the library via pip and setting up API keys or credentials for accessing data. ```bash pip install nasdaq-data-link ``` ```python import nasdaq_data_link # Set your API key nasdaq_data_link.api_key = "YOUR_API_KEY" ``` -------------------------------- ### Python Authentication and Tables Access Source: https://docs.data.nasdaq.com/docs/api-for-real-time-or-delayed-data-1 This section details the installation and authentication process for accessing Nasdaq data tables using Python. It guides users on how to set up their environment to query and retrieve tabular data. ```Python pip install nasdaq-data-link import nasdaq_data_link # Set your credentials nasdaq_data_link.set_client_id("YOUR_CLIENT_ID") nasdaq_data_link.set_client_secret("YOUR_CLIENT_SECRET") # Example: Fetching a table table_code = "XFN/FA" # Example table code data = nasdaq_data_link.get(table_code) print(data.head()) ``` -------------------------------- ### Python Installation and Authentication for Tables Source: https://docs.data.nasdaq.com/docs/sql Provides instructions for installing the necessary Python libraries and authenticating with the Nasdaq Data Link API to access table data. ```bash pip install nasdaq-data-link import nasdaq_data_link # Set your API key as an environment variable or pass it directly # nasdaq_data_link.api_key = 'YOUR_API_KEY' # Example: Fetching data from a table # data = nasdaq_data_link.get('YOUR_DATA_SOURCE/YOUR_TABLE_NAME') # print(data.head()) ``` -------------------------------- ### Python API Installation and Authentication for Nasdaq Data Link Tables Source: https://docs.data.nasdaq.com/docs/rate-limits-1 This section details the steps required to install and authenticate the Python library for accessing Nasdaq Data Link's table data. It covers prerequisites and the authentication process to enable API calls. ```bash pip install nasdaq-data-link ``` ```python import nasdaq_data_link # Set your API key nasdaq_data_link.set_api_key('YOUR_API_KEY') ``` -------------------------------- ### Python Installation and Authentication Source: https://docs.data.nasdaq.com/docs/parameters-1 Instructions for installing and authenticating the Nasdaq Data Link library for Python. This is a prerequisite for using Python to access Nasdaq data. ```Shell pip install nasdaq-data-link ``` -------------------------------- ### R API Installation and Authentication for Nasdaq Data Link Tables Source: https://docs.data.nasdaq.com/docs/rate-limits-1 This section outlines the installation and authentication process for the R client to interact with Nasdaq Data Link's table data. It includes instructions for setting up the necessary package and API key. ```r install.packages("nasdaqdata") library(nasdaqdata) # Set your API key set_nasdaq_api_key("YOUR_API_KEY") ``` -------------------------------- ### SQL Authentication and Usage Source: https://docs.data.nasdaq.com/docs/api-for-real-time-or-delayed-data-1 This section covers the installation and authentication procedures for using SQL clients to access Nasdaq data. It explains how to connect and query data using SQL. ```SQL -- Example SQL connection string (syntax may vary based on client) -- Assuming a client that uses a connection string format like: -- "postgresql://user:password@host:port/database?sslmode=require&client_id=YOUR_CLIENT_ID&client_secret=YOUR_CLIENT_SECRET" -- Once connected, you can query tables like this: SELECT * FROM "XFN/FA" LIMIT 10; ``` -------------------------------- ### R Installation and Authentication for Nasdaq Data Link Source: https://docs.data.nasdaq.com/docs/tables-1 Instructions for installing and authenticating the Nasdaq Data Link library in R. This allows R users to access and analyze Nasdaq datasets. ```r # Install the library install.packages("NasdaqDataLink") # Set your API key library(NasdaqDataLink) NasdaqDataLink::ApiConfig$api_key <- "YOUR_API_KEY" ``` -------------------------------- ### Python Installation & Authentication for Nasdaq Data Link Tables Source: https://docs.data.nasdaq.com/docs/data-organization This section covers the installation and authentication process for using the Nasdaq Data Link Tables API with Python. It outlines the necessary steps to set up your environment and authenticate your requests to access tabular data. ```python pip install nasdaq-data-link import nasdaqdatalink # Set your API key nasdaqdatalink.Api.api_key = "YOUR_API_KEY" ``` -------------------------------- ### Python Installation and Authentication for Tables Source: https://docs.data.nasdaq.com/docs/excel-add-in Guidance on installing and authenticating Python for accessing Nasdaq Data Link tables. This enables programmatic data retrieval and analysis using Python libraries. ```Python INSTALLATION & AUTHENTICATION TABLES ``` -------------------------------- ### Python Installation and Authentication for Nasdaq Data Link Source: https://docs.data.nasdaq.com/docs/tables-1 Instructions for installing and authenticating the Nasdaq Data Link library in Python. This enables programmatic access to Nasdaq's datasets, including tables. ```python # Install the library pip install nasdaq-data-link # Set your API key import nasdaqdatalink nasdaqdatalink.ApiConfig.api_key = "YOUR_API_KEY" ``` -------------------------------- ### R Installation and Authentication for Tables Source: https://docs.data.nasdaq.com/docs/sql Details the process of installing the R package for Nasdaq Data Link and authenticating to access table-based financial data. ```r install.packages("nasdaqdata") library(nasdaqdata) # Set your API key # set_api_key("YOUR_API_KEY") # Example: Fetching data from a table # data <- get_table("YOUR_DATA_SOURCE/YOUR_TABLE_NAME") # print(head(data)) ``` -------------------------------- ### Bulk Download Response Example (CSV) Source: https://docs.data.nasdaq.com/docs/in-depth-usage-1 A sample CSV response snippet for a bulk download, showing the structure of the file link and status information. ```CSV file.link,file.status,file.data_snapshot_time,datatable.last_refreshed_time https://duf9k3nptkna3.cloudfront.net/ZACKS/EE/ZACKS_EE_99456f7bd6584ef9c0d21f3804f27f44.zip?api_key=... ``` -------------------------------- ### Install and Authenticate Nasdaq Data Link Python Package Source: https://docs.data.nasdaq.com/docs/python This section covers the installation and authentication process for the Nasdaq Data Link Python package. It is essential for accessing financial and economic datasets through the API. ```Python pip install nasdaq-data-link import nasdaq_data_link # Set your API key nasdaq_data_link.api_key = "YOUR_API_KEY" ``` -------------------------------- ### Install Trino JDBC Driver in DataGrip Source: https://docs.data.nasdaq.com/docs/sql-clients Instructions for installing the Trino JDBC driver in DataGrip. This involves downloading the driver, placing it in the DataGrip JDBC drivers directory, and configuring the driver settings within the IDE. ```Java io.trino.jdbc.TrinoDriver ``` -------------------------------- ### Excel Add-in Installation and Authentication Source: https://docs.data.nasdaq.com/docs/excel-add-in Instructions on how to install the Nasdaq Data Link Excel Add-in and authenticate your access to various data sources. This add-in facilitates quick downloading of large datasets into Excel. ```Excel INSTALLATION & AUTHENTICATION ``` -------------------------------- ### Excel Installation and Authentication for Nasdaq Data Link Pro Source: https://docs.data.nasdaq.com/docs/tables-1 Instructions for installing and authenticating the Nasdaq Data Link Pro add-in for Excel on Windows. This enables users to directly access and analyze Nasdaq data within Excel spreadsheets. ```powershell # Example of how to potentially install add-ins via command line (specifics depend on Excel/add-in) # Add-AppxPackage -Path "path/to/NasdaqDataLinkPro.appx" ``` -------------------------------- ### Install Nasdaq Data Link (Mac Excel Add-in) Source: https://docs.data.nasdaq.com/docs/excel-installation Steps to install the Nasdaq Data Link web-based add-in for Mac users in Excel. This involves searching for the add-in within Excel and logging in with an API key. ```bash 1. Open Excel and navigate to **Home** tab → **Add-ins** 2. Search "Nasdaq Data Link" and double click into the icon 1. Adjust the web browser window to fit the screen 1. Log in via the ⚙️ icon with the **API key** from your Nasdaq Data Link account profile ``` -------------------------------- ### Set NasdaqDataLink API Key Source: https://docs.data.nasdaq.com/docs/r-installation Sets the API key for the NasdaqDataLink R package. This is required for making more than 50 calls per day or accessing premium datasets. ```R NasdaqDataLink.api_key("YOURAPIKEY") ``` -------------------------------- ### Query Data for Specific Date Range using NASDAQ.TABLE Source: https://docs.data.nasdaq.com/docs/user-guide-copy This example demonstrates how to query sentiment data for Apple Inc. within a specific date range using the NASDAQ.TABLE formula. It employs both '.gte' and '.lte' operators to define the start and end dates for the query. ```Excel Formula =NASDAQ.TABLE("NDAQ/RTAT10",{"date","sentiment"},"date.gte","2012-01-01","date.lte","2022-01-01","ticker","AAPL") ``` -------------------------------- ### Filter Rows and Columns in R Source: https://docs.data.nasdaq.com/docs/r-tables Demonstrates combining row and column filtering to retrieve specific data. This example shows how to get the 'reportdate' column for a particular company ('compnumber=39102') from the 'MER/F1' table in R. ```R data <- nasdaqdatalink.datatable('MER/F1',compnumber="39102",qopts.columns="reportdate") ``` -------------------------------- ### Programmatic Bulk Download (JSON) Source: https://docs.data.nasdaq.com/docs/in-depth-usage-1 Shows how to initiate a bulk download for data in JSON format by adding `qopts.export=true` to the API call. The response provides metadata including a download link. ```HTTP https://data.nasdaq.com/api/v3/datatables/zacks/ee.json?api_key=YOURKEY&qopts.export=true&api_key=YOURAPIKEY ``` -------------------------------- ### SQL - Explain Query Plan Source: https://docs.data.nasdaq.com/docs/sql-installation-authentication This SQL command provides insights into the execution plan of a query. It helps users optimize their queries for better performance by understanding how the DataLink backend processes them. ```SQL EXPLAIN ``` -------------------------------- ### Query Multiple Columns using NASDAQ.TABLE Source: https://docs.data.nasdaq.com/docs/user-guide-copy This example shows how to query and download multiple columns from a NASDAQ table by referencing cells that contain the datatable code and column names. ```Excel Formula Referencing cells for datatable code and column names. ``` -------------------------------- ### Authenticate Nasdaq Data Link Add-in Source: https://docs.data.nasdaq.com/docs/excel-installation Guide on how to authenticate the Nasdaq Data Link add-in using an API key obtained from your Nasdaq Data Link account profile. Authentication can be done via the 'Get Data' button or the 'Settings' option. ```bash 1. Click the **Nasdaq Data Link** tab from the Excel Ribbon. 2. Click **Get Data**. 3. Log in with your API key. > 📘 > ### > NOTE: You can also input your API key through the **Settings** button. ``` -------------------------------- ### SQL Client Setup and Usage for Nasdaq Data Source: https://docs.data.nasdaq.com/docs/tables-1 Guidance on setting up SQL clients and using them to interact with Nasdaq data. This section covers the general approach to connecting and querying data via SQL interfaces. ```sql -- Example SQL query structure (specific syntax may vary by client) -- SELECT * FROM nasdaq_data_link.your_table_name WHERE some_column = 'some_value'; ``` -------------------------------- ### Query Data After Specific Date using NASDAQ.TABLE Source: https://docs.data.nasdaq.com/docs/user-guide-copy This example shows how to retrieve sentiment data for Apple Inc. after a specific date using the NASDAQ.TABLE formula. It utilizes the '.gte' operator to filter data greater than or equal to the specified date. ```Excel Formula =NASDAQ.TABLE("NDAQ/RTAT10",{"date","sentiment"},"date.gte","2012-01-01","ticker","AAPL") ``` -------------------------------- ### Query Multiple Columns with Filters using NASDAQ.TABLE Source: https://docs.data.nasdaq.com/docs/user-guide-copy This example illustrates querying multiple columns from a NASDAQ table and applying filters for a specific ticker and date. It shows how to reference cells containing the datatable code, column names, filter names, and filter values. ```Excel Formula Referencing cells for datatable code, column names, filter names, and filter values. ``` -------------------------------- ### Install NasdaqDataLink R Package from CRAN Source: https://docs.data.nasdaq.com/docs/r-installation Installs and loads the NasdaqDataLink R package from the Comprehensive R Archive Network (CRAN). This is the standard method for obtaining the package. ```R install.packages("NasdaqDataLink") library(NasdaqDataLink) ``` -------------------------------- ### SQL Client Connection Example Source: https://docs.data.nasdaq.com/docs/sql Demonstrates how to connect to the Nasdaq Data Link SQL interface using a generic SQL client. This typically involves providing connection details and an API key. ```SQL SELECT * FROM nasdaq.economic.gdp_usa LIMIT 10; -- Replace 'nasdaq.economic.gdp_usa' with the desired table name. -- Ensure your SQL client is configured with your DataLink API Key for authentication. ``` -------------------------------- ### Programmatic Bulk Download (CSV) Source: https://docs.data.nasdaq.com/docs/in-depth-usage-1 Demonstrates initiating a bulk data download in CSV format by appending `qopts.export=true` to the API request. The response includes a link to the generated file. ```HTTP https://data.nasdaq.com/api/v3/datatables/zacks/ee.csv?api_key=YOURKEY&qopts.export=true&api_key=YOURAPIKEY ``` -------------------------------- ### SQL - List Tables Source: https://docs.data.nasdaq.com/docs/sql-installation-authentication This SQL command is used to list all available tables within the Nasdaq Data Link SQL interface. It helps users discover the datasets they can query. ```SQL SHOW TABLES ``` -------------------------------- ### R Installation and Authentication for Tables Source: https://docs.data.nasdaq.com/docs/excel-add-in Instructions for setting up and authenticating R to access Nasdaq Data Link tables. This allows users to leverage R's statistical capabilities for data analysis. ```R INSTALLATION & AUTHENTICATION TABLES ```