Barry
I’m
still working on this script. I have to head to work
now. Essentially the Jscript will open the .csv file
and iterate through each line parsing the line. It will pass
the symbol to the Broker.Application object and set the symbol name and Market
ID using the calls below.
I’m
writing the Jscript code now and don’t have the time to finish it this
morning. But, I thought I’d give you a heads up on what I’m
trying to do.
Sorry
for the delay.
Regards,
Dan.
p.s.
One of the AB “gems” is the ability to add VBScript or Jscript scripts
to the Tools menu and then call them. You can also execute them use
the WSH cscript approach from the command line. This offers massive
flexibility.
Barry,
Hi. I don’t know if anybody
covered this, but once you get a symbol/name mapping, I believe that the code
below should help to assign the names.
Regards,
Dan.
- Get
CSV list of symbols, symbol names and markets that you are interested
in. Strip out the ones in which you are not interested.
- Save
the file to the
- Create
a Jscript procedure with the code below.
- Add
the code to the AB Tools Menu (Tools à
Customize à Tools à New)
- Execute
the code from the tools menu.
FileName: “AssignNameAndMarket.js”
// Instantiate Broker.Application
AB =
CreateStaticObject("Broker.Application");
//Modify Names
cs =
AB.Stocks(Sym) ;
cs.FullName = SymName;
cs.MarketID = iMarketID;
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Barry Scarborough
Sent: Wednesday, November 16, 2005
11:37 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Re:
Extracting symbol name from Yahoo, how?
Hi Perry,
Thanks for the reply. Actually I am trying to do
just the opposite.
I have a bunch of symbols in my AB database that
have no names. I am
looking for a way to get the full names using the
symbols off the
Yahoo site. There are so many that it would not be
practical to do
this manually. so, I want to do this with a
program.
Cheers,
Barry
--- In amibroker@xxxxxxxxxxxxxxx,
"Perry Lentine" <lentino@xxxx>
wrote:
>
> Barry,
>
> Not sure what you are attempting to do.
But I have the full name
from yahoo
> in my database. I can extract it with
the following:
>
> Filter=1;
>
AddTextColumn(FullName(),"FullName
", 25);
> AddTextColumn(Name(),"Ticker",1.0);
> SetOption("NoDefaultColumns",1);
>
> Set range to last 1 day and explore.
>
> Hope this helps.
>
> Perry Lentine
>
> -----Original Message-----
> From: amibroker@xxxxxxxxxxxxxxx
[mailto:amibroker@xxxxxxxxxxxxxxx]
On Behalf
> Of Barry Scarborough
> Sent: Wednesday, November 16, 2005 8:14 AM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Extracting symbol name
from Yahoo, how?
>
> Given a symbol list is there a way to extract
the full name from
Yahoo using
> a script or Excel function?
>
> I would also like to get other information so
I can fill out the
information
> window but full name would do.
>
> Thanks,
> Barry
>
>
>
>
>
> ------------------------ Yahoo! Groups
Sponsor --------------------
~--> Try
> Online Currency Trading with GFT. Free 50K
Demo. Trade
> 24 Hours. Commission-Free.
> http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/GHeqlB/TM
>
-------------------------------------------------------------------
-~->
>
> Please note that this group is for discussion
between users only.
>
> To get support from AmiBroker please send an
e-mail directly to
SUPPORT {at}
> amibroker.com
>
> For other support material please check also:
> http://www.amibroker.com/support.html
>
>
> Yahoo! Groups Links
>
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For other support material please check also:
http://www.amibroker.com/support.html
SPONSORED LINKS
YAHOO! GROUPS LINKS