How to Upload Scenarios with Excel Connect

SCENARIO_ENTRY_FULL

1. Open an Excel workbook that contains a model used to calculate price targets.

2. Once in Excel, navigate to the spreadsheet that contains the scenarios and their research.

3. Next, click on the Alpha Theory tab at the top of the Excel application.

   • NOTE: If the Alpha Theory tab is not visible, ensure that the add-in is installed by following the instructions here.

4. Once on the Alpha Theory ribbon, sign-in by clicking on the Sign-In icon at the far-left edge of the ribbon.

   • NOTE: For an overview of the Alpha Theory ribbon, refer to this article.

5. After signing-in, the first step is to designate your desired asset with the correct ticker name. You can use the asset’s Alpha Theory ticker or you can find all active asset tickers using the function =SHOW_ASSETS_TABLE(“Fund Name”).

6. Now that the Ticker Name has been obtained, the scenarios can be uploaded to Alpha Theory. On the Excel tab, locate the following pieces of information for the scenario upload:

   • Ticker Name

     • Note: You can find all your Alpha Theory tickers using the function =SHOW_ASSETS_TABLE(“Fund Name”) 

   • Scenario Name

   • Price Target
     • Only required if calcPriceTargetFlag set to "FALSE"

   • Probability

   • OPTIONAL: Occurrence Date

     • Alpha Theory assumes a 1-year occurrence date if nothing entered.

   • OPTIONAL: Rationale

   • Valuation Method

     • For Example, "Price/Earnings", "EV/EBITDA", etc.

     • Only required if calcPriceTargetFlag set to "TRUE"

   • Estimate

     • Only required if calcPriceTargetFlag set to "TRUE"

   • Multiple

     • Only required if calcPriceTargetFlag set to "TRUE"

   • Estimate Date

     • In the format of "CYXX" or "FYXX" ("XX" represents the spots for year values - "FY20")

     • CY = current year; FY = future year

     • Only required if calcPriceTargetFlag set to "TRUE"

   • OPTIONAL: Shares Outstanding (Millions)

   • OPTIONAL: Net Debt (Millions)

   • Calculate Price Target Flag
     • Specifies whether or not to calculate the price target with PT_BUILDER fields, or use the direct input Price Target.
     • Default is FALSE
   • Fund Name
     • The Fund Name designation in your Alpha Theory platform.
     • NOTE: This is only required for use with restricted funds 

7. Once all of the necessary fields have been identified, enter the SCENARIO_ENTRY_FULL function for each applicable scenario for the asset. When entering the function, reference the cells containing the information located earlier: =SCENARIO_ENTRY_FULL( tickerName cell, scenarioName cell, priceTarget cell, probability cell, occurrenceDate cell, rationale cell, valuationMethod cell, estimate cell, multiple cell, estimateDate cell, sharesOutstandingMillion cell, netDebtMillion cell, calcPriceTargetFlag cell, fundName cell).

   • With Cell references: =SCENARIO_ENTRY_FULL(A1, C3, D3, E3, F3, G3, H3, I3, J3, K3, L3, M3, N3)

   • With explicit formula entries: =SCENARIO_ENTRY_FULL("AAPL", “Risk”, 51, .3, 10/10/2020, “This is the rationale”, "Price/Earnings", 5.5, 10, "FY21", 1000, -2000, "TRUE", "Test Fund")

8. Once the formula has been set for each scenario, navigate back to the Alpha Theory ribbon, and click the “Upload Data” button. This will send the scenario data to Alpha Theory.

9. To confirm, log into Alpha Theory, and verify that the scenario data is updated for the applicable asset. 

PT_BUILDER

1. Open an Excel workbook that contains a model used to calculate price targets.

2. Once in Excel, navigate to the spreadsheet that contains the scenarios and their research.

3. Next, click on the Alpha Theory tab at the top of the Excel application.

   • NOTE: If the Alpha Theory tab is not visible, ensure that the add-in is installed by following the instructions here.

4. Once on the Alpha Theory ribbon, sign-in by clicking on the Sign-In icon at the far-left edge of the ribbon.

   • NOTE: For an overview of the Alpha Theory ribbon, refer to this article.

5. After signing-in, the first step is to designate your desired asset with the correct ticker name. You can use the asset’s Alpha Theory ticker or you can find all active asset tickers using the function =SHOW_ASSETS_TABLE(“Fund Name”).

