java.lang.Object
- com.opengamma.strata.loader.csv.CsvLoaderUtils

```
public final class CsvLoaderUtils
extends Object
```
CSV information resolver helper.
This simplifies implementations of TradeCsvInfoResolver and PositionCsvInfoResolver.

Field Summary

Fields
Modifier and Type	Field	Description
`static String`	`CONTRACT_CODE_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`CONTRACT_SIZE`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`CURRENCY`	Deprecated. Use `CsvLoaderColumns`.
`static int`	`DEFAULT_OPTION_VERSION_NUMBER`	Default version used as an option might not specify a version number.
`static String`	`EXCHANGE_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`EXERCISE_PRICE_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`EXERCISE_STYLE_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`EXPIRY_DAY_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`EXPIRY_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`EXPIRY_WEEK_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`LONG_QUANTITY_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`PRICE_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`PUT_CALL_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`QUANTITY_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`SECURITY_ID_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`SECURITY_ID_SCHEME_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static ImmutableMap<String,EtdSettlementType>`	`SETTLEMENT_BY_CODE`	Lookup settlement by code.
`static String`	`SETTLEMENT_TYPE_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`SHORT_QUANTITY_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`TICK_SIZE`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`TICK_VALUE`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`UNDERLYING_EXPIRY_FIELD`	Deprecated. Use `CsvLoaderColumns`.
`static String`	`VERSION_FIELD`	Deprecated. Use `CsvLoaderColumns`.

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method	Description
`static String`	`formattedDouble(double value)`	Returns a value formatted as a double.
`static String`	`formattedPercentage(double value)`	Returns a value formatted as a percentage.
`static AdjustableDate`	`parseAdjustableDate(CsvRow row, String dateField, String conventionField, String calendarField)`	Parses a business day adjustment, without defaulting the adjustment.
`static AdjustableDate`	`parseAdjustableDate(CsvRow row, String dateField, String conventionField, String calendarField, BusinessDayConvention defaultConvention, Currency currency)`	Parses a business day adjustment, defaulting the adjustment using the currency.
`static AdjustablePayment`	`parseAdjustablePayment(CsvRow row, String currencyField, String amountField, String directionField, String dateField, String conventionField, String calendarField)`	Parses an adjustable payment.
`static Barrier`	`parseBarrier(CsvRow row, String barrierTypeField, String knockTypeField, String barrierLevelField)`	Parses a barrier from the csv row.
`static Barrier`	`parseBarrierFromDefaultFields(CsvRow row)`	Parses a barrier using the default barrier fields.
`static Optional<BusinessDayAdjustment>`	`parseBusinessDayAdjustment(CsvRow row, String conventionField, String calendarField)`	Parses a business day adjustment.
`static CurrencyAmount`	`parseCurrencyAmount(CsvRow row, String currencyField, String amountField)`	Parses a currency amount.
`static CurrencyAmount`	`parseCurrencyAmountWithDirection(CsvRow row, String currencyField, String amountField, String directionField)`	Parses a currency amount with direction.
`static DaysAdjustment`	`parseDaysAdjustment(CsvRow row, String daysField, String daysCalField, String cnvField, String calField)`	Parses days adjustment from CSV.
`static EtdOptionType`	`parseEtdOptionType(String str)`	Parses the ETD option type from the short code or full name.
`static EtdSettlementType`	`parseEtdSettlementType(String str)`	Parses the ETD settlement type from the short code or full name.
`static Pair<YearMonth,EtdVariant>`	`parseEtdVariant(CsvRow row, EtdType type)`	Parses the year-month and variant.
`static AdjustablePayment`	`parsePremiumFromDefaultFields(CsvRow row)`	Parses the premium using the default premium fields.
`static DoublesPair`	`parseQuantity(CsvRow row)`	Parses the quantity.
`static ZonedDateTime`	`parseZonedDateTime(CsvRow row, String dateField, String timeField, String zoneField)`	Parse a ZonedDateTime from the provided fields.
`static Optional<AdjustableDate>`	`tryParseAdjustableDate(CsvRow row, String dateField, String conventionField, String calendarField)`	Tries parsing an adjustable date from the mentioned fields in the csv row.
`static Optional<AdjustablePayment>`	`tryParseAdjustablePayment(CsvRow row, String currencyField, String amountField, String directionField, String dateField)`	Tries parsing an adjustable payment, defaulting the AdjustableDate to no BusinessDayAdjustment.
`static Optional<AdjustablePayment>`	`tryParseAdjustablePayment(CsvRow row, String currencyField, String amountField, String directionField, String dateField, String conventionField, String calendarField)`	Tries parsing an adjustable payment using the mentioned fields.
`static Optional<CurrencyAmount>`	`tryParseCurrencyAmountWithDirection(CsvRow row, String currencyField, String amountField, String directionField)`	Tries parsing a currency amount from the mentioned fields in the csv row.
`static Optional<AdjustablePayment>`	`tryParsePremiumFromDefaultFields(CsvRow row)`	Tries parsing the premium using the default premium fields.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail
- SECURITY_ID_SCHEME_FIELD
```
@Deprecated
public static final String SECURITY_ID_SCHEME_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the security ID scheme/symbology.
  
  See Also:
  
  Constant Field Values
- SECURITY_ID_FIELD
```
@Deprecated
public static final String SECURITY_ID_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the security ID.
  
  See Also:
  
  Constant Field Values
