Bug — Positions CSV export breaks on prices >= $1,000

Report a problem or error
1

The “positions” CSV download doesn’t properly handle Last Price values that contain a thousands separator comma.

Example from a recent R2G holdings export:

FIX,"Comfort Systems USA, Inc.",208,6.65,1,429.37

The name field correctly wraps comma-containing values in quotes, but the last price field doesn’t.

Properly quoting it would be one fix, but perhaps removing the thousands separator altogether would be cleaner and make more sense.

Thank you for taking a look into this.

1 Like
2

It has been confirmed that when downloading Holdings from a Designer Model, the Last Price field includes a comma as a thousands separator whenever the value exceeds 1,000.

3

Thank you for confirming. I will code around this issue on my end for the time being.

4

@ars7777 The problem has been resolved. We opted to quote them strictly on the basis that it matches the convention of many other CSV downloads on the site.

5

Thanks so much!