Mean Target Price Estimate 1 Week Ago - Estimates
Description
Returns the mean target price based on analyst estimates from one week ago.
Syntax
EarningsEstimates_targetPriceHistory_meanTargetPriceEstimate_weeks1Ago(ByVal Symbol)Examples
=EarningsEstimates_targetPriceHistory_meanTargetPriceEstimate_weeks1Ago("MSFT")
Update Frequency: daily
Data Type: float
Historical Data Available: No
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?
Similar Functions
- Date Most Recent Estimate Current Target 1 Week Ago=EarningsEstimates_targetPriceHistory_dateMostRecentEstimate_weeks1Ago("MSFT")
- High Target Price Estimate 1 Week Ago=EarningsEstimates_targetPriceHistory_highTargetPriceEstimate_weeks1Ago("MSFT")
- Low Target Price Estimate 1 Week Ago=EarningsEstimates_targetPriceHistory_lowTargetPriceEstimate_weeks1Ago("MSFT")
- Mean Target Price Estimate 2 Weeks Ago=EarningsEstimates_targetPriceHistory_meanTargetPriceEstimate_weeks2Ago("MSFT")
- Mean Target Price Estimate 3 Weeks Ago=EarningsEstimates_targetPriceHistory_meanTargetPriceEstimate_weeks3Ago("MSFT")
- Mean Target Price Estimate Current Target=EarningsEstimates_targetPriceHistory_meanTargetPriceEstimate_currentTarget("MSFT")