|
PureBytes Links
Trading Reference Links
|
Glad to hear you found it!
While I wish I hadn't convinced myself that users would recognise that
if the filenames were within quotes then the formula was also probably
within the quotes, with the confusing number of archives already
submitted over the past couple of years dealing with assigning ASX
stocks to AB sectors and industries, I'm loath to issue yet another
with such a small change.
Look at it this way - you're now further along the path to becoming
Excel educated, and now know the difference between a formula and a
huge, funny looking text string :^)
Regards,
Mark
» -----Original Message-----
» From: gerard_carey [mailto:gerard_carey@xxxxxxxxxxx]
» Sent: Wednesday, 19 March 2003 11:55 PM
» To: amibroker@xxxxxxxxxxxxxxx
» Subject: [amibroker] Re: Attn: MARK ALLEN......ASX GICS set up
»
»
» EUREKA !!!!!
» The dipstick finally got it!
»
» It was the Inverted commas enclosing the (C) formula.
» I am not Excel educated enough to reconise that the contents of the
» D4 cell (and the others below) should have changed during the
» copy/paste proceedures.
»
» In a fit of pique I have since removed every inverted comma
» from the
» ReadMe file, coloured all file name and formulas, and saved
» the file
» as a Word document.
» May I respectfully suggest that something similar be done to your
» file. I may not be the only dipstick to venture along this
» narrow and
» less trodden road.
»
» Thank you Mark for your patience and perserverance.
» My thanks also to Graham and Nick for their contributions.
»
» Regards
» Gerard
»
»
»
» --- In amibroker@xxxxxxxxxxxxxxx, "Mark Allen" <mpa@xxxx> wrote:
» > The same symptom occurs when the csv file contains commas
» in company
» > names. Have you made absolutely sure that there are no
» commas in any
» > of the names?
» >
» > Regards,
» >
» > Mark
» >
» >
» >
» > » -----Original Message-----
» > » From: gerard_carey [mailto:gerard_carey@x...]
» > » Sent: Wednesday, 19 March 2003 4:20 PM
» > » To: amibroker@xxxxxxxxxxxxxxx
» > » Subject: [amibroker] Re: Attn: MARK ALLEN......ASX GICS set up
» > »
» > »
» > » Thanks Mark
» > » I'll take an A for effort but a Z (that's a ZED) for execution.
» > » I can also see the effort you have put in and I appreciate
» that.
» > »
» > » When I attempt to run the script step 12,I get a Windows
» > » Script Host
» > » dialog box as follows:
» > »
» > » Script: C:AB-aus\ASX-GICS_Industries_Setup.js
» > » Line: 33
» > » Char: 1
» > » Error: Overflow
» > » Code: 800A006
» > » Source: Microsoft Jscript runtime error
» > »
» > » Regards
» > » Gerard
» > »
» > »
» > » --- In amibroker@xxxxxxxxxxxxxxx, "Mark Allen" <mpa@xxxx>
» wrote:
» > » > Gerard,
» > » >
» > » > I know what you mean - sometimes there are just so many
» details
» to
» > » > deal with it all becomes something of a blur. I'm sorry to
» hear
» > » you've
» > » > given up in frustration, I was hoping I had gotten it down
» to as
» > » clean
» > » > and simple a process as possible.
» > » >
» > » > Can you provide any information on what feedback you get from
» > » > AmiBroker when you finally run the script (step 12) after
» > » doing all
» > » > the preparations?
» > » >
» > » > Regards,
» > » >
» > » > Mark
» > » >
» > » >
» > » > » -----Original Message-----
» > » > » From: gerard_carey [mailto:gerard_carey@x...]
» > » > » Sent: Wednesday, 19 March 2003 11:18 AM
» > » > » To: amibroker@xxxxxxxxxxxxxxx
» > » > » Subject: [amibroker] Re: Attn: MARK ALLEN......ASX GICS
» set up
» > » > »
» > » > »
» > » > » Thanks Graham
» > » > » I have tried that to no avail. At the stage where I
» can't see
» > » the
» > » > » wood for the trees. So I'll take a break to clear the
» mind.
» > » > » Regds
» > » > » Gerard
» > » > »
» > » > » --- In amibroker@xxxxxxxxxxxxxxx, "Graham"
» <gkavanagh@xxxx>
» > » wrote:
» > » > » > I am not certain what the problem is with the sector
» > » > » update you are
» > » > » doing.
» > » > » > But as a suggestion I have found that I need to
» remove the
» > » commas
» > » > » and full
» > » > » > stops from the list of symbols/names. It is one of
» these but
» > » from
» > » > » memory I
» > » > » > cannot remember if it should be the commas or full
» stops,
» > » but I
» > » > » always
» > » > » > remove both for good measure and saves trying to
» remember.
» > » > » >
» > » > » > Cheers,
» > » > » > Graham
» > » > » > http://groups.msn.com/ASXShareTrading
» > » > » > http://groups.msn.com/FMSAustralia
» > » > » >
» > » > » > -----Original Message-----
» > » > » > From: gerard_carey [mailto:gerard_carey@x...]
» > » > » > Sent: Wednesday, 19 March 2003 8:52 AM
» > » > » > To: amibroker@xxxxxxxxxxxxxxx
» > » > » > Subject: [amibroker] Re: Attn: MARK ALLEN......ASX
» GICS set
» > » up
» > » > » >
» > » > » > Thanks Mark
» > » > » >
» > » > » > Unfortunately, after another day of trying, I am
» unable to
» > » effect
» > » > » the
» > » > » > correct installation. Giving up...again, for the time
» > » > » being...again.
» > » > » >
» > » > » > Regards
» > » > » > Gerard
» > » > » >
» > » > » >
» > » > » > --- In amibroker@xxxxxxxxxxxxxxx, "Mark Allen"
» <mpa@xxxx>
» > » wrote:
» > » > » > > Gerard,
» > » > » > >
» > » > » > > Yes, you interpreted the instructions correctly.
» After
» > » > » performing
» > » > » > the
» > » > » > > calculation, we need to replace the formula with
» it's
» > » > » own results.
» > » > » > > This is what copying and pasting the range '"in
» place"
» > » > » using "Paste
» > » > » > > Special/Values" function (Edit Menu)' does.
» > » > » > >
» > » > » > > As for why it failed, I cannot really guess from the
» > » information
» > » > » > > provided. Make sure you start afresh each time you
» attempt
» > » the
» > » > » > change,
» > » > » > > and read the instructions freshly each time (it's
» easy
» > » > » to assume a
» > » > » > > step has been taken that may have been missed). A
» couple
» > » of
» > » what
» > » > » > > appear minor details can make all the difference
» (eg,
» > » > » making sure
» > » > » > > AmiBroker is not running when changing
» broker.industry and
» > » > » > > broker.sector files).
» > » > » > >
» > » > » > > Regards,
» > » > » > >
» > » > » > > Mark
» > » > » > >
» > » > » > >
» > » > » > >
» > » > » > > > -----Original Message-----
» > » > » > > > From: gerard_carey [mailto:gerard_carey@x...]
» > » > » > > > Sent: Monday, 17 March 2003 11:15 PM
» > » > » > > > To: amibroker@xxxxxxxxxxxxxxx
» > » > » > > > Subject: [amibroker] Attn: MARK ALLEN......ASX
» GICS set
» > » up
» > » > » > > >
» > » > » > > >
» > » > » > > > Mark
» > » > » > > > I am attempting to set up GICS structure as per
» your
» > » > » files but
» > » > » am
» > » > » > > > stumped at Proceedure No 5.
» > » > » > > >
» > » > » > > > 5. Copy/Paste column from D4 to LAST ROW "in
» place"
» > » > » using "Paste
» > » > » > > > Special/Values" function (Edit Menu).
» > » > » > > >
» > » > » > > > Proceedure 4 copy/pastes the formula (C) down
» from D4 to
» > » last
» > » > » used
» > » > » > > > row. Does 5 ask that we do this again using the
» > » different,
» > » > » stated
» > » > » > > > method? Although this seemed somewhat strange I
» did this
» > » then
» > » > » > > > completed the remaining proceedures but was
» unable to
» > » > » successfully
» > » > » > > > complete the set up.
» > » > » > > > What am I missing?
» > » > » > > > Your assistance would be much appreciated.
» > » > » > > >
» > » > » > > > Regards
» > » > » > > > Gerard
» > » > » >
» > » > » >
» > » > » >
» > » > » > Send BUG REPORTS to bugs@xxxx
» > » > » > Send SUGGESTIONS to suggest@xxxx
» > » > » > -----------------------------------------
» > » > » > Post AmiQuote-related messages ONLY to: a
» > » miquote@xxxxxxxxxxxxxxx
» > » > » > (Web page: http://groups.yahoo.com
» /group/amiquote/messages/)
» > » > » > --------------------------------------------
» > » > » > Check group FAQ at:
» > » > » > http://groups.yahoo.com/group/amib
» roker/files/groupfaq.html
» > » > » >
» > » > » > Your use of Yahoo! Groups is subject to
» > » > » http://docs.yahoo.com/info/terms/
» > » > »
» > » > »
» > » > » ------------------------ Yahoo! Groups Sponsor
» > » > » ---------------------~-->
» > » > » Your own Online Store Selling our Overstock.
» > » > » http://us.click.yahoo.com/rZll0B/4ftFAA/46VHAA/GHeqlB/TM
» > » > » ------------------------------------
» ------------------------
» > » > » ---------~->
» > » > »
» > » > » Send BUG REPORTS to bugs@xxxx
» > » > » Send SUGGESTIONS to suggest@xxxx
» > » > » -----------------------------------------
» > » > » Post AmiQuote-related messages ONLY to: ami
» > » quote@xxxxxxxxxxxxxxx
» > » > » (Web page: http://groups.yahoo.com/g
» roup/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
» > » ---------------------~-->
» > » Your own Online Store Selling our Overstock.
» > » http://us.click.yahoo.com/rZll0B/4ftFAA/46VHAA/GHeqlB/TM
» > » ------------------------------------------------------------
» > » ---------~->
» > »
» > » Send BUG REPORTS to bugs@xxxx
» > » Send SUGGESTIONS to suggest@xxxx
» > » -----------------------------------------
» > » Post AmiQuote-related messages ONLY to: ami
» quote@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
» ---------------------~-->
» Your own Online Store Selling our Overstock.
» http://us.click.yahoo.com/rZll0B/4ftFAA/46VHAA/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/
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Your own Online Store Selling our Overstock.
http://us.click.yahoo.com/rZll0B/4ftFAA/46VHAA/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/
|