Click here to Login





                                                   Number Formatting

  0

0
jason
2014-05-30 13:12:31


Hi-

Is there any way to format and/or round numbers returned in the watchlist? For example...

Performance value of 1.6432 presented as 1.6%
RSI value of 49.9432 presented as 50
Volume of 2921234 presented as 2,921,234

Thanks!








QuantShare
2014-05-30 18:24:18

  1

Hi Jason,

For volume, use this function: Transform Double To Comma Separated Representation
For rounding use: Round function.

Example:
AddColumn("RSI", round(rsi(14), 0));
AddColumn("Perf", round(perf(close, 10), 1)."%"); // . to append text






Transform Double To Comma Separated Representation (by QuantShare, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads Notes Report an item

No more messages
0




Reply:

No html code. URLs turn into links automatically.

Type in the trading objects you want to include: - Add Objects
To add a trading object in your message, type in the object name, select it and then click on "Add Objects"










QuantShare

Trading Items
Number of successive increases in the volume
Buy/Short a Fixed Number of Shares
Number of Days to a Specific Date
Number of Times an Event Occurred in the First N-Minutes of a Tra...
Number of Upgraded Stocks Minus Downgraded Stocks

How-to Lessons
How to dynamically change the number of positions in a portfolio?
How to display the number of stocks per day for different RSI gro...
How to optimize the number of positions in a trading system
How to display the number of notes per stock
How to plot the number of stock tweets per day

Related Forum Threads
Number of bars
Backtest, if number of buy is more than open positions, how QS se...
Maximum value of a given number of bars
How to read the number of positions in trading system
Counter for number of occurences..

Blog Posts
How to Create a Custom Real-Time Table using QS Trading Software
Automatically create historical quotes charts
Backtesting Your Trading Systems: Symbol Segmentation
Trading System: Buy stocks with the highest Sharpe ratio
How to choose which technical indicators to use in your trading s...









QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright © 2024 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.