|
PureBytes Links
Trading Reference Links
|
Graham,
The help page for FOREIGN says
Allowable data fields: "open", "close", "high", "low", "volume", "interest".
Possibly
AddColumn( Foreign("OSIBPT","Interest") ,"SOI",1);
will work??
And probably "I" instead of "interest" will also work.
--
Nigel
On Wed, 2 Apr 2003 11:04 pm, Graham wrote
:
> Thought I would answer myself, and pose a further query with another
> problem created from solving (I think) the first.
> I have imported the shares on issue for the stocks into the open interest
> data straight into the AB database, even though it references the MS
> database. I created a set of tickers just for the OI field to use as a
> foreign function in the AA etc.
> This seems to have worked ok and I can view the OI data and call it up
> directly with an explore.
> AddColumn(OI,"shares issued",1);
>
> However I am having a problem getting it through the Foreign function.
> The function works fine with the normal OHLCV, but not OI. I get a return
> of the open price all the time,. As though it does not recognise the second
> character I in OI within the foreign function.. In this case the shares on
> issue are about 180m.
>
> AddColumn( Foreign("OSIBPT","OI") ,"SOI",1);
>
> Can someone help please
>
> Cheers,
> Graham
> http://groups.msn.com/ASXShareTrading
> http://groups.msn.com/FMSAustralia
>
> -----Original Message-----
> From: Graham [mailto:gkavanagh@xxxxxxxxxxxxx]
> Sent: Wednesday, 2 April 2003 7:04 PM
> To: AB yahoo group
> Subject: [amibroker] importing shares on issue
>
> I want to include the shares on issue for companies using the OI which I do
> not use for anything. I have the MS plugin for my data and am trying to
> import to this database as I figure the AB one will not work using the
> plugin.
> I have the MS converter but cannot seem to get the text file setup
> correctly to convert the data into the MS database
> Can someone please advise me what I should be doing
> I have the text file as (following the converter help file)
>
> <ticker>,<date>,<o/i>
> AAC,4/01/2003,185012000
> AAI,4/01/2003,847581876
> AAR,4/01/2003,188239700
> AAT,4/01/2003,533795123
>
> But the converter keeps giving errors and asks me for a name ... of
> something as the rest of the message is hidden outside the small window. I
> originally just had the ticker and o/I, then added the date as felt this
> was needed as well. But stll get error message.
>
>
> Cheers,
> Graham
> http://groups.msn.com/ASXShareTrading
> http://groups.msn.com/FMSAustralia
>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Save Smiley. Help put Messenger back in the office.
http://us.click.yahoo.com/4PqtEC/anyFAA/i5gGAA/GHeqlB/TM
---------------------------------------------------------------------~->
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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|