Basic Concepts
What is the difference between a data interface and a flush iFinD database?
The data interface is a derivative of the Flush iFinD database. The data interface supports multiple programming languages (SDK interface: C#/C++, Java, MATLAB, R, VBA and Python;HTTP interface). Users can use the data interface to set conditions to obtain corresponding data according to their own data requirements (except for limited conditions, such as high-frequency data). The iFinD database is full of data and does not support direct extraction from multilingual environments for analysis. In addition, the data interface is derived from the iFinD database of Tonghuashun, and the target user groups are also different. The core target user groups of the data interface are people or institutions who have demand for financial big data and master a certain data analysis language, usually private placement. The users of the iFinD database are concentrated in large organizations for their information technology departments to meet the data needs of other departments. The most obvious difference is reflected in the price of the product.
What is the difference between free accounts, trial accounts and official accounts?
Free account refers to the purchase of ifind terminal products can use a small number of interface products; Trial accounts and official accounts extract the same amount of data, you can extract historical data for different years; Official account refers to the account with all rights opened after purchase; See the official website permission description for differences in data volume and permissions for different accounts.
What are the reasons for unsuccessful data extraction?
There are many reasons for unsuccessful data extraction. The first is to rule out the possibility of various errors. The best way is to find specific function commands and analyze them according to the Errorcode returned by the command to find specific reasons. There are several main reasons for command errors:
Misspelling of function commands, such as misspelling of upper and lower case of function names, errors in full-angle and half-angle characters, and errors in using parameter spacers;
Value the market data of non-trading days, or value the financial data of non-reporting days;
When extracting financial indicators (financial indicators with indicator numbers), the indicator number is not input as a parameter:
The input securities code and corresponding index are incorrect. For example, the input securities code is OTC fund (.OF), but the input index is open and low;
For a futures contract, the value date entered is not within the listing date;
6, command writing errors, such as:
name = 'ifind_e001'
password = 'my_password'
THS_iFinDLogin('name', 'password') - -----wrong
THS_iFinDLogin(name, password) - -----correctdata-related
Is there a limit to the maximum length of data returned by the function?
The maximum amount of data requested by an official account is limited to 2 million. For details, see the description on the super command for different functions and accounts. Some indicators are calculated in real time. For example, if too much data is extracted at a time, there may be timeout error. In this case, it is recommended to split the code or extract it in batches within the time range.
When does the flush data come in?
RoyalFlush iFinD database generally in the closing of the day within 1 to 2 hours of the market and other data warehousing, overseas market data is relatively late. Company announcements, news research papers and other data are generally stored at night. Extracting data between entries is likely to result in situations where there is sometimes data and sometimes no data.
What is the data limit for the data interface?
At present, many functions are provided in the data interface, and they are divided into two categories for statistics according to the type of function values. The data extracted by high-frequency series function, real-time quotation function, intraday snapshot function and historical quotation function are collectively referred to as quotation data; the data extracted by basic data function, date series function and data pool function are collectively referred to as basic data. The limit of market data is 150 million/week, and the limit of basic data is 5 million/week. Note: The "bar" here means an EXCEL cell.
Data interface Super command and iFind terminal interface display high-frequency one-minute k-line data Why part of the data is different
Minute k line is synthesized from snapshot, exchange netcom data source and telecom data source will also have slight differences due to inconsistent sampling time. Therefore, when using it, you need to confirm whether the client is connected to a charging site or a free site, and whether the data source obtained by the interface is charged or free.
At present, the data interface A shares, Hong Kong stocks, U.S. stocks of the day when the market can be queried?
A-share daily market data is updated at about 15:07, Hong Kong stock daily market data is updated at about 16:37, and US stock daily market data is updated at about 06:12 minutes the next day.
Before and after the restoration of the right to restore the right to the need to calculate the data according to the right not to restore, can you provide the parameters of the calculation formula?
Only the re-weighting method of dividend re-investment has the concept of re-weighting factor, because the re-weighting method of cash dividend involves addition and subtraction and multiplication and division iteration operation, while the re-investment of dividend only involves multiplication and division iteration operation.
When an ex-rights event occurs (e.g. dividend issue, rights issue), the forward and backward recovery factors of the event will be maintained on the ex-rights date. To calculate the pre-weighted (dividend reinvestment) price for a given day, multiply all the forward weighting factors from that day (excluding) to the latest date in the system, and then multiply by the unweighted price.
The weight factor in the market data is the concept of cumulative weight factor, which is the cumulative multiplication of all events before the date.
Can the interface extract stroke data?
The interface does not support pen by pen data, the user needs real-time datafeed products, historical data with database products.
Difference between interface financial report indicator parameters 'consolidated report' and 'consolidated report adjustment'
Data in periodic reports issued for the first time during the reporting period are consolidated, and data subsequently adjusted for prior periods or errors are consolidated.
How to judge the main futures contract in the interface?
The main contract is judged according to the trading volume and position. If the trading volume and position of the current main contract are not the largest, the contract with the largest trading volume will be selected as the main contract first, and the judgment will be made according to the closing trading volume and position every day; if there is no trading and position, the contract of the latest month in the market will be selected.
How do I check my trading calendar?
Query function-Date query function, date offset function can query the relevant exchange trading day data.
The ID of the generated report was found to be changed in the thematic report function, which is different from the original ID
No impact on usage. Both new and old IDs can be used continuously. Interface report data is continuously optimized and updated. If report parameters are changed, the old ID will be hidden and the new ID will be displayed instead so as not to affect the use of old users.
Procedure-related
Does the interface have a specification document or data dictionary?
No, use the Windows installation package super command tool or web version of the super command to view the generate fetch command.
What do you mean by error codes such as-201,-340, etc.?
-201 means that repeated logins do not affect the continued extraction of data and return 0 as long as the processing line;
-340 indicates a network problem, consult with your O & M colleagues whether to open an interface domain name or IP whitelist;
Other error in the super command-query function-error information query or interface official website description documents can be queried.
How to query data usage?
Query function of 'account information' or data volume in the upper left corner of super command terminal: THS_DataStatistics() query;
For free accounts, it is recommended to use 'Account Information' to view the data amount.
Does the interface support multiple devices logging in and extracting data at the same time? Is it bound to IP?
1)SDK interface is not supported. Only one device can be logged in at the same time to extract data. 8 devices can be bound to the login. If the login exceeds-9, an error will be reported. Please contact customer service to unlock it. 2)http interface support, bind 20 IP, more than IP binding can use update access token interface forced update can be re-bound.
Super Command-Tools-Environment Settings can't select C++ and C#Why?
C++ and C#do not need to repair the environment, just fill in the interface package reference path according to the interface official website example.
Click to fix MATLAB64-bit plug-in appears "module FTDIActiveX_x64.ocx" loading failure
This problem is caused by the user administrator's privileges. The solution is to open the iFinD terminal with administrator privileges and click Fix MATLAB64-bit plugin. And open MATLAB development environment with administrator privileges.
Does iFinD currently provide data interfaces under Linux?
It can support, currently SDK interface supports Windows system and Linux system, seven languages; also supports HTTP interface.
What is the current environment for data interfaces? For C#/C++, MATLAB, R, VBA, Python and other data interfaces, the official development environment must be supported. Third-party development environments such as Pycharm and Spyder of Anaconda for python language are available in many third-party development environments. Our data interface package files may not load normally due to different import methods or protocols of development environment package files. So when you encounter this kind of problem, please give feedback, and we will arrange backstage personnel to conduct test research.
Does the current data interface support mac systems and home-made systems?
Mac system and domestic system can use HTTP interface, index view and generate fetch command can use web version super command.
How to extract data?
There are graphical operation interfaces such as R, MATLAB data interface can be input through the operation interface code, select indicators directly to obtain output, you can also write functions to obtain output. For Python, C#/C++ and VBA data interfaces without GUI, data output can only be obtained through input function.
Do I need to activate a Supercommand terminal to use the data interface?
No need, you can directly enable the data interface without starting the super command, use the login account and password to log in. If the data interface file has been updated, the user will be reminded of the upgrade operation when the data interface client is opened.
Excuse me, where do you enter the Supercommand now? How do you open the super command?
Supercommand program in the data interface you downloaded extract package bin\tool supercommand.exe program, double-click to open login can be used.
After the data interface and iFinD terminal are separated, the original repair tool interface is gone. How to repair the interface used?
Currently, the data interface repair tool is located in the RepairTool.exe file under the downloaded data interface installation package bin directory to repair the corresponding interface. For detailed operation, please refer to the user manual of the corresponding language.
How to extract the latest listing or delisting codes for sectors such as 'All A Shares'
Plate Composition and Report-Plate Composition Index Composition-Plate Composition Report Extraction.
How to query the plate ID when using the thematic report function to obtain plate components?
Query method is as follows: enter Data Interface-Tools-Block ID Query page to find query tool icon and corresponding block. At this time, relevant information can be displayed in the display box on the right, in which block ID can be exported. The Chinese name or Chinese initials of the plate entered in the search box.
Refresh_token and access_token expiration rules in http interface
1)Refresh_token is valid for a long time. The expiration date of refresh_token is the same as the expiration date of the account at the time of acquisition. For example, the subsequent period of account expiration and account permission change (such as free account, trial account becoming official account, etc.) need to obtain refresh token again to update the permission; 2)The validity period of access_token is 7 days. If you don't use the get method all the time, you can use it within 7 days from the first time you get it. If you use get to get access_token once a day, the access_token obtained by using get in the first 4 days will not change, and the access_token obtained by using get in the last 3 days will change.(equivalent to resetting the validity period to 7 days); but if the account usage permission is only valid for the last 7 days, then every time you get an access_token during the last 7 days of validity, it is new (this time is equivalent to the update method).
Does the interface have concurrent request restrictions?
There are limits, QPS (query rate per second) limit of 10 for a single function (5 for EDB functions), and 20 for total accounts.
Supercommand-Date Sequence Function Extract Index Data Over 1 Year Error
Because some indicators of the interface are calculated in real time, such as excessive extraction, it is easy to timeout, so this limit prompt is made. You can split the time range to extract in batches within one year.
Language-related
Does Python support Python 3.5 and above?
can be supported. Python data interfaces previously only supported Python version 2.7, but we have done compatibility processing and now support Python version 3.5 and above.
Can the data interface provide a demo of the Java language?
At present, the data interface can support JAVA language, and the corresponding demo can be viewed in the official website case.
How does the VBA Case Data Interface work?
After opening EXCEL, click Visual Basic in "Development Tools" or press ALT+F11 directly to enter VBE(Visual Basic Edit). When using, select the module to write VBA code, click Reference under Tools menu, and check iFinDVBA module.
An example of using the VBA data interface is provided in the iFinDetcdatacubeAPI_Sample file in the iFinD installation directory.