Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/27/2007(UTC)
Posts: 11
|
I notice that V writes the volume in hundreds (x100) to four decimal places. I can write the volume to 'thousands' with 'V * 100' but how do I remove the four decimal places and write V as an integer? I tried Int(V * 100) but this still shows up in a report with four decimal places.
Thanks
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Hi RobW,
Volume is always an integer amount for equities (but I guess volume could have decimal values for FX and some other markets where partial lots can be traded?)
Anyway, there is a difference between what you see on a chart and what you have to include in your MS Formula Language code. On the chart, volumes may be "scaled" to reduce the length of numbers on the axis, but notice there is a little box, usually on the lowest end of the volume axis with the multiplier in it, something like "x1000" This means that instead of displaying the volume axis with values, say, 55000000 the shorter representation of 55000 could be used with the message of the scaling located on the axis. This means that you still need to account for the full volume of the trading day, say 55000000 shares, but the volume axis may be scaled automatically for better viewing.
In explorations, all column values will have four decimal places. Even the use of representations of true and false will return 1.000 and 0.0000 so you will always see the volume reported here with four decimal places.
Hope this helps.
wabbit [:D]
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
