Navigator User Forums
  StockWeb
  How to clean up symbols file quickly

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   How to clean up symbols file quickly
Deb643
Member
posted 05-23-2001 08:27 AM     Click Here to See the Profile for Deb643   Click Here to Email Deb643     Edit/Delete Message
I use FN to manage 12 different individuals' investment portfolios. Each of these people own a variety of stocks as they are using money managers. I know have 354 symbols stored in the file, however I know some should be removed. Is there a quick way to compare the total symbol file to my individual client files to crosscheck which symbols need to be deleted?

Thanks for any suggestions.

Debbie Ehlmann

IP: Logged

John
Administrator
posted 05-25-2001 07:57 AM     Click Here to See the Profile for John     Edit/Delete Message
One way is to just rebuild the symbol file from scratch. Follow these steps to rebuild the symbol file.
  1. Delete (or rename) the symbol file in the Navigator program folder. The file is named 'sym2.prn'.
  2. In each entity, select Investments (Accounts in 7.5) | Security Symbols and Other Info Changes.
  3. Select OK on the first security account.
  4. With the first security on the screen, select Automatic if “Automatic” is not already diplayed in the upper right corner. This will run through the securities and stop on securities that are missing a symbol or when the symbol is not in the symbol file.
  5. Select Yes if "Enter Security Symbol?" appears and enter the appropriate symbol in the Sym,#: text box.
  6. Select Yes to add the symbol to the symbol file if the "Add New Security Symbol?" message appears.
  7. Select Next or press the page down key to go to the next security and the prompt to add the next symbol. The fast way to do all this is to press page down and then enter.
  8. Repeat steps 2 thru 7 for each entity. Each entity has its own securities but there is only one symbol file. The symbol file has a list of symbols for all your securities from all your entities. On other entities it will pause less since more symbols will already be in the symbol file.
You can view and edit the symbol file. Open your Navigator program folder in Windows Explorer. Double click on sym2.prn file. Use Notepad to open it.

[This message has been edited by David (edited 07-22-2008).]

[This message has been edited by David (edited 07-22-2008).]

IP: Logged

All times are PT (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | Home

Copyright 2010 Financial Navigator, Inc.


Ultimate Bulletin Board 5.47e