|
Here is an introduction to how to import quotes data into QuantShare, we will explain how to use the sharing server to find the appropriate download item so you can retrieve and import data to your database. First, in order to download historical quotes, fundamental or news data, you will have to create a download item. A download item is an object that contains URLs, Scripts and Settings data, and its role is to download content from the internet, transform it, parse it, and insert it into your database. You can import CSV files, Text files, Excel files, RSS feeds or compressed files. Indeed, the download plug-in can even decompress an archive (Example: ZIP), extract all files, decide which file to process, parse the appropriate files and insert data into your database. The great thing about QuantShare is that almost anything you create with the software (we call them trading objects or trading items) can be shared. If you create a download item, which is a trading object, you can easily share it on the QuantShare server, so other traders can use it. You can also download what other members or traders have shared. At the time of writing this post, there are 69 shared download items; to get the complete list, select "Last Uploaded Objects" and then select "Download Script". Download items & List of symbols Several download items require a list of symbols. As an example, if you want to download historical end-of-day data for India stocks, and you plan to use the Yahoo Downloader, you will need to add a list of India company symbols. Some download items do not require a list of symbols and they automatically create and add the necessary ones. It is the case with items that do not need you to specify the symbol name in the URL. For example, an item that downloads historical quotes by date (You just specify a date and it downloads all symbols data for this particular date; you have not specified any symbol). Therefore, depending on the download item, we should decide whether to add a list of symbols or not. Generally, the creator of the item indicates this in the object's description. Lets us take the example of a trader who trades US stocks. In the search page of QuantShare, you can select a type of trading objects and search for a specific or a combination of keywords. In the "Type" combo-box, select "Download Script", and then perform a search for the following keywords: US Historical Quotes The first three results are: Historical Quotes for Delisted US Stocks: This item downloads historical quotes for delisted stocks (stocks that no longer trade in major exchanges or no longer trade at all) Quotemedia Historical Quotes: This item downloads historical quotes from the Quotemedia website Yahoo EOD historical quotes: This item downloads historical quotes from the Yahoo website Once you choose which download items interest you, the next step is to read the description of the items and download a list of symbols if the author of the item tells you that it is necessary to do so. The author of the object may omit to tell you that important information, in that case, you can download the item, try it, and if it does not work, then go back to the QuantShare website and search for an appropriate list of symbols. The description of the first item we have seen previously (Historical Quotes for Delisted US Stocks) tells you that the object needs the following list of symbols (US delisted symbols) to work properly. Now, if our trader is interested in the India market, he can do a search for "bse data" or "nse data" keywords to find the appropriate download item that lets him import quotes data of the Bombay Stock Exchange or the National Stock Exchange. Here are some video tutorials that you may find helpful: How to download an object from the QuantShare server How to search for a trading object How to add a list of symbols How to download quotes
|
|
