Ozgrid, Experts in Microsoft Excel Spreadsheets Software Search, Categories and Specials Similar Products
AnalyzerXL | Bulk Quotes Excel | DownloaderXL | Real Time Quotes Excel
Predictor Excel | Back-testing Excel | Clusterizer Excel | Portfolio Excel
Options Excel | Neuro Excel Package | Visual Options Analyzer | TraderXl
Forecaster Excel | Neuro Intelligence
Build Automated Trading Models In Excel

Download Historical Stock Data, Index & Mutual Fund

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

Historical End-of-day Data for Futures, Commodity Futures, & Indexes From PiFin

Buy Today (below) and send us your order ID and claim over $70.00 worth of FREE software

Bulk Quotes Excel Is Only Sold as  part of the Trader Excel Package Special.

of Bulk Quotes Excel | Visit Developers Site For More Like This

Bulk Quotes Excel, part of Trader Excel Package , downloads free historical stock, index and mutual fund data from Yahoo! Finance for major worldwide exchanges, and free historical end-of-day data for financial futures, commodity futures, and indexes from PiFin . The software is also designed to handle easily downloads and updates for tens or hundreds of tickers simultaneously. Bulk Quotes Excel is designed as an Excel add-in, giving you great flexibility and allowing you immediately to apply technical analysis to downloaded data. You can even have your own macros applied instantly to all your tickers

Bulk Quotes Excel Details

Bulk Quotes Excel makes it easy to generate bar, candlestick, or line charts instantly from downloaded data. It also lets you export your data to world known formats, such as ASCII, MetaStock and others. Also, you can display downloaded data in side-by-side rows or columns, or choose another display format from the pre-defined templates.

Bulk Quotes Excel comes with a bunch of templates that can ease your work and automate routines. Here is a list of templates, shipped with the latest version of Bulk Quotes Excel:

Column-by-column template. Downloads historical data into adjacent columns of one spreadsheet.

Column-by-column template. Downloads historical data into adjacent columns of one spreadsheet.

Row-by-row template. Downloads historical data into adjacent rows of one spreadsheet.

Row-by-row template. Downloads historical data into adjacent rows of one spreadsheet.

Summary template. Creates summary worksheet, containing the latest values from all worksheets.

Summary template. Creates summary worksheet, containing the latest values from all worksheets.

Major world indexes template. Downloads historical data for major world indexes, creates historical charts and summary worksheet.

Major world indexes template. Downloads historical data for major world indexes, creates historical charts and summary worksheet.

Export data template. Downloads historical data and exports it in ASCII format (Metastock, CSV, Quicken and other formats are available) into specified folder.

Export data template. Downloads historical data and exports it in ASCII format (Metastock, CSV, Quicken and other formats are available) into specified folder.

BulkQuotesXL Toolbar.

BulkQuotesXL Toolbar.

BulkQuotesXL Settings spreadsheet - this is used to setup and control data downloading. Enter tickers into the Tickers column and then select Download/Refresh Data.

BulkQuotesXL Settings spreadsheet. It is used to setup and control data downloading.

Resulting spreadsheet - contains BulkQuotesXL downloaded data, a calculated technical analysis function and several charts.

Resulting spreadsheet. BulkQuotesXL downloaded data, then calculated technical analysis function and built charts.

Key features summary:

PiFin provides free historical end-of-day data for financial futures, commodity futures, and indices.

Data Specifications

Data SourcePiFin
Data UsageFree for AnalyzerXL and TraderXL Pro users
First DateTypically no earlier than 1973
Data TypesFutures and Commodities
Fields: FuturesOpen, High, Low, Close, Volume, Open Interest
Fields: IndicesOpen, High, Low, Close, Volume
Available PeriodicityDaily
ContractsContinuous: Roll on expiration
VolumeUsed from all contracts
Open InterestUsed from all contracts

Currencies

