> 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/liv-ex-market-prices.md).
# Liv-ex Market Prices
Retrieve Liv-ex market prices into Bevica and store them as valuations.
Bevica lets you retrieve Liv-ex Market prices for your items that have an LWIN attached.
Liv-ex is the global marketplace for the wine trade with 530+ trusted merchant members and over £80m of live opportunities across 16,000 different products.
{% hint style="info" %}
Bevica Market Values is a separate extension. Please contact your system administrator or your TVision contact if you would like further information or would like to install Bevica Market Values.
{% endhint %}
### **Prerequisites**
* Licenced by Liv-ex 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.
### [**Liv-ex.com**](http://www.liv-ex.com/)
* Liv-ex provide full technical developers documentation here:
* Price information is provided by the Price Data API V2 API, details here: [Price Data API v2.pdf](https://bluehost-sites.s3-eu-west-1.amazonaws.com/Price_Data_API_v2.pdf)
### **Setup**
Some initial setup is required to establish the details to access the Liv-ex API services.
Choose the  icon, enter **Item Market Values Setup**, and then choose the related link. Populate the following fields.
| **Field** | **Note** |
| ------------------------- | -------------------------------------------------------------------------------------------------------------------------------- |
| Liv-ex end Point (Search) | The API endpoint for LWIN searches is |
| Liv-ex end Point (Prices) | The API endpoint for LWIN price requests: [https://api.liv-ex.com/data/v2/priceData](https://api.liv-ex.com/data/v2/priceData';) |
| Liv-ex Key | Enter your key provided by Liv-ex |
| Liv-ex Secret | Enter your secret provided by Liv-ex |
| Price Type | Set the Price Type(s) you want to retrieve from Liv-ex. See below for the full list. |
| Search Description | See [Liv-ex LWIN](/documentation/guides/item-market-valuations/liv-ex_lwin.md) |
| Liv-ex Currency Code | Set the currency code used when requesting prices from Liv-ex. See below for full list. |
### **Market Prices**
Liv-ex 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 three ways you can retrieve market prices for an item.
#### 1. Manually for a single item
Navigate to an Item Card/List record that has a LWIN attached. Search for the **Get Liv-ex Prices** routine. Selecting this will update just that item's details.
#### 2. Manually for all items.
Navigate to **Item Market Values Setup** page, Actions, **Get Liv-ex Price Data** routine ribbon. This routine can be run without filters, and it will update prices for all items that have an LWIN attached.
#### 3. Creating a Job Queue Entry to run the routine automatically.
Create a Job Queue Entry that it 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)
{% 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 'Currency Code'**
Liv-ex provides market values in the following currencies: gbp, eur, chf, usd, hkd, jpy, sgd. Selecting one of these currencies will display valuations in that currency and also covert to Local currency. The Valuation Date is used to find the relevant exchange rate.
{% hint style="danger" %}
If the 'Liv-ex Currency Code' differs from your local currency, you must go to the **Currencies** page and populate the `Liv-ex Currency` field to map it to the corresponding system currency.
{% endhint %}
The following Liv-ex currency types are not supported: **gbpbtt, eurbtt, chfbtt, gbp/btt, eur/btt, chf/btt.** These provide prices pre-converted into bottle values. Bevica does this automatically, displaying prices in Base.
### **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 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 blank Valuation.
{% hint style="warning" %}
Your Liv-ex licence may not include all the options above, in this case no records will be returned by Liv-ex. Please confirm with your Liv-ex account manager.
{% endhint %}
---
# 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/liv-ex-market-prices.md?ask=&goal=
```
`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.