- EXCHANGE_FIELD
```
@Deprecated
public static final String EXCHANGE_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the exchange.
  
  See Also:
  
  Constant Field Values
- CONTRACT_CODE_FIELD
```
@Deprecated
public static final String CONTRACT_CODE_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the contract code.
  
  See Also:
  
  Constant Field Values
- LONG_QUANTITY_FIELD
```
@Deprecated
public static final String LONG_QUANTITY_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the long quantity.
  
  See Also:
  
  Constant Field Values
- SHORT_QUANTITY_FIELD
```
@Deprecated
public static final String SHORT_QUANTITY_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the short quantity.
  
  See Also:
  
  Constant Field Values
- QUANTITY_FIELD
```
@Deprecated
public static final String QUANTITY_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the quantity.
  
  See Also:
  
  Constant Field Values
- PRICE_FIELD
```
@Deprecated
public static final String PRICE_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the price.
  
  See Also:
  
  Constant Field Values
- EXPIRY_FIELD
```
@Deprecated
public static final String EXPIRY_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the expiry month/year.
  
  See Also:
  
  Constant Field Values
- EXPIRY_WEEK_FIELD
```
@Deprecated
public static final String EXPIRY_WEEK_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the expiry week.
  
  See Also:
  
  Constant Field Values
- EXPIRY_DAY_FIELD
```
@Deprecated
public static final String EXPIRY_DAY_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the expiry day.
  
  See Also:
  
  Constant Field Values
- SETTLEMENT_TYPE_FIELD
```
@Deprecated
public static final String SETTLEMENT_TYPE_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the settlement type.
  
  See Also:
  
  Constant Field Values
- EXERCISE_STYLE_FIELD
```
@Deprecated
public static final String EXERCISE_STYLE_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the exercise style.
  
  See Also:
  
  Constant Field Values
- VERSION_FIELD
```
@Deprecated
public static final String VERSION_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the option version.
  
  See Also:
  
  Constant Field Values
- PUT_CALL_FIELD
```
@Deprecated
public static final String PUT_CALL_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the put/call flag.
  
  See Also:
  
  Constant Field Values
- EXERCISE_PRICE_FIELD
```
@Deprecated
public static final String EXERCISE_PRICE_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the option strike price.
  
  See Also:
  
  Constant Field Values
- UNDERLYING_EXPIRY_FIELD
```
@Deprecated
public static final String UNDERLYING_EXPIRY_FIELD
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the underlying expiry month/year.
  
  See Also:
  
  Constant Field Values
- CURRENCY
```
@Deprecated
public static final String CURRENCY
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the currency.
  
  See Also:
  
  Constant Field Values
- TICK_SIZE
```
@Deprecated
public static final String TICK_SIZE
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the tick size.
  
  See Also:
  
  Constant Field Values
- TICK_VALUE
```
@Deprecated
public static final String TICK_VALUE
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the tick value.
  
  See Also:
  
  Constant Field Values
- CONTRACT_SIZE
```
@Deprecated
public static final String CONTRACT_SIZE
```
  Deprecated.
  Use CsvLoaderColumns.
  
  The column name for the contract size.
  
  See Also:
  
  Constant Field Values
- DEFAULT_OPTION_VERSION_NUMBER
```
public static final int DEFAULT_OPTION_VERSION_NUMBER
```
  Default version used as an option might not specify a version number.
  
  See Also:
  
  Constant Field Values
- SETTLEMENT_BY_CODE
```
public static final ImmutableMap<String,EtdSettlementType> SETTLEMENT_BY_CODE
```
  Lookup settlement by code.

Method Detail

parseEtdVariant

public static Pair<YearMonth,EtdVariant> parseEtdVariant(CsvRow row,
                                                               EtdType type)

Parses the year-month and variant.

Parameters:: row - the CSV row to parse; type - the ETD type
Returns:: the expiry year-month and variant
Throws:: ParseFailureException - if the row cannot be parsed

parseEtdSettlementType
```
public static EtdSettlementType parseEtdSettlementType(String str)
```
Parses the ETD settlement type from the short code or full name.

Parameters:

str - the string to parse

Returns:

the settlement type

Throws:

ParseFailureException - if the string cannot be parsed

