CData Cmdlets for OFX 2019J - Online Help


CData Cmdlets for OFX 2019J - Build 19.0.7354

Query open orders for a single investment account.


Name Type Description
Id [KEY] String Id assigned for the open order by the financial institution.
Aggregate String Transaction information aggregate.
BuyType String Type of purchase for this open order.
DatePlaced Datetime Date and time the order was placed.
Duration String Indicates how long the open order is good for.
FITId String Transaction Id assigned by the financial institution.
Memo String Other information about the open order.
Restriction String Special restriction on the open order.
SecurityId String Security Id for this open order.
SellType String Type of sale.
SubAcctType String This identifies the type of a subaccount.
TypeDesc String Description of the open order type.
UnitPrice Decimal What the units represent (shares or currency).
Units Double Quantity of the security the open order is for.
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