Current location - Trademark Inquiry Complete Network - Futures platform - How to import the real-time price of one or several futures into excel and realize real-time update?
How to import the real-time price of one or several futures into excel and realize real-time update?
It is possible to make an Excel database, but it is impossible to update it automatically in real time, unless you compile a set of software yourself, save the data in Excel automatically, or buy advanced futures operation software.

The method of establishing excell database is as follows:

The first step is to log in to the mytrade trading system of Cultural Finance (you can register and download it in the futures company that uses this software).

The second step is to choose futures contracts to enter optional.

The third step is to set the header according to the data type you need. Operation method: right-click any contract in the optional page, click "Set Header", select the required data type, and confirm to save.

Step four, export the data. Right-click any contract on the self-selection page, select Other, and click "Export Data in Text Format" to save it to the location you set.

The fifth step is to import data in txt format by using the import function of excell. Some settings need to be made to align the data, and some unnecessary overlaps need to be removed (using the replacement function).

Note: I don't remember some software terms clearly, but they are roughly the same. As long as you follow this step, you can certainly make your own futures database.