Sandbox mock ISINs

To enable testing of different scenarios on the client side, we offer a range of ISINs, which are programmed to behave in a predefined way in our Sandbox environment.

The following lists give you an overview of these ISINs and their expected behaviour, including the order & execution webhooks.

Price simulations

The ISINs listed here are designed to execute successfully in the Sandbox.

Please note that for the ISINs listed here, the tax withholding is randomly assigned and may be 0.

To test the taxation, use the ISINs from the section Taxation simulations below.

The ISINs have the following behaviour and bid/offer prices:

ISIN	Bid price	Offer price	Mock behaviour
`IE00BKBF6H24`	7.51	6.23	Successful execution
`IE00B3XXRP09`	113.03	115.05	Successful execution
`DE0005933931`	81.77	85.22	Successful execution
`IE00BK5BCH80`	13.20	11.24	Successful execution
`IE00BM8QRZ79`	38.45	41.25	Successful execution
`IE00BYZK4552`	11.10	9.96	Successful execution
`FR0010790980`	90.11	93.55	Successful execution
`FR0010524777`	38.35	38.96	Successful execution
`LU2194447293`	14.56	14.74	Successful execution
`IE00BGBN6P67`	70.07	72.09	Successful execution
`IE00BGL86Z12`	6.26	6.30	Successful execution
`LU0779800910`	14.31	14.44	Successful execution
`IE00BJ0KDR00`	108.08	108.43	Successful execution
`LU0533033667`	472.50	481.10	Successful execution
`IE00BM67HK77`	43.88	44.23	Successful execution
`IE00BM67HL84`	22.02	44.23	Successful execution
`LU1291109616`	17.02	17.28	Successful execution
`IE00BM67HM91`	43.50	43.26	Successful execution
`IE00B95PGT31`	random	random	Successful execution
`IE00B5M1WJ87`	100.00	100.00	Successful execution with up to 5 partial executions. Number of executions dependent on order amount: < €101 = 1 execution, < €201 = 2 executions, ... > €401 = 5 executions
All active ISINs in Sandbox not otherwise specified in this section (e.g., `IE0032077012`)	100.00	100.00	Successful execution

Order & execution webhooks

Success flow ISINs have the following expected order and execution webhooks:

ORDER.NEW
ORDER.PROCESSING
EXECUTION.FILLED
ORDER.FILLED
EXECUTION.SETTLED

In the Upvest Sandbox environment, order executions are settled immediately, i.e. not on T+2.

Cancellation simulations

The ISINs listed here are designed to mock different cancellation flows.

These ISINs have the following behaviour:

ISIN	Mock behaviour
`IE00BYVJRQ85`, `LU0446734526`, `DE000A0F5UG3`, `E000YU9K6K2`, `LU1215452928`, `LU1834984798`	Upvest cancels an order immediately after `PROCESSING` state.
`LU1215451524`, `IE00BWT3KJ20`, `IE00BWT3KN65`	Upvest cancels an order in the `PROCESSING` state, however, not immediately.

Limit & stop order simulation

If you want to test limit and stop orders, you can use the following ISIN with prices oscillating every hour between 200.00 and 300.00.

Please note that for the ISINs listed here, the tax withholding is randomly assigned and may be 0.

To test the taxation, use the ISINs from the section Taxation simulations below.

ISIN	Mock behaviour
`E0005140008`, `IE00B9F5YL18`, `IE00B945VV12`	Successful execution with prices moving sine-like every hour in the pattern: 250.00 (hh:00), 300.00 (hh:15), 250.00 (hh:30), 200.00 (hh:45)
`IE00B0M62Y33`	Behaves in the same way as `DE0005140008`, however, attempt to cancel the order in `PROCESSING` state will always get rejected. (Useful for `ORDER_CANCELLATION` webhook testing)

Order & execution webhooks

Orders are being cancelled in the PROCESSING state:

ORDER.NEW
ORDER.PROCESSING
ORDER.CANCELLED

Upvest will soon offer more transparency on cancellation reasons via webhooks. We will also document these changes in this section.

Taxation simulations

We provide some ISINs to test the tax withholding for sell orders.

Tax simulations only apply to German equities.

ISIN	Mock behaviour
`IE00BKBF6H24`	Gross: 0.11928 with the following taxes: - Capital gains: 0.02982 - Solidarity surcharge: 0.0016401 - Church tax: 0.0023856
`IE00BK5BCH80`	Gross: 0.10395 with the following taxes: - Capital gains: 0.0259875 - Solidarity surcharge: 0.0014293125 - Church tax: 0.002079
`IE00BYZK4552`	Gross: 0.07189 with the following taxes: - Capital gains: 0.0179725 - Solidarity surcharge: 0.0009884875 - Church tax: 0.0014378

Portfolio orders with mutual funds

Unlike the instant execution of ETFs, mutual funds are only executed once a day. You can test the delayed execution behaviour between ETFs and mutual funds by creating a portfolio allocation with any ETF instrument and one or both of the mutual funds listed here:

IE00B42W4L06 - Vanguard Global Small-Cap Index Fund EUR Acc
IE00B18GC888 - Vanguard Global Bond Index Fund EUR Hedged Acc

Learn more about how to enable portfolio investments here.

For the execution of portfolio orders, Upvest uses the block order functionality. To enable fast implementation and testing, we typically configure a block order execution every 15 minutes from Monday to Friday between 8am and 8pm. However, the execution time can be changed if you have other preferences.

Example

Assuming a portfolio order with a single ETF and a single mutual fund is placed at 8am on a trading day, the expected behaviour for orders and executions is as follows (learn more about the lifecycle of portfolio orders here):

All individual orders (ETF and mutual fund) are created immediately (Order.NEW)
The ETF is processed and executed at 8.15am (Order.PROCESSING followed by EXECUTION.FILLED and immediate EXECUTION.SETTLED)
The mutual fund is processed and executed 18 minutes later at 8:33am (Order.PROCESSING followed by EXECUTION.FILLEDand immediate EXECUTION.SETTLED)