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.

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.

Prerequisites

• Licenced by GW to access online data via API.
• Items linked to a Liv-ex LWIN7. See Liv-ex LWIN.
• 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 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.

To retrieve market prices

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

1

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.

2

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.

3

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.

Bevica only supports GBP Liv-ex prices.

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 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.