Last updated: 2025-12-02
SmartInvestments - Updating Security Prices
SmartInvestments - Updating Security Prices
)
The link for this help topic is:
In this Topic ShowHide)
- Overview
- [Missing
Prices Utility](#MiniTOCBookMark3)
- [Internet
Quote Service](#MiniTOCBookMark4)
](javascript:void(0);)
Overview
Keeping security prices up to date is important for tasks such [investment
validation](/help/pro/smartinvestments/-/investment/validation), assessing [investment
performance](/help/pro/smartinvestments/-/performance/calculations) and calculating [asset
allocation](/help/pro/smartinvestments/-/asset/allocation).
Note: Organizations that
receive[ investment
data downloads](/help/pro/data/aggregation/services/-/introduction) in SmartOffice typically receive security price updates
automatically. Users in these organizations generally do not need to update
security prices using the methods described in this topic.
Prices can be downloaded electronically using the Internet Quote Service
utility, or they can be entered manually.
After updating security prices, run [investment
validation](/help/pro/smartinvestments/-/investment/validation) to ensure that client accounts and positions are up to
date.
Missing
Prices Utility
In certain cases, SmartOffice automatically notifies the user when a
security's prices require updating. The Missing Prices utility displays
when a security's price history is missing entries that are necessary
for accurate [investment
reports](/help/pro/smartinvestments/-/investment/reports) or [performance
calculations](/help/pro/smartinvestments/-/performance/calculations).
The utility can also be run manually at any time:
-
From the [Investment
Security List](/help/pro/smartinvestments/-/searching/for/investment/securities), tag one or more securities to update.
-
Select Menu > Missing Price Search.
-
Select the date range for the search, and then click the OK button to open the Prices Missing from
Price History dialog box.
-
Do one of the following:
-
Manually enter the missing prices and then click the OK button.
-
Select Menu >
Advanced Options >
Internet Quote Service
to download the missing prices using the [Internet
Quote Service](/help/pro/smartinvestments/-/updating/security/prices). Then click the OK
button.
The utility is especially useful for updating variable annuity subaccounts,
whose prices must be entered manually because they are not available through
the Internet Quote Service.
Internet
Quote Service
The Internet Quote Service utility enables the user to download current
and historical prices for securities.
Note: The Internet Quote
Service cannot be used to update securities created in the home office,
fixed-price securities or securities of a type that is not supported by
the selected price data provider. Also, security types that do not have
real symbols—Cash
and Equivalents, Direct Participation Programs, Variable Annuities, Fixed
Annuities and non-corporate Bonds—are
not processed. Such securities must be updated manually.
Price Data Providers
-
FT Interactive Data:
This is a pay-per-use service that requires a subscription with Interactive
Data. Subscribers can download prices for global equities, options,
corporate bonds, government securities, U.S. and Canadian agency securities,
global commodity/futures contracts, U.S. municipal bonds, U.S. pass-through
securities (GNMA, FNMA, FHLMC), collateralized mortgage obligations
(CMOs) and asset-backed securities. The service offers the latest,
daily and month-end prices. When using FT Interactive Data, the Internet
Quote Service matches securities based on CUSIP numbers. If the CUSIP
number is entered incorrectly on the security's [Detail
content link](/help/pro/smartinvestments/-/security/detail/content/link), incorrect prices (or no prices at all) will be downloaded.
Note: FT Interactive
Data does not provide prices for these security types: direct participation
programs, variable annuities, cash, fixed annuities.
Using the Quote Service
The Internet Quote Service is available from the following areas of
SmartInvestments:
-
[Investment
Security List (Security Master)](/help/pro/smartinvestments/-/searching/for/investment/securities)
-
[Security
Detail content link](/help/pro/smartinvestments/-/security/detail/content/link)
-
[Security
Price History content link](/help/pro/smartinvestments/-/price/history/content/link)
-
[Security
Value/Returns content link](/help/pro/smartinvestments/-/comparative/and/blended/indices)
-
To use the Internet Quote Service:
-
If viewing the Investment Security List, select one or more
securities.
-
Select Menu > Advanced Options > Internet
Quote Service.
-
When the confirmation message displays, click the Yes
button to open the Internet Quote Service Request dialog box.
-
Ensure that the securities to be updated are displayed in the
Selected Data section.
-
From the Security Provider drop-down list, select Yahoo
Quote Service (free) or FT
Interactive Data (subscription with Interactive Data required).
Note: The Yahoo! service has been
discontinued as of May 31, 2017.
-
If FT Interactive Data was selected as the provider, complete
the User Name and Password fields using the information provided by
Interactive Data.
-
Select the appropriate option from the Price Frequency drop-down
list:
Latest: Retrieves
the latest price and date.
-
Daily Historical:
Retrieves the price and date for every business day within a particular
date range. After selecting this option, specify the date range
in the From Date and Through Date fields. Alternatively, select
the Since Last Date in Price History
option to have SmartOffice determine the From Date based on the
last price recorded in the security's [price
history](/help/pro/smartinvestments/-/price/history/content/link).
-
Week-End Historical:
Retrieves the price and date for the last business day of every
week within a particular date range. After selecting this option,
specify the date range in the From Date and Through Date fields.
Alternatively, select the Since Last Date
in Price History option to have SmartOffice determine the
From Date based on the last price recorded in the security's [price
history](/help/pro/smartinvestments/-/price/history/content/link).
-
Month-End Historical:
Retrieves the price and date for the last business day of every
month within a particular date range. After selecting this option,
specify the date range in the From Date and Through Date fields.
Alternatively, select the Since Last Date
in Price History option to have SmartOffice determine the
From Date based on the last price recorded in the security's [price
history](/help/pro/smartinvestments/-/price/history/content/link).
-
Select one of the following options:
-
Non-Adjusted Close Price:
This option retrieves the stock’s price at the close of trading.
-
Adjusted Close Price:
This option retrieves the stock’s price at the close of trading,
adjusted for any distributions, splits, offerings and other factors
affecting the stock’s true value.
-
Select the appropriate options in the Choose
the Steps to Run section:
Step 1: Download
prices from the provider: This option downloads prices
from the provider. When selected by itself, this option enables
the user to preview downloaded prices before updating them in
SmartOffice.
-
Step 2: Update
the database with the prices: This option is available
only if Step 1 is selected. It bypasses the preview and immediately
updates the prices in SmartOffice.
-
Click the Request
button.
-
If the Internet Quote List dialog box displays, check
the list of downloaded prices. Then click the Update
button to update the prices in SmartOffice or click the Cancel
button to abort the process without updating prices.
Updating Prices Manually
SmartOffice has two methods that enable the user to update a security's
price manually.
From the security's [Detail
content link](/help/pro/smartinvestments/-/security/detail/content/link):
-
Enter a price in the Share Price field.
-
Enter the price date in the Date field.
-
Select Menu > Save. The price is added to the
security's [Price
History content link](/help/pro/smartinvestments/-/price/history/content/link).
From the security's [Price
History content link](/help/pro/smartinvestments/-/price/history/content/link):
-
and select New 'Price History' record.
-
Enter the date and price in the appropriate fields and then
click the OK button.
Note: When the user manually
adds a price whose date is the same as or later than that of the price/date
on the security's [Detail
content link](/help/pro/smartinvestments/-/security/detail/content/link), the price on the Detail content link is updated accordingly.
](javascript:void(0);)