Hi, I thought a more specific heading would draw attention. I have a group/ watchlist of a number of tickers. In properties of each ticker "Use Only Local database" is set to YES, instead of the Default NO. As a result, the MS plugin used to set up this database is unable to seamlessly update from the native MS database.
Grateful if someone will point me/ provide me with an AFL that change the above mentioned property for all symbols at one go, rahter than me having to do it individually. thanks, 2009/12/30 furinkazaan <[email protected]> > Thanks Rakesh, > This is what I'd normally do. except that > my MS db comes with unfriendly obtuse idiotic and frustrating 8 digit > numeric tickers - so classification of data into groups, sectors, indiex > constituents and other watchlists becomes impossible. The "organise > assignments" option only reads tickers and not full names. So it cant be > used to organise DB post creation. > > the only option is to create the data segregations WHILE creating the > database. So I set up a database using the MS plugin. Before adding ms > directories, i create watchlists and groups and use MS IMPORTER to sort the > symbols. > After this, I add the MS directories (MASTER file). So now the database > should update directly with having to IMPORT data over and over, each day. > Problem is, because of this circuitous method, the properties of all > symbols is set to - Use local databse=YES - instead of the default NO. > If i can get the AFL that will change this property to NO, across all > symbols in database, the MS plugin will ensure seamless updation, into a > database that is now classified satisfactorily. > > will appreciate any help. Best wishes for the year ahead. > regards, > eswar > > > 2009/12/30 Rakesh Sahgal <[email protected]> > > >> >> Hello >> >> You do not need to use the MS data importer if you have configured your DB >> for use with the MS plug-in that is provided with AB. >> >> Simply choose the MS data plug-in as your data source when setting up the >> AB database and then add the MS data directories and you are good to go. >> >> Rakesh >> >> >> On Wed, Dec 30, 2009 at 10:15 AM, furinkazaan <[email protected]>wrote: >> >>> >>> >>> Hi, I created an AB database from a Metastock database using the >>> Metastock Importer. When using the MS Importer, i import data into groups >>> and watchlists that I create (different from the folders in the original MS >>> database). I then change the AB database settings to use the MS Plugin. Now >>> I find that daily updates to the MS database are not reflected in the AB >>> database. >>> >>> Any idea what I am doing wrong? Thanks in advance >>> >>> 2009/12/18 furinkazaan <[email protected]> >>> >>> I'm trying to get that classification from the vendor. In the meanwhile >>>> can I know if it is possible to create a AB database from a MS database, >>>> first using the Metastock importer, and then maintain it daily using the MS >>>> plugin? >>>> >>>> 2009/12/15 Robert Chevallier <[email protected]> >>>> >>>>> >>>>> >>>>> If you can put up a spreadsheet/csv with stock, market, sector, group >>>>> data, you can easily import this information with file import (and a >>>>> specific file format), and voila! all your stocks will be properly >>>>> organized. >>>>> >>>>> NB: I suppose you should be able to write in AFL a simple script to >>>>> export this info as defined in the MS db to a csv. >>>>> >>>>> 2009/12/14 furinkazaan <[email protected]> >>>>> >>>>>> >>>>>> >>>>>> Hi everybody, >>>>>> Old issue - new angle. >>>>>> >>>>>> Is it possible to first "create" a AB database from a MS database >>>>>> using the "Metastock Importer", and having created it to satisfaction, >>>>>> change the database settings to use the MS plugin to update it seamlesly? >>>>>> >>>>>> The reason I ask is The MS database is configured into folders (each >>>>>> with a Master/ Emaster file) that classify different market segments, >>>>>> indices etc, separately. This is a good structure to have. And when this >>>>>> database is read on Equis Metastock, I can actually browse the folder and >>>>>> get into that market segement I want. >>>>>> >>>>>> But when I use MS plugin to CREATE a AB database, all the tickers get >>>>>> clubbed under one market/ group. The seperation offered in the original >>>>>> MS >>>>>> database is lost. I then have to use the "organise Assignments" tool to >>>>>> separate this into groups and watchlists. >>>>>> >>>>>> And when the original MS database comes with non standard 8-digit >>>>>> numbers as ticker symbols, using the "organise assignment" tool is >>>>>> impossible, because this tool only reads tickers and not full names. >>>>>> >>>>>> "...so you see I have come to doubt, all that I once held as >>>>>> true......." Paul Simon >>>>>> >>>>>> thanks in advance for any help to get me out of this vicious cycle. >>>>>> >>>>>> 2009/2/17 edwol53 <[email protected]> >>>>>> >>>>>>> Thankyou to all that suggested remedies. >>>>>>> >>>>>>> In the end I deleted the database in the AB directory C:\Program >>>>>>> Files\AmiBroker\MSData, then recreated the database (same name and >>>>>>> destination) with MS plugin and all is working as it should (or as I >>>>>>> expect it to). >>>>>>> >>>>>>> I am not sure as to that being the correct and how that affects AB >>>>>>> in how it stores its information, but I could not find any tool or >>>>>>> procedure to remove the database. >>>>>>> >>>>>>> It seems that data MS Import & MS plugin - may have been the issue. >>>>>>> >>>>>>> Cheers >>>>>>> Still learning >>>>>>> Ed >>>>>>> >>>>>>> >>>>>>> --- In [email protected] <amibroker%40yahoogroups.com>, "CS" >>>>>>> <ces...@...> wrote: >>>>>>> > >>>>>>> > What program are you using to do the daily update of the MetaStock >>>>>>> files? >>>>>>> > >>>>>>> > The Quotetracker files should be in separate folders from the MS >>>>>>> files. >>>>>>> > Deleting them should have no effect on the MS files. >>>>>>> > >>>>>>> > The MS plugin supplies the data directly to AB from the MS data >>>>>>> files. >>>>>>> > No need to put data in AB data folders. >>>>>>> > >>>>>>> > For diagnostics, I suggest that you contact Equis support and get >>>>>>> a copy (free) of Downloader. >>>>>>> > It can look at (TEST function) the data files and see if they are >>>>>>> correct. >>>>>>> > >>>>>>> > -CS >>>>>>> > >>>>>>> > ----- Original Message ----- >>>>>>> > From: edwol53 >>>>>>> > To: [email protected] <amibroker%40yahoogroups.com> >>>>>>> > Sent: Monday, February 16, 2009 3:05 AM >>>>>>> > Subject: [amibroker] Re: Metastock external EOD update & >>>>>>> Amibroker MS plugin >>>>>>> > >>>>>>> > >>>>>>> > CS thanks for the response. >>>>>>> > >>>>>>> > The answer is yes to your questions below. >>>>>>> > >>>>>>> > Each MS directory has a Master & Emaster & are accessed by both >>>>>>> > Metastock & Tradestation on this machine (done so for many >>>>>>> years), >>>>>>> > it would not have "Imported Metsatock Data" manually otherwise, >>>>>>> and >>>>>>> > the paths are correct. >>>>>>> > >>>>>>> > as for the MS Plugin I have the Configure Paths to Metastock >>>>>>> folders >>>>>>> > set for all the folders I use for both MS and TS. >>>>>>> > >>>>>>> > Your comment about a "crippled" MS Plugin intrigues me even >>>>>>> though >>>>>>> > the ticker names are there in the data AB has stored/or reads. >>>>>>> > >>>>>>> > I will try to set up another machine tomorrow - and see if that >>>>>>> > presents a different result. >>>>>>> > >>>>>>> > BTW how do I delete the MSData data base only and leave the >>>>>>> > QuoteTracker database in tact - is it a manual process by >>>>>>> deleting >>>>>>> > the folder eg C:\Program Files\AmiBroker\MSData? Is there any >>>>>>> effect >>>>>>> > on the registry settings? >>>>>>> > >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >>> >>> >> >> > >
