smfGetCSVFile() Documentation

Documentation for smfGetCSVFile() function

Description

Parses data from a CSV file into an EXCEL range.

Syntax

=smfGetCSVFile( URL )

Parameters

URL

= CSV file to parse data from (can also be a local file name instead of a URL).

Examples

To retrieve NASDAQ advancing issues data from Unicorn:

=smfGetCSVFile("http://unicorn.us.com/advdec/NASDAQ_advn.csv")
To retrieve a local file:

=smfGetCSVFile("C:\Users\Randy\Documents\Temp\Test3.csv")
An alternative way to grab current quotes data from Yahoo:

=smfGetCSVFile("http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f;=sl1d1t1c1ohgv&e;=.csv")
An alternative way to grab dividend data from Yahoo historical quotes:

=smfGetCSVFile("http://ichart.finance.yahoo.com/table.csv?s=MMM&g;=v&ignore;=.csv")
...more to come

Usage notes

This function returns an array of data, so it needs to be array-entered. To array-enter a formula in EXCEL, first highlight the range of cells where you would like the returned data to appear -- the number of rows and columns for the range will depend on the size of the CSV file you want parsed and how much of that CSV file you want to see. Next, enter your formula and then press Ctrl-Shift-Enter.
This function is only available in version 2.0i or later of the add-in.
...more to come