parseEtdOptionType
```
public static EtdOptionType parseEtdOptionType(String str)
```
Parses the ETD option type from the short code or full name.

Parameters:

str - the string to parse

Returns:

the option type

Throws:

ParseFailureException - if the string cannot be parsed

parseQuantity
```
public static DoublesPair parseQuantity(CsvRow row)
```
Parses the quantity.

Parameters:

row - the CSV row to parse

Returns:

the quantity, long first, short second

Throws:

ParseFailureException - if the row cannot be parsed

parseZonedDateTime

public static ZonedDateTime parseZonedDateTime(CsvRow row,
                                               String dateField,
                                               String timeField,
                                               String zoneField)

Parse a ZonedDateTime from the provided fields.

Parameters:: row - the CSV row; dateField - the date field; timeField - the time field; zoneField - the zone field
Returns:: the zoned date time
Throws:: ParseFailureException - if the row cannot be parsed

parseAdjustableDate

public static AdjustableDate parseAdjustableDate(CsvRow row,
                                                 String dateField,
                                                 String conventionField,
                                                 String calendarField)

Parses a business day adjustment, without defaulting the adjustment.

Parameters:: row - the CSV row to parse; dateField - the date field; conventionField - the convention field; calendarField - the calendar field
Returns:: the adjustment
Throws:: ParseFailureException - if the row cannot be parsed

parseAdjustableDate

public static AdjustableDate parseAdjustableDate(CsvRow row,
                                                 String dateField,
                                                 String conventionField,
                                                 String calendarField,
                                                 BusinessDayConvention defaultConvention,
                                                 Currency currency)

Parses a business day adjustment, defaulting the adjustment using the currency.

Parameters:: row - the CSV row to parse; dateField - the date field; conventionField - the convention field; calendarField - the calendar field; defaultConvention - the default convention; currency - the applicable currency, used for defaulting
Returns:: the adjustment
Throws:: ParseFailureException - if the row cannot be parsed

parseAdjustablePayment

public static AdjustablePayment parseAdjustablePayment(CsvRow row,
                                                       String currencyField,
                                                       String amountField,
                                                       String directionField,
                                                       String dateField,
                                                       String conventionField,
                                                       String calendarField)

Parses an adjustable payment.

Parameters:: row - the CSV row to parse; currencyField - the currency field; amountField - the amount field; directionField - the direction field; dateField - the date field; conventionField - the convention field; calendarField - the calendar field
Returns:: the adjustable payment
Throws:: ParseFailureException - if the row cannot be parsed

parseBarrier

public static Barrier parseBarrier(CsvRow row,
                                   String barrierTypeField,
                                   String knockTypeField,
                                   String barrierLevelField)

Parses a barrier from the csv row.

Parameters:: row - the CSV row to parse; barrierTypeField - the barrier type field; knockTypeField - the knock type field; barrierLevelField - the barrier level field
Returns:: the barrier
Throws:: ParseFailureException - if the row cannot be parsed

parseBarrierFromDefaultFields
```
public static Barrier parseBarrierFromDefaultFields(CsvRow row)
```
Parses a barrier using the default barrier fields.

Parameters:

row - the CSV row to parse

Returns:

the barrier

Throws:

ParseFailureException - if the row cannot be parsed

parsePremiumFromDefaultFields
```
public static AdjustablePayment parsePremiumFromDefaultFields(CsvRow row)
```
Parses the premium using the default premium fields.

Parameters:

row - the CSV row to parse

Returns:

the adjustable payment

Throws:

ParseFailureException - if the row cannot be parsed

parseBusinessDayAdjustment

public static Optional<BusinessDayAdjustment> parseBusinessDayAdjustment(CsvRow row,
                                                                         String conventionField,
                                                                         String calendarField)

Parses a business day adjustment.

Parameters:: row - the CSV row to parse; conventionField - the convention field; calendarField - the calendar field
Returns:: the adjustment
Throws:: ParseFailureException - if the row cannot be parsed

parseDaysAdjustment

public static DaysAdjustment parseDaysAdjustment(CsvRow row,
                                                 String daysField,
                                                 String daysCalField,
                                                 String cnvField,
                                                 String calField)

Parses days adjustment from CSV.

Parameters:: row - the CSV row to parse; daysField - the days field; daysCalField - the days calendar field; cnvField - the convention field; calField - the calendar field
Returns:: the adjustment
Throws:: ParseFailureException - if the row cannot be parsed

parseCurrencyAmount

public static CurrencyAmount parseCurrencyAmount(CsvRow row,
                                                 String currencyField,
                                                 String amountField)

Parses a currency amount.

Parameters:: row - the CSV row to parse; currencyField - the currency field; amountField - the amount field
Returns:: the currency amount
Throws:: ParseFailureException - if the row cannot be parsed

