With Excel Connect, users can retrieve and upload various properties for funds, assets, tags, and scenarios. These GET and SET functions, along with their various applicable properties are listed in the tables below:
ASSETS | |
Alpha Theory Field | Excel Connect Property Name |
Analyst | ANALYST_EMAIL |
Annualization | ANNUALIZATION_TYPE |
Associate | ASSOCIATE_EMAIL |
Benchmark | BENCHMARK_WEIGHT |
Cost to Borrow | COST_TO_BORROW |
Earnings Date | EARNINGS DATE |
Fixed Asset Name | FIXED_ASSET_NAME |
Fixed Avg. Daily Volume (000) | FIXED_ADV |
Fixed Beta | FIXED_BETA |
Fixed Conversion Ratio | FIXED_CONV_RATIO |
Fixed Delta | FIXED_DELTA |
Fixed Dividend Amount/Year | FIXED_DIV_AMT |
Fixed EPS | FIXED_EPS |
Fixed FX (USD/Local) | FIXED_FX_RATE |
Fixed Price (Previous) | FIXED_PRICE_PREV |
Fixed Price (Today) | FIXED_PRICE |
Fixed Price Multiplier | FIXED_PRICE_MULTIPLIER |
Fixed Shares Multiplier | FIXED_SHARES_MULTIPLIER |
Fixed Shares Outstanding (M) | FIXED_SHARES_OUTSTANDING |
Fixed Volatility | FIXED_VOLATILITY |
Force Min. Long Position Size | MIN_LONG_INV_FORCE |
Force Min. Short Position Size | MIN_SHORT_INV_FORCE |
Force OPS to CPS? | FIXED_OPS_TO_CPS |
Long Ownership Limit | OWNERSHIP_LIMIT_LONG |
Long PWR Adjust | PWR_ADJUSTMENT_LONG |
Maximum Long Position Size | MAX_LONG_INV |
Maximum Short Position Size | MAX_SHORT_INV |
Minimum Long Position Size | MIN_LONG_INV |
Minimum Long Return | MIN_RETURN_LONG |
Minimum Short Position Size | MIN_SHORT_INV |
Minimum Short Return | MIN_RETURN_SHORT |
Preferred Long Return | PREF_RET_LONG |
Preferred Short Return | PREF_RET_SHORT |
Reinvest Rate | REINVESTMENT_RATE |
Short Ownership Limit | OWNERSHIP_LIMIT_SHORT |
Short PWR Adjust | PWR_ADJUSTMENT_SHORT |
Trader | TRADER_EMAIL |
ASSETS (GET ONLY) | |
Alpha Theory Field | Excel Connect Property Name |
Asset Name | TICKER_DESC |
Average Daily Volume | ADV |
Beta | BETA |
Raw Beta | RAW_BETA |
Confidence* | CONFIDENCE |
Current Shares | SHARES |
Daily Volume | VOLUME_DAY |
Delta | DELTA |
Dividend | DIV |
Dividend Yield | YIELD |
EPS | EPS |
Fx Rate | FX_RATE |
Price (Previous Close) | LOCAL_PRICE |
SEDOL | SEDOL |
Shares Outstanding | SHARES_OUTSTANDING |
Ticker | AT_TICKER |
Unit Cost | UNIT_COST |
Volatility | VOLATILITY |
* This shows the stored confidence, which is directly selected from the drop-down for confidence as opposed to the dynamically calculated value
CUSTOM FIELDS (GET ONLY) | |
Alpha Theory Field | Excel Connect Property Name |
Custom Field Type | VALUE_TYPE |
Custom Field Options | CUSTOM_OPTIONS |
Custom Field Precision | PRECISION |
Custom Field Summary Type | SUMMARY_TYPE |
Custom Field Value | VALUE |
Custom Field Rationale | RATIONALE |
SCENARIOS | |
Alpha Theory Field | Excel Connect Property Name |
Calculate Price Target? | CALC_PT_FLAG |
Estimate | ESTIMATE |
Estimate Date | ESTIMATE_DATE_RANGE |
Multiple | MULTIPLE |
Net Debt (M) | NET_DEBT |
Occurrence | OCCURRENCE_DATE |
Price Targets | PRICE_TARGET |
Probabilities | PROBABILITY |
Rationale | RATIONALE |
Shares Out (M) | SHARES_OUT |
Valuation Method | METHOD_TYPE |
Scenario Updated Date | SCENARIO_TIMESTAMP; MODIFIED |
TAG EXPOSURES | |
Alpha Theory Field | Excel Connect Property Name |
Force Minimum Position Size (Long) | TAG_MIN_LONG_INV_FORCE |
Force Minimum Position Size (Short) | TAG_MIN_SHORT_INV_FORCE |
Force OPS to CPS | TAG_OPS_TO_CPS |
Max Gross (%) | MAX_GROSS_EXP |
Max Net (%) | MAX_NET_EXP |
Maximum Position Size (Long) | TAG_MAX_LONG_INV |
Maximum Position Size (Short) | TAG_MAX_SHORT_INV |
Min Gross (%) | MIN_GROSS_EXP |
Min Gross Long (%) |
MIN_GROSS_EXP_L
|
Minimum Position Size (Long) | TAG_MIN_LONG_INV |
Minimum Position Size (Short) | TAG_MIN_SHORT_INV |
Minimum Return (Long) | TAG_MIN_RETURN_LONG |
Minimum Return (Short) | TAG_MIN_RETURN_SHORT |
Preferred Return (Long) | TAG_PREF_RETURN_LONG |
Preferred Return (Short) | TAG_PREF_RETURN_SHORT |
PWR Adjustment (Long) | TAG_ER_LONG |
PWR Adjustment (Short) | TAG_ER_SHORT |
FUND | |
Alpha Theory Field | Excel Connect Property Name |
Administrator 1 | ADMIN_1 |
Administrator 2 | ADMIN_2 |
Administrator 3 | ADMIN_3 |
Administrator 4 | ADMIN_4 |
Administrator 5 | ADMIN_5 |
Administrator 6 | ADMIN_6 |
Administrator 7 | ADMIN_7 |
Administrator 8 | ADMIN_8 |
Compliance 1 | COMPLIANCE_1 |
Compliance 2 | COMPLIANCE_2 |
Compliance 3 | COMPLIANCE_3 |
Long Ownership Limit | OWNERSHIP_LIMIT_LONG |
Manager | PORTFOLIO_MGR |
Max Drawdown Long | MAX_LONG_DRAWDOWN |
Max Drawdown Method | MAX_DRAWDOWN_DOWNSIDE_TYPE |
Max Drawdown Short | MAX_SHORT_DRAWDOWN |
Maximum Gross Exposure | MAX_GROSS_EXP |
Maximum Long Position Size | MAX_LONG_INV |
Maximum Net Exposure | MAX_NET_EXP |
Maximum Short Position Size | MAX_SHORT_INV |
Minimum Gross Exposure | MIN_GROSS_EXP |
Minimum Liquidity Long | MIN_VOL |
Minimum Liquidity Short | MIN_VOL_SHORT |
Minimum Long Position Size | MIN_LONG_INV |
Minimum Long Return | MIN_RETURN_LONG |
Minimum Short Position Size | MIN_SHORT_INV |
Minimum Short Return | MIN_RETURN_SHORT |
Preferred Liquidity Long | PREF_VOL |
Preferred Liquidity Short | PREF_VOL_SHORT |
Preferred Long Return | PREF_RET_LONG |
Preferred Short Return | PREF_RET_SHORT |
Short Ownership Limit | OWNERSHIP_LIMIT_SHORT |
Size (M) | FUND_VALUE |
Trader | FUND_TRADER |
Comments
0 comments
Please sign in to leave a comment.