CData Cmdlets for OFX 2019J - Online Help


CData Cmdlets for OFX 2019J - Build 19.0.7354

Query positions for a single investment account.


Name Type Description
Id String Unique identifier for the order.
Aggregate String Transaction information aggregate.
Account String Indicates the type of subaccount that the position is held in.
DatePriceAsOf Datetime Date and time of the unit price and market value. Can be 0 if the unit price and market value are unknown.
MarketValue String Current market value of this position.
Memo String Memo regarding this position.
Option String Indicates the position type for the given subaccount where this position takes place.
SecurityID String Security Id for this investment transaction.
TypeDesc String Description of the transaction type.
UnitPrice Decimal Unit price of the position.
Units Double Quantity of the positions (stock, bonds, or options).
CurrencyCode String Default currency code for transactions.
StatementDate Datetime Date and time for the statement download.
Sec_Aggregate String Security information aggregate.
Sec_AssetClass String Asset class for the security.
Sec_Name String Full name of the security.
Sec_Ticker String Ticker symbol of the security.
Sec_UnitPrice Decimal The current unit price of the security as provided by the server. This may be a real-time or delayed quote.
Sec_Yield String Current yield reported as a portion of the fund's assets.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
OFXReadFile String Specify a file path to read OFX data from a local file. Data will not be requested from the financial institution and the local OFX data will be parsed.
OFXWriteFile String Specify a file path to create a local file containing the OFX data, including OFX headers, returned by the financial institution.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0