The Metal prices module in PIRO Fusion is a complex tool that can be used to manage and track metal prices. Prices can be automatically updated at regular customizable intervals using the prices available on major commodity exchanges (APMEX, New York Market, London Fix or Golden Blessing-Israel). Alternatively, prices can be manually added in by PIRO Fusion users. Additional fees, such as bank charges or company markups, can also be incorporated in the price of any metal type. Furthermore, prices added in PIRO Fusion can be tracked using the market price history functionality and the in-built charting tool.

The Metal prices tab includes two sub-tabs:

• Current market prices
• Market price history

Below we shall look at each of these sub-tabs in detail.

Current market prices

The Current market prices tab displays the latest market prices available in PIRO Fusion for pure metals and casting alloys, which are handled as the current market prices. These market prices are used to calculate the current prices of item types having market-based pricing set up and which include metals.

Current prices

The upper section of the form displays the latest market prices available for pure metals (24k Gold, Platinum, Palladium, Silver) separately in OZT, Dwt and Gram. These pure metals are displayed in individual sub-tabs. The market price is the base price, completely absent of any markups. The date when the latest market prices were updated (either manually or automatically) in PIRO Fusion is indicated in the top-left corner of this section.

PIRO Fusion can also incorporate additional fees, such as bank charges and company markups, in the price of the pure metals. This results in customizable pure metal prices at the company level, also referred to as Company prices in PIRO Fusion. These additional fees may be set individually for each pure metal by filling in the Bank charge/ozt and Company markup fields. The fees are then added to the pure metal market prices.

The OZT price, Bank Charges and Company markup fields are editable, and the user may enter any custom values in these fields, with a few considerations. Bank charges represent an absolute value that is added to pure metal market prices, while company markups represent a percentage by which the sum between the market prices and bank charges is then increased, e.g. metal market gram price=$25, bank charge=$5, company markup=10%. Company gram price = (25+5)+(30*10/100).

The Company dwt price and Company gram price fields are recalculated automatically when the bank charge or company markup has been changed.

After filling the mentioned fields, you should save the entered data using the Save for current date button. However if you want to define the metal prices for another date use the Save for different date button and select a date.

Market price evolution in last 30 days

The charting tool in the bottom section of the form allows tracking the pure metal price evolution in the last 30 days. Gold, platinum, palladium and silver market prices are each displayed on separate charts.

Casting alloy company prices

The Casting alloy company prices section displays the company prices in dwt and grams for all casting alloys added in PIRO Fusion. The price is calculated by multiplying the percentage of pure metal in a particular casting alloy (based on the ratios determined in the Inventory menu / Metal types tab) with the company price of the pure metal in dwt or gram. It is important to note that the pure metal company markups and bank charges are both included in the prices of casting alloys displayed in this list. Whenever the pure metal bank charges or company markups are modified and the user hits Save for current date / Save for different date in the first section, the casting alloy company prices are automatically recalculated as well.

Market price history

The Market price history tab displays the history of the daily pure metal market prices. This applies both to manually set metal prices and metal prices uploaded automatically using a particular market feed.

The grid columns display the following information related to daily market prices:

1. Price list type: Displays the name of the market from which PIRO Fusion takes the pure metal price quotes. There are four available market types: London, New York, Apmex and Golden Blessing-Israel.
2. Date: Displays the date when a particular price quote was entered in PIRO Fusion.
3. Metal: Displays the name of the pure metal related to the price quote.
4. OZT price: Displays the market price of a particular pure metal in OZT.
5. Dwt price: Displays the market price of a particular pure metal in Dwt.
6. Gram price: Displays the market price of a particular pure metal in gram.
7. Sale dwt price: Displays the sale price of a particular pure metal in Dwt (including company markups and bank charges).
8. Sale gram price: Displays the sale price of a particular pure metal in gram (including company markups and bank charges).

New pure metal price quotes may be added by clicking the Create new button (under the grid) or the . Price quotes can be entered in batch for all pure metals via the Metal prices form:

1. Price list type: The source for the market price quotes may be selected from this drop-down field. The following markets are available: New York, London, Apmex and Golden Blessing-Israel.
2. Date: The date of the price quotes can be set from this list.
3. OZT price: The pure metals’ price per OZT can be set from this field.
4. Dwt price: A read-only field displaying the pure metals’ price per Dwt. The price is calculated based on the price quote in OZT.
5. Gram price: A read-only field displaying the pure metals’ price per gram. The price is calculated based on the price quote in OZT.

Once entered, the price quotes may be saved by using the Save button. An existing price quote can be edited using the icon, which can be found at the end of price quote’s row. Deleting a price quote is possible using the icon.

Filters

Going through the market price history can be done through the expandable Filters panel, located above the grid. Searches may be performed using as many filters as are necessary. PIRO Fusion displays the results that simultaneously match the content of all used filters.
The following filters are available:

1. Price list type: Filters the market price history based on the price list type (e.g. Apmex, London fix, etc.)
2. Metal type: Filters based on the metal type, showing a particular metal type’s market price history.
3. Date from / Date to: Defines the search date interval.
4. Show pure metal prices only: If ticked, filters the market price history based on the pure metal types.