|
PureBytes Links
Trading Reference Links
|
<FONT face=Arial
color=#0000ff size=2>I'm having trouble understanding you. Are you able to
write in JScript? Are you trying to download data from your office
computer via a script? Is the data in separate files by ticker name?
What do you want to do when you get the data on your home computer?
<FONT face=Arial
color=#0000ff size=2>
<FONT face=Arial
color=#0000ff size=2>Why don't you list what you want to do in a very simple
step by step fashion so an old fart like me can understand it. Then I might be
able to get you going.
<FONT face=Arial
color=#0000ff size=2>
<FONT face=Arial
color=#0000ff size=2>d
<FONT face=Arial
color=#0000ff size=2>
From: Prashanth
[mailto:prash454@xxxxxxxxxxxxxxxxx] Sent: Sunday, May 16, 2004 3:28
PMTo: amibroker@xxxxxxxxxxxxxxxSubject: Re: [amibroker]
how to? with script, download data from web
Hi dingo,
Thanks for the script. The reason I also asked
Jeff was because he also wanted to do the same thing and I thought that he may
have tried it out. But I did address it to you. The reason I couldnt give the
address is that I have to download the files from my office to my home system
and at the office I use a DSL connection hence the IP address is
temporary.
Coming to your script, I have one basic question
- Suppose I want to import data of multiple tickers, all I have to do is
create a txt file and give all the ticker names. <<FONT face="Courier New"
color=#0000ff size=1>TickerFile = "Symbols.txt" <FONT
face="Courier New" size=2>>.
Thanks for your help
Regards
Prashanth
<BLOCKQUOTE dir=ltr
>
----- Original Message -----
<DIV
>From:
dingo
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Monday, May 17, 2004 12:12
AM
Subject: RE: [amibroker] how to? with
script, download data from web
<FONT
face=Arial size=2>
<SPAN
class=734004018-16052004>The JScript below might help you. Its the one I
modded for downloading quotes from the Brite.com website.
<SPAN
class=734004018-16052004>
<SPAN
class=734004018-16052004>It uses the GETURL program.
<SPAN
class=734004018-16052004>
<SPAN
class=734004018-16052004>If you need me to write one for you give me the
exact details you want done.
<SPAN
class=734004018-16052004>
<SPAN
class=734004018-16052004>d
<SPAN
class=734004018-16052004>
<SPAN
class=734004018-16052004>---------------------------8<-------------------------------------------------------
<FONT face="Courier New" color=#0000ff
size=1>
<FONT face="Courier New" color=#0000ff
size=1>/*** AmiBroker/Win32 scripting Example****
File: Brite.js** Created: Tomasz Janeczko,
January 3rd, 2002** Modified: dingo, April 22, 2004 - Added
weekly & monthly** Purpose: Download and import quotes from
BriteFutures.com** Language: _javascript_ (Windows
Scripting Host)*****/
<FONT face="Courier New" color=#0000ff
size=1>/**************************************************************//*
Constants
*//**************************************************************/
<FONT face="Courier New" color=#0000ff
size=1>TickerFile = "Symbols.txt"
/* The
name and the path to downloader program */DownloaderPrg =
"URLGet.exe";
/*
Force download - if true causes downloading data file *//* even if it
exists on the local drive */ ForceDownloadFlag =
false;
/* URL
from where data are downloaded */
<FONT face="Courier New"
size=1>URLPart1 = "<A
href=""><FONT face="Courier New"
size=1>http://www.britefutures.com/codeword/<FONT
face="Courier New" size=1>";URLPart2 =
".csv?redir=/scripts/x_dl.asp&contract=";URLPart3 =
"&ext=ext.csv";
<FONT face="Courier New"
size=1>// weekly history URLURLWHistPart1 = "<A
href=""><FONT face="Courier New"
size=1>http://www.britefutures.com/codeword/<FONT
face="Courier New" size=1>";URLWHistPart2 =
".csv?redir=/scripts/x_dl.asp&period=w&symbol=";URLWHistPart3 =
"&ext=ext.csv"
<FONT face="Courier New"
size=1>// monthly history URLURLMHistPart1 = "<A
href=""><FONT face="Courier New"
size=1>http://www.britefutures.com/codeword/<FONT
face="Courier New" size=1>";URLMHistPart2 =
".csv?redir=/scripts/x_dl.asp&period=m&symbol=";URLMHistPart3 =
"&ext=ext.csv"
/*
extension of file name, ticker will be prepended */FileExt =
".prn";FileExt_Wkly = "_Wkly.prn";FileExt_Mthly =
"_Mthly.prn";
<FONT face="Courier New" color=#0000ff
size=1>/**************************************************************//*
Main
part
*//**************************************************************/
/*
Create AmiBroker app object */AmiBroker = new ActiveXObject(
"Broker.Application" );/* ... and file system object */FileSys = new
ActiveXObject( "Scripting.FileSystemObject" );WshShell = new
ActiveXObject( "WScript.Shell" );
/*
find out what is the path to our script */DestDir =
WScript.ScriptFullNameDestDir = DestDir.substr( 0, DestDir.length -
WScript.ScriptName.length ); //WScript.echo( DestDir
);
<FONT face="Courier New" color=#0000ff
size=1>function Download( URL, filename ){ if( !
ForceDownloadFlag && FileSys.FileExists( filename ) ) return
true;
<FONT face="Courier New" color=#0000ff
size=1> CmdLine = DownloaderPrg + " " + URL + " " +
filename;
<FONT face="Courier New" color=#0000ff
size=1> //WScript.echo( CmdLine );
<FONT face="Courier New" color=#0000ff
size=1> if( WshShell.Run( CmdLine, 0, true ) == 0 ) return
true;
<FONT face="Courier New" color=#0000ff
size=1> WScript.echo("Download of " + URL + " failed."
);
<FONT face="Courier New" color=#0000ff
size=1> return false;}
<FONT face="Courier New" color=#0000ff
size=1>function Import( filename, format_file ){
try {
AmiBroker.Import( 0, filename, DestDir + format_file
); } catch( e
) {
return false; }
<FONT face="Courier New" color=#0000ff
size=1> /* refresh ticker list and windows
*/ AmiBroker.RefreshAll();
return true;}
<FONT face="Courier New" color=#0000ff
size=1>function CheckFolder(){ if( !
FileSys.FolderExists( DestDir ) )
{ FileSys.CreateFolder(
DestDir ); }}
<FONT face="Courier New" color=#0000ff
size=1>function Main(){ bOK = true;
<FONT face="Courier New" color=#0000ff
size=1> CheckFolder();
<FONT face="Courier New" color=#0000ff
size=1> tf = FileSys.OpenTextFile( DestDir + TickerFile, 1
);
<FONT face="Courier New" color=#0000ff
size=1> while( ! tf.AtEndOfStream )
{
//------------------------------------------
// Get current data section
//------------------------------------------
ticker = tf.ReadLine(); URL =
"" + URLPart1 + ticker + URLPart2 + ticker + URLPart3 +
'"'; filename = '"' + DestDir
+ ticker + FileExt + '"';
//WScript.echo( URL );
//WScript.echo( filename );
if( Download( URL, filename )
)
{ if(
! Import( DestDir + ticker + FileExt, "brite.format" ) ) bOK =
false;
}
else
{ bOK
= false;
} if( ! bOK &&
WshShell.popup( "The download and/or import of the " + filename + " has
failed.\nThis can be because the data are not available or network
connection problem.\nDo you want to abort?" , 0, "Abort updating", 4 + 256 )
== 6 ) {
break;
}
//------------------------------------------
// Get weekly history section
//------------------------------------------
W_Ticker = ticker.substr (0,ticker.length -3);
//WScript.echo( W_Ticker
); URL ="" + URLWHistPart1 +
W_Ticker + URLWHistPart2 + W_Ticker + URLWHistPart3 +
'"'; filename = '"' + DestDir
+ W_Ticker + FileExt_Wkly +
'"'; //WScript.echo( URL
); //WScript.echo( filename
); if( Download( URL, filename
) )
{ if(
! Import( DestDir + W_Ticker + FileExt_Wkly, "briteW.format" ) ) bOK =
false;
}
else
{ bOK
= false;
} if( ! bOK &&
WshShell.popup( "The download and/or import of the " + filename + " weekly
history has failed.\nThis can be because the data are not available or
network connection problem.\nDo you want to abort?" , 0, "Abort updating", 4
+ 256 ) == 6 ) {
break;
}
//------------------------------------------
// Get monthly history section
//------------------------------------------
M_Ticker = ticker.substr (0, ticker.length -3);
//WScript.echo( M_Ticker
); URL ="" + URLMHistPart1 +
M_Ticker + URLMHistPart2 + M_Ticker + URLMHistPart3 +
'"'; filename = '"' + DestDir
+ M_Ticker + FileExt_Mthly +
'"'; //WScript.echo( URL
); //WScript.echo( filename
); if( Download( URL, filename
) )
{ if(
! Import( DestDir + M_Ticker + FileExt_Mthly, "briteM.format" ) ) bOK =
false;
}
else
{ bOK
= false;
} if( ! bOK &&
WshShell.popup( "The download and/or import of the " + filename + " monthly
history has failed.\nThis can be because the data are not available or
network connection problem.\nDo you want to abort?" , 0, "Abort updating", 4
+ 256 ) == 6 ) {
break; }
}
<FONT face="Courier New" color=#0000ff
size=1> if( bOK ) WScript.echo("Update script
finished. Your database is now up-to-date" );
else WScript.echo("Update script
finished. There were, however, some errors during
download/import");
<FONT face="Courier New" color=#0000ff
size=1>}
<FONT face="Courier New" color=#0000ff
size=1>Main();
<FONT face=Arial color=#0000ff
size=2>
From: JJ [mailto:jparent@xxxxxxxxx]
Sent: Sunday, May 16, 2004 1:21 PMTo:
amibroker@xxxxxxxxxxxxxxxSubject: [amibroker] how to? with
script, download data from web
i've read TJ's "HOWTO: Import quotes from Yahoo's site in
CSV format"found at <A
href="">http://www.amibroker.com/docs/ab302.html
. from this i canfigure out how to assign stocks to industry
groups and so on usinginfo from a text file located on a local hard
drive. i want to skipseveral steps and access a CSV file located
on the web.here's an example:<A
href="">http://www2.standardandpoors.com/spf/csv/index/500growth.csvthe
only problem i'm having is trying to figure out how in windowsscript
to call data from a web based source.if that sounds easy, then how
about accessing data from XLS filesstored on the
net?/jeffSend BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page:
<A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Send BUG REPORTS to bugs@xxxxxxxxxxxxxSend
SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page:
<A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/amibroker/
To unsubscribe from this group, send an email to:amibroker-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
|