ajFIXCheckSum function

Available since AlchemyJ v4.2.1

Description

Returns the checksum of a FIX message.

ajFIXCheckSum(message, [response_type])

Argument Name	Argument Type	Description
message (required)	Variant	The FIX message from a range of cells. The range of cells can span across multiple rows and columns. All the cells will be concatenated.
response_type (Double)	String	If it equals 0, returns the checksum only. If it equals 1, returns the whole message with the checksum at the end. The default value is 0.

Argument Name

Argument Type

Description

message
(required)

Variant

The FIX message from a range of cells. The range of cells can span across multiple rows and columns. All the cells will be concatenated.

response_type
(Double)

String

If it equals 0, returns the checksum only.

If it equals 1, returns the whole message with the checksum at the end.

The default value is 0.

The function will return:

1) Return Value: Number / String

2) Return Type: Single Value / Multiple values (array formula)

In this example, the response type is 0. Only the checksum result will be returned.

In this example, the response type is 1. The return result will include the the original message with the checksum result appended.

It will return #VALUE! when missing any required parameter or mismatch parameter type. Besides, system will raise error for below scenario(s).

Error Scenario
Response type can only be 0 or 1.