parseCurrencyAmountWithDirection

public static CurrencyAmount parseCurrencyAmountWithDirection(CsvRow row,
                                                              String currencyField,
                                                              String amountField,
                                                              String directionField)

Parses a currency amount with direction.

Parameters:: row - the CSV row to parse; currencyField - the currency field; amountField - the amount field; directionField - the direction field
Returns:: the currency amount
Throws:: ParseFailureException - if the row cannot be parsed

tryParseAdjustableDate

public static Optional<AdjustableDate> tryParseAdjustableDate(CsvRow row,
                                                              String dateField,
                                                              String conventionField,
                                                              String calendarField)

Tries parsing an adjustable date from the mentioned fields in the csv row.

Parameters:: row - the CSV row to parse; dateField - the date field; conventionField - the convention field; calendarField - the calendar field
Returns:: the adjustable date option

tryParseCurrencyAmountWithDirection

public static Optional<CurrencyAmount> tryParseCurrencyAmountWithDirection(CsvRow row,
                                                                           String currencyField,
                                                                           String amountField,
                                                                           String directionField)

Tries parsing a currency amount from the mentioned fields in the csv row.

Parameters:: row - the CSV row to parse; currencyField - the currency field; amountField - the amount field; directionField - the direction field
Returns:: the currency amount option

tryParsePremiumFromDefaultFields
```
public static Optional<AdjustablePayment> tryParsePremiumFromDefaultFields(CsvRow row)
```
Tries parsing the premium using the default premium fields.

Parameters:

row - the CSV row to parse

Returns:

the premium option

tryParseAdjustablePayment

public static Optional<AdjustablePayment> tryParseAdjustablePayment(CsvRow row,
                                                                    String currencyField,
                                                                    String amountField,
                                                                    String directionField,
                                                                    String dateField)

Tries parsing an adjustable payment, defaulting the AdjustableDate to no BusinessDayAdjustment.

Parameters:: row - the CSV row to parse; currencyField - the currency field; amountField - the amount field; directionField - the direction field; dateField - the date field
Returns:: the adjustable payment option

tryParseAdjustablePayment

public static Optional<AdjustablePayment> tryParseAdjustablePayment(CsvRow row,
                                                                    String currencyField,
                                                                    String amountField,
                                                                    String directionField,
                                                                    String dateField,
                                                                    String conventionField,
                                                                    String calendarField)

Tries parsing an adjustable payment using the mentioned fields.

Defaults to tryParseAdjustablePayment(CsvRow,String,String,String,String) if the adjustable date parsing fails as it is often due to a missing calendar or convention.

Parameters:: row - the CSV row to parse; currencyField - the currency field; amountField - the amount field; directionField - the direction field; dateField - the date field; conventionField - the date convention field; calendarField - the date calendar field
Returns:: the adjustable payment option

formattedPercentage
```
public static String formattedPercentage(double value)
```
Returns a value formatted as a percentage.
Using this method avoids nasty effects from floating point arithmetic.

Parameters:

value - the value in decimal format (to be multiplied by 100)

Returns:

the formatted percentage value

formattedDouble
```
public static String formattedDouble(double value)
```
Returns a value formatted as a double.
Using this method avoids nasty effects from floating point arithmetic.

Parameters:

value - the value

Returns:

the formatted value

Class CsvLoaderUtils

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

SECURITY_ID_SCHEME_FIELD

SECURITY_ID_FIELD

EXCHANGE_FIELD

CONTRACT_CODE_FIELD

LONG_QUANTITY_FIELD

SHORT_QUANTITY_FIELD

QUANTITY_FIELD

PRICE_FIELD

EXPIRY_FIELD

EXPIRY_WEEK_FIELD

EXPIRY_DAY_FIELD

SETTLEMENT_TYPE_FIELD

EXERCISE_STYLE_FIELD

VERSION_FIELD

PUT_CALL_FIELD

EXERCISE_PRICE_FIELD

UNDERLYING_EXPIRY_FIELD

CURRENCY

TICK_SIZE

TICK_VALUE

CONTRACT_SIZE

DEFAULT_OPTION_VERSION_NUMBER

SETTLEMENT_BY_CODE

Method Detail

parseEtdVariant

parseEtdSettlementType

parseEtdOptionType

parseQuantity

parseZonedDateTime

parseAdjustableDate

parseAdjustableDate

parseAdjustablePayment

parseBarrier

parseBarrierFromDefaultFields

parsePremiumFromDefaultFields

parseBusinessDayAdjustment

parseDaysAdjustment

parseCurrencyAmount

parseCurrencyAmountWithDirection

tryParseAdjustableDate

tryParseCurrencyAmountWithDirection

tryParsePremiumFromDefaultFields

tryParseAdjustablePayment

tryParseAdjustablePayment

formattedPercentage

formattedDouble