This is a trading item or a component that was created using QuantShare by one of our members.
This item can be downloaded and used by QuantShare Trading Software.
Trading items are of different types. There are data downloaders, trading indicators, trading systems, watchlists, composites/indices...
You can use this item and hundreds of others for free by downloading QuantShare.
Top Reasons Why You Should Use QuantShare:
Works with US and international markets (stock, forex, options, futures, ETF...)
Offers you the tools that will help you become a profitable trader
Allows you to implement any trading ideas
Exchange items and ideas with other QuantShare users
Our support team is very responsive and will answer any of your questions
We will implement any features you suggest
Very low price and much more features than the majority of other trading software
This item loads and saves a list of all US holidays. The data is retrieved from the (ice.com) website. The market closes on these US holiday dates and thus the list can be helpful if you need to conduct some analysis on the how the market behaves near these dates.
The first reported holiday is 'The New Year's Eve' and it occurred in 2001, while the last holiday is 'Christmas' and it will occur in 2012. You can adjust the start and end date of the downloader. You just need to update the item (Update in the Download Manager form), click on 'Fields' button, and then change the 'DateFrom' and 'DateTo' fields.
The data is saved into a custom database and is associated with the following symbol: ^Holidays_US. The database name is 'holidays_us'; it has three columns:
Date: The date of the holiday
IsHoliday: Always set to one
Summary: The holiday name
The website where the data is retrieved from provides the data in XLS format. Thus, the downloader will work only if you have Microsoft Excel installed on your computer.
In order to properly format and insert the data into the database, I had to create a Pre-Script item. This is mainly because the holiday date and the holiday name were not located on the same line. The script reads each parsed line and initializes a variable whenever it finds a date on a line. This variable tells the script whether the next line will contain the holiday summary or not.
You have to log in to bookmark this object What is this?
>>>> More trading objects? click here to search for trading sytems, downloaders, screens, custom drawing tools, indicators... by country, market or style.