6. Now that the Ticker Name has been obtained, the scenarios can be uploaded to Alpha Theory. On the Excel tab, locate the following pieces of information for the scenario upload:

   • Ticker Name

     • NOTE: You can find all your Alpha Theory tickers using the function =SHOW_ASSETS_TABLE(“Fund Name”) 

   • Scenario Name

   • Probability

   • OPTIONAL: Occurrence Date

     • Alpha Theory assumes a 1-year occurrence date if nothing entered.

   • Valuation Method

     • For Example, "Price/Earnings", "EV/EBITDA", etc.

   • Estimate

   • Multiple

   • Estimate Date

     • In the format of "CYXX" or "FYXX" ("XX" represents the spots for year values - "FY20")

     • CY = current year; FY = future year

   • OPTIONAL: Shares Outstanding (Millions)

   • OPTIONAL: Net Debt (Millions)

   • OPTIONAL: Rationale

   • Fund Name
     • The Fund Name designation in your Alpha Theory platform.
     • NOTE: This is only required for use with restricted funds

7. Once all of the necessary fields have been identified, enter the PT_BUILDER function for each applicable scenario for the asset. When entering the function, reference the cells containing the information located earlier: =PT_BUILDER( tickerName cell, scenarioName cell, probability cell, occurrenceDate cell, valuationMethod cell, estimate cell, multiple cell, estimateDate cell, sharesOutstandingMillion cell, netDebtMillion cell, Rationale cell, fundName cell).

   • With Cell references: =PT_BUILDER(A1, C3, D3, E3, F3, G3, H3, I3, J3, K3, L3)

   • With explicit formula entries: =SCENARIO_ENTRY("AAPL", “Risk”, .3, 10/10/2020, "Price/Earnings", 5.5, 10, "FY21", 1000, -2000, “This is the rationale”, "Test Fund")

8. Once the formula has been set for each scenario, navigate back to the Alpha Theory ribbon, and click the “Upload Data” button. This will send the scenario data to Alpha Theory.

9. To confirm, log into Alpha Theory, and verify that the scenario data is updated for the applicable asset.

SCENARIO_ENTRY 

1. Open an Excel workbook that contains a model used to calculate price targets.

2. Once in Excel, navigate to the spreadsheet that contains the scenarios with their probabilities and price targets.

3. Next, click on the Alpha Theory tab at the top of the Excel application.

   • NOTE: If the Alpha Theory tab is not visible, ensure that the add-in is installed by following the instructions here.

4. Once on the Alpha Theory ribbon, sign-in by clicking on the Sign-In icon at the far-left edge of the ribbon.

   • NOTE: For an overview of the Alpha Theory ribbon, refer to this article.

5. After signing-in, the first step is to designate your desired asset with the correct ticker name. You can use the asset’s Alpha Theory ticker or you can find all active asset tickers using the function =SHOW_ASSETS_TABLE(“Fund Name”)

6. Now that the Ticker Name has been obtained, the scenarios can be uploaded to Alpha Theory. On the Excel tab, locate the following pieces of information for the scenario upload:

   • Ticker Name

     • NOTE: You can find all your Alpha Theory tickers using the function =SHOW_ASSETS_TABLE(“Fund Name”) 

   • Scenario Name

   • Price Target

   • Probability

   • OPTIONAL: Occurrence Date

     • Alpha Theory assumes a 1-year occurrence date if nothing entered.

   • OPTIONAL: Rationale

   • Fund Name 
     • The Fund Name designation in your Alpha Theory platform.
     • NOTE: This is only required for use with restricted funds

7. Once all of the necessary fields have been identified, enter the SCENARIO_ENTRY function for each applicable scenario for the asset. When entering the function, reference the cells containing the information located earlier: =SCENARIO_ENTRY( tickerName cell, ScenarioName cell, PriceTarget cell, Probability cell, OccurrenceDate cell, Rationale cell, fundName cell).

   • With cell references: =SCENARIO_ENTRY(A1, C3, D3, E3, F3, G3)

   • With explicit formula entries: =SCENARIO_ENTRY("AAPL", “Risk”, 45.64, .3, 10/10/2020, “This is the rationale”, "Test Fund")

8. Once the formula has been set for each scenario, navigate back to the Alpha Theory ribbon, and click the “Upload Data” button. This will send the scenario data to Alpha Theory.

9. To confirm, log into Alpha Theory, and verify that the scenario data is updated for the applicable asset.