QUESTION

How do I set up a data feed from Merrill Lynch?

ANSWER

Tamarac Services often assists clients with requests to enable a particular custodian feed to PortfolioCenter or the UMP.

PortfolioCenter Data Feed

To set up the data feed in PortfolioCenter from Merrill Lynch, the Tamarac client should complete the LOA and send to Merrill Lynch.

UMP Data Feed

New Merrill Lynch Data Feed

If it is a new Merrill Lynch data feed, complete the following steps:

Is the client part of the merrill lynch Money Manager services Program? Action to take
Yes The client should send an email requesting that their accounts be added to the Merrill Lynch Envestnet Feed. Once received, forward this request along with the relevant account numbers to ENVTamaracCFR@envestnet.com
No


Required forms are located here: T:\Project Management\Custodian Process Documents\Setup Forms\LOAs\Merrill Lynch

Existing Merrill Lynch Data Feed

If it is an existing Merrill Lynch data feed, follow these steps:

  1. Complete the appropriate LOA to request that new accounts be added to the existing data feed.

  2. When the macro for the custodian is selected in Zendesk, the email will be sent to mldatafeeds@ml.com as shown below. This is an internal request and you should set yourself as the requestor.

    Sample Email

    [Subject Line]: Envestnet Tamarac Feed for {Firm Name}

    [Email Content]

    Hello Merrill Lynch team,

    Can you please add the accounts listed in the LOA, which is hyperlinked within this email, to our feed (8223 GPC INPC FEED – ENVESTNET)? These accounts belong to {Firm Name}.

    If you could please let me know when this has been completed, it would be greatly appreciated. Please note that the file is not attached but is a link within this email. Let me know if you have any questions.

    Regards,

    Your Name

  1. Once the custodian confirms that the feed has been set up and the account has been added, you should check the following day in the UMP. If the account was not linked to the correct client and it’s been labeled as an orphaned account, send an email to TAS-UMP-Configuration@trv.envestnet.com to assign the orphan account to the firm.

  2. As a final step, make sure that a Standard Interface license code has been entered in PortoflioCenter for the purposes of the UMP feed. In most cases, this should be the Standard 8 Interface, and can be shared with Schwab, Fidelity, and TDA.

Note

If full account numbers are needed, send a password-protected Excel sheet with the password provided via phone call and separate request.

APPLIES TO