NASI

Helper Help

Importing from Fidelity's Advisor Channel Software

How do I set up the DAILY Download From Advisor Channel?

1. Open Advisor CHANNEL 6.1, and from the pull-down menu, choose Interface --> Profiler.

2. Click Add.

3. In the Profile Name window, name the profile: Helper Series Daily. Click the ">>" button.

4. Check the appropriate boxes, then click the ">> button.

5. Again, check the appropriate boxes, then click the ">> button.

6. By default, the program will download the last business day's information. If this download needs to be for a different period, check the Date Option box and select the appropriate date range. Click the ">>" button.

7. Place a checkmark in the Export Accounts box, change the Filename to cltaccts.dat, then click the Change Columns... button.

8. Using the list of fields at the bottom of this document, in order, click the field name on the left and click Add to make the field appear on the right. The fields need to be in the correct order. Click OK when finished. You will return to the previous page.

9. Now click the Balances tab. Check the Export Balances box, change the Filename to bal.dat, and then click the Change Columns... button. Using the list of fields at the bottom of this document, highlight the field name on the left and click Add to make the field appear on the right. Add each field in the correct order. Then click OK. You will return to the previous page.

10. Continue this process with the Prices tab (Filename: price.dat), Security tab (Filename: security.dat), and Transactions tab (Filename: trans.dat). NOTE: In Transactions, the Primary Sort should be Account Number and the Secondary Sort should be Transaction Date.

After completing the setup for transactions, click Finish. This will return you to the first screen. You are now ready to click Run Now, to get your files.

FIELD SETUP SPECIFICATIONS -- an asterisk (*) indicates that the field is not used, but needs to be entered as a placeholder.

Accounts
Cltaccts.dat

1. Account
2. Short name*
3. Social Security Number
4. Name 1
5. Name 2
6. Tacct*
7. Registration*
8. Account Ind*
9. Attn*
10. Address 1
11. Address 2
12. City
13. State
14. Zip
15. Country
16. Phone 1
17. Phone 2
18. Acct Indicator*
19. Address 3
20. Last Name
21. Capital Gains Option*
22. Cash Avail.*
23. Core Fund*
24. Core Fund CUSIP*
25. Core Fund Description*
26. Core Fund Floor Symbol*
27. Core Fund ID*
28. Core Fund Name*
29. Dirdiv Acct*
30. Dirdiv Acct Type*
31. Dividend Option*
32. Do Not Trade*
33. DOB*
34. EFT*

Securities
Security.dat

1. Symbol
2. Cusip
3. Description
4. Close price
5. Fund family*
6. Fund family ID*
7. Security Type
8. Exchange*
9. As of Date*
10. Name

Balances
Bal.dat

1. Account
2. As of date*
3. Networth*
4. Buying power*
5. Cash avail. to borrow*
6. Cash avail. to withdrawal*
7. Money market*
8. Outstanding calls*
9. Cash balance
10. Acct Shortname*
11. Cash Market Value*
12. Cash Settlement Date*
13. FBSI Shortname*
14. Legal Market Value*
15. Margin Balance*
16. Margin Market Value*
17. Margin Settlement Date*
18. Plan Name*
19. Plan Number*

Prices
Price.dat

1. Symbol
2. Cusip
3. Price

Positions
Position.dat
1. Account
2. Account Type
3. CUSIP
4. Symbol
5. Trade Date Qty
6. Total Shares
7. Close Price
8. 0% Shares*
9. 1% Shares*
10. 2% Shares*
11. 3% Shares*
12. Acct Code*
13. Account Indicator Code*
14. Acct Shortname*
15. As of Date*
16. Asset Class Type*
17. Cash Avail.*
18. Collected Shares*
19. Core Fund*

go to Helper Help index page