> For the complete documentation index, see [llms.txt](https://kb.bevica.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.bevica.com/documentation/guides/item-market-valuations/goedhuis_waddesdon_market_prices.md).

# Goedhuis Waddesdon Market Prices

Import Goedhuis Waddesdon market prices into item market valuations.

Bevica lets you retrieve Goedhuis Waddesdon (GW) Market prices for your items that have an LWIN attached.

{% hint style="info" %}
Bevica Market Values is a separate extension. Please contact your system administrator or your TVT contact if you would like further information or would like to install Bevica Market Values.
{% endhint %}

### Prerequisites

* Licenced by GW to access online data via API.
* Items linked to a Liv-ex LWIN7. See [Liv-ex LWIN](/documentation/guides/item-market-valuations/liv-ex_lwin.md).
* Bevica Essentials extension installed.
* Bevica Market Values extension installed.
* Ability to manage items.

### Setup

Some initial setup is required to establish the details to access the GW API service.

Choose the ![Search (Tell me) icon](https://2932934759-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfUgpGDVvyqBWVvwVIy9a%2Fuploads%2Fgit-blob-d08791d5454211f4ad6c103dcb698478e14f0cc7%2FtBDDCFHO83j3Srxuy90G2_s46CR8r1IOsA.png?alt=media) icon, enter **Item Market Values Setup**, and then choose the related link. Populate the following fields.

| Field        | Note                                                                                 |
| ------------ | ------------------------------------------------------------------------------------ |
| GW End Point | The API endpoint for LWIN price requests: <https://api.liv-ex.com/data/v2/priceData> |
| GWx Key      | Enter your key provided by Liv-ex                                                    |

### Market Prices

GW Market Prices can be retrieved and stored in Bevica, then used within the software. See [Item Market Valuation.](/documentation/guides/item-market-valuations.md)

**To retrieve market prices**

There are two ways you can retrieve market prices for an item.

{% stepper %}
{% step %}

### Step 1

**Manually for a single item**

Navigate to an Item Card/List record that has a LWIN attached. Search for the **Get Goedhuis Waddesdon Prices** routine. Selecting this will update just that item's details.
{% endstep %}

{% step %}

### Step 2

**Manually for all items**

Navigate to **Item Market Values Setup** page, Actions, **Get Goedhuis Waddesdon Prices Data** routine ribbon. This routine can be run without filters, and it will update prices for all items that have an LWIN attached.
{% endstep %}

{% step %}

### Step 3

**Creating a Job Queue Entry to run the routine automatically**

Create a Job Queue Entry that is set to run **Report 74500 Get Liv-ex Prices** periodically.

See also [Use Job Queues to Schedule Tasks](https://docs.microsoft.com/en-gb/dynamics365/business-central/admin-job-queues-schedule-tasks).
{% endstep %}
{% endstepper %}

{% hint style="info" %}
Bevica only supports GBP Liv-ex prices.
{% endhint %}

As well as storing the data received from Liv-ex in the **LWIN Price Data** page, the information is copied to the **Item Market Valuation** page where a price history can build up. See [Item Market Valuation](/documentation/guides/item-market-valuations.md) for more information.

### Liv-ex Integration Setup 'Price Type'

The **Price Type** field in Item Market Values Setup lets you decide which market price(s) you want to retrieve from Liv-ex. Select the codes you want from the list below and populate them in the Price Type field. e.g., if you want to retrieve marketPrice, midPrice, and lastTrade enter: **"A","D","F"**.

| Price Type       | Code |
| ---------------- | ---- |
| marketPrice      | "A"  |
| bestBid          | "B"  |
| bestOffer        | "C"  |
| midPrice         | "D"  |
| auctionPrice     | "E"  |
| lastTrade        | "F"  |
| offexPrice       | "G"  |
| averageListPrice | "H"  |
| averageListPrice | "I"  |
| yourlastList     | "J"  |
| yourlastOffex    | "K"  |
| lastAuction      | "L"  |
| exChateau        | "M"  |
| exNegociant      | "N"  |
| exLondon         | "O"  |

It is common for some Price types to return zero price; this will create an Item Market Value line with a blank Valuation.

Your Liv-ex licence may not include all Price Types; in this case, no records will be returned by Liv-ex.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://kb.bevica.com/documentation/guides/item-market-valuations/goedhuis_waddesdon_market_prices.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.