3 Messages
Digest #2987
Messages
Sat Mar 1, 2014 1:36 pm (PST) . Posted by:
dryogeshbhoir
I want to download n save daily volatality file in excel .
Link to download r
Eq http://www.nseindia.com/archives/nsc...T_17022014.CSV http://www.nseindia.com/archives/nsccl/volt/CMVOLT_17022014.CSV
Future http://www.nseindia.com/archives/nsc...T_17022014.csv http://www.nseindia.com/archives/nsccl/volt/FOVOLT_17022014.csv
Currency http://www.nse-india.com/archives/cd...T_17022014.csv http://www.nse-india.com/archives/cd/volt/X_VOLT_17022014.csv
We can not save it automatically .How to download n save it directly in excel .
I dont have any programming knowldge .Plz prepare a excel sheet and share it .Thanks and regards . ******************* I TRIED TO USE smfGetcsv file but i m getting only header .
Link to download r
Eq http://www.nseindia
Future http://www.nseindia
Currency http://www.nse-
We can not save it automatically .How to download n save it directly in excel .
I dont have any programming knowldge .Plz prepare a excel sheet and share it .Thanks and regards . ************
Sat Mar 1, 2014 1:36 pm (PST) . Posted by:
dryogeshbhoir
I want to download n save daily volatality file in excel .
Link to download r
Eq http://www.nseindia.com/archives/nsc...T_17022014.CSV http://www.nseindia.com/archives/nsccl/volt/CMVOLT_17022014.CSV
Future http://www.nseindia.com/archives/nsc...T_17022014.csv http://www.nseindia.com/archives/nsccl/volt/FOVOLT_17022014.csv
Currency http://www.nse-india.com/archives/cd...T_17022014.csv http://www.nse-india.com/archives/cd/volt/X_VOLT_17022014.csv
We can not save it automatically .How to download n save it directly in excel .
I dont have any programming knowldge .Plz prepare a excel sheet and share it .Thanks and regards .
I tried to use smfgetcsv function but i am getting only header of colum .
Link to download r
Eq http://www.nseindia
Future http://www.nseindia
Currency http://www.nse-
We can not save it automatically .How to download n save it directly in excel .
I dont have any programming knowldge .Plz prepare a excel sheet and share it .Thanks and regards .
I tried to use smfgetcsv function but i am getting only header of colum .
Sat Mar 1, 2014 1:46 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Downloading and saving files is not the purpose of the add-in, and is
outside the scope of this group. EXCEL probably isn't a very good tool to
do that.
In any case, the reason smfGetCSVFile() only returns the column header is
you didn't array-enter it over a range. From the documentation:
*"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."*
On Sat, Mar 1, 2014 at 1:48 PM, <dryogeshbhoir@yahoo.co.in> wrote:
>
> I want to download n save daily volatality file in excel .
>
> Link to download r
>
> Eq http://www.nseindia.com/archives/nsc...T_17022014.CSV<http://www.nseindia.com/archives/nsccl/volt/CMVOLT_17022014.CSV>
>
> Future http://www.nseindia.com/archives/nsc...T_17022014.csv<http://www.nseindia.com/archives/nsccl/volt/FOVOLT_17022014.csv>
>
> Currency http://www.nse-india.com/archives/cd...T_17022014.csv<http://www.nse-india.com/archives/cd/volt/X_VOLT_17022014.csv>
>
> We can not save it automatically .How to download n save it directly in
> excel .
> I dont have any programming knowldge .Plz prepare a excel sheet and share
> it .Thanks and regards .
> I tried to use smfgetcsv function but i am getting only header of colum .
>
outside the scope of this group. EXCEL probably isn't a very good tool to
do that.
In any case, the reason smfGetCSVFile(
you didn't array-enter it over a range. From the documentation:
*"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.
On Sat, Mar 1, 2014 at 1:48 PM, <dryogeshbhoir@
>
> I want to download n save daily volatality file in excel .
>
> Link to download r
>
> Eq http://www.nseindia
>
> Future http://www.nseindia
>
> Currency http://www.nse-
>
> We can not save it automatically .How to download n save it directly in
> excel .
> I dont have any programming knowldge .Plz prepare a excel sheet and share
> it .Thanks and regards .
> I tried to use smfgetcsv function but i am getting only header of colum .
>
Tidak ada komentar:
Posting Komentar