NameTickerExchangeFirst Date
Australian DollarADIMM1987-01-13
Brazil RealBRIMM1995-11-08
British PoundBPIMM1975-10-20
Canadian DollarCDIMM1974-01-02
EuroEUFINEX1998-09-04
Euro-YenEYIMM1996-03-06
Japanese YenJYIMM1973-01-02
Mexican PessoMPIMM1995-04-25
Swiss FrancSFIMM1973-01-02

Dairy

NameTickerExchangeFirst Date
ButterDBCME1996-09-12
MilkDACME1996-01-12

Exotics

NameTickerExchangeFirst Date
CanolaRSWCE1980-01-02
CocoaCCCBT1973-01-02
CoffeeKCCSCE1979-11-26
Cotton No 2CTNYCE1980-01-02
LumberLBCME1978-07-24
SugarSBCSCE1973-01-02

Financial

NameTickerExchangeFirst Date
1-Month LiborEMIMM1990-04-05
3-Month Euro-DollarEDIMM1981-12-09
90-Day T-BillsTBIMM1976-01-20
Euribor 3 monthsFEILIFFE1998-12-08
F-Funds 30 DayFFCBT1988-10-03
US 10-Year NotesTYCBT1982-05-03
US 2-Year NotesTUCBT1990-06-22
US 5-Year NotesFVCBT1988-05-20
US T BondsUSCBT1977-08-22

Fuels

NameTickerExchangeFirst Date
Heat Oil NO 2HONYMEX1980-01-02
Light Crude OilCLNYMEX1983-03-30
Natural GasNGNYMEX1990-04-03
Unleaded GasHUNYMEX1984-12-03

Grains

NameTickerExchangeFirst Date
CornCCBT1973-01-02
OatsOCBT1973-01-02
Rough RiceRRCBT1981-04-10
Soy MealSMCBT1973-01-02
Soybean OilBOCBT1973-01-02
SoybeansSCBT1973-01-02
WheatWCBT1973-01-02
WheatKWKBT1980-01-02
White WheatNWMGE1984-09-10

Indices

NameTickerExchangeFirst Date
Bank Index.BKX-1993-02-12
CBOE Market Volatility Index.VIX-1995-05-08
CRB IndexCRNYFE1986-06-12
Dow Jones Composite Average Index.DJANYSE1995-01-03
Dow Jones Industrial Average IndexDJCBT1997-10-06
Dow Jones Transport Average Index.DJTNYSE1990-01-02
Dow Jones Utility Average Index.DJUNYSE1990-01-02
Eurotop 100FEULIFFE1998-05-20
FTSE IndexFFILIFFE1984-05-03
Municipal Bond IndexMBCBT1985-06-11
Nasdaq 100NDCME1996-04-10
Nasdaq E-miniNQCME1999-06-22
Nasdaq Market Volatility Index.VXN-2001-01-25
Natural Gas Index.XNG-1994-03-17
Nikkei 225.NKXQNYSE1995-08-04
NYSE CompositeYXNYFE1982-05-06
Oil Index.XOI-1984-10-25
Oil Service Index.OSX-1997-02-20
Russell 2000RLCME1993-02-05
S&P 500SPCME1982-09-17
S&P E-MiniESCME1997-09-09
S&P MidCapMDCME1992-03-12
US Dollar IndexDXFINEX1985-11-20

Livestock

NameTickerExchangeFirst Date
Feeder CattleFCCME1978-07-24
Frozen BellyPBCME1973-01-02
Lean HogsLHCME1973-01-02
Live CattleLCCME1980-01-02

Metals

NameTickerExchangeFirst Date
AluminumALCOMEX1983-12-08
CopperHGCOMEX1988-07-29
Gold 100 OzGCCOMEX1979-11-26
PalladiumPANYMEX1980-01-02
PlatinumPLNYMEX1973-01-02
Silver 5000SICOMEX1973-01-02

of Bulk Quotes Excel which is Only Sold as part of the Trader Excel Package Special. Visit Developers Site For More Like This

 


Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

SPECIALS!
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates