Services & Features

ProRealAI New Your coding copilot for ProRealTime™. From idea to ProBuilder code in seconds.

Library Free Free indicators, strategies, screeners & more

Marketplace Paid Premium paid tools for ProRealTime™

Forums Discuss, share, learn.

Groups Connect with traders

Snippets Hundreds of reusable trading codes & tools

ProRealQuant Strategies generator for ProRealTime™

How to format Date[N] in screener results

Forums
ProRealTime English Forum
ProScreener: Market Scanners & Detection
How to format Date[N] in screener results

Viewing 3 posts - 1 through 3 (of 3 total)

Author

Posts
05/25/2021 at 10:08 AM #170324 quote

HansLatour
Participant

New

How can I format the Date[N] variable in a column of the screener.
It ‘translates’ YYYYMMDD’ to a numeric value.

05/25/2021 at 11:08 AM #170340 quote
robertogozzi
Moderator

Legend
IT IS a numeric value. ProRealTime only supports floating point numeric data,

A date is usually displayed, with DrawText, as 20M (20 million).

You can try to remove the two leftmost digits (20), with this trick, so that 20210526 is abridged to 210526, but it will be reported with the thousands separator and, for years 0 to 9 the leading 0’s will be dropped (not tested):
```
x      = round((date / 1000000) - 0.5)
y      = x * 1000000
MyDate = date - y
```
05/25/2021 at 12:10 PM #170361 quote

HansLatour
Participant

New

Hi Roberto, thanks for your solution, works great!

I created a millennium-bug by taking a shortcut to your code by just subtracting 20000000 🙂

robertogozzi thanked this post
Author

Posts

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

Stuck on this ProBuilder code?

Describe what this topic is trying to build, in plain English, and ProRealAI writes the ProRealTime™ indicator, screener or system for you.

Available in 7 languages

Try ProRealAI

How to format Date[N] in screener results

ProScreener: Market Scanners & Detection

New Reply

Author

HansLatour @hanslatour Participant

Summary

This topic contains 2 replies,
has 2 voices, and was last updated by HansLatour
5 years, 3 months ago.

Topic Details

Forum:	ProScreener: Market Scanners & Detection
Language:	English
Started:	05/25/2021
Status:	Active
Attachments:	No files

Your ProRealCode Account

Or with Username or Email

I accept the Terms & Conditions

Remember me Forgot Password?

Not a Member yet? Sign up

About personal data collected

The information collected on this form is stored in a computer file by ProRealCode to create and access your ProRealCode profile. This data is kept in a secure database for the duration of the member's membership. They will be kept as long as you use our services and will be automatically deleted after 3 years of inactivity. Your personal data is used to create your private profile on ProRealCode. This data is maintained by SAS ProRealCode, 407 rue Freycinet, 59151 Arleux, France. If you subscribe to our newsletters, your email address is provided to our service provider "MailChimp" located in the United States, with whom we have signed a confidentiality agreement. This company is also compliant with the EU/Swiss Privacy Shield, and the GDPR. For any request for correction or deletion concerning your data, you can directly contact the ProRealCode team by email at privacy@prorealcode.com If you would like to lodge a complaint regarding the use of your personal data, you can contact your data protection supervisory authority.

Get Assistance

Assistance Type

Your Need

Proposed Solutions

Choose Assistance Type

Your choice will define the different steps of the wizard. If your demand is not listed, please contact us directly. Contact Page.

Public Assistance Your demand will be public and visible to all users. Or you might find the answer in our content.

Private Assistance Your demand will be private and visible only to you and the ProRealTime™ team (may include fees)

Your Need

Make a choice to define the next steps of the wizard.

I need programming help For all assistance about coding with ProRealTime™ I want to use available codes on my platform Quickly download and directly use codes on your platform
from trading strategies to indicators and screeners! I'd like to know more about trading For all assistance about trading with ProRealTime™ I want information about ProRealTime For all assistance about ProRealTime™

I need assistance with my ProRealTime account For all assistance about your ProRealTime account I need a programmer to help me code my idea (paid service) For all assistance about coding with ProRealTime™

Programming Help

Please find below the list of available solutions. If you don't find your solution, please contact us directly. Contact Page.

ProRealAI New Describe your idea in plain English and get ready-to-paste ProBuilder code in seconds.

Forums Ask your question in the forums and get help from the community.

Documentation Find all the documentation about the ProRealTime™ programming language.

Snippets Find code snippets available and shared by the community.

Learning Learn the ProRealTime™ programming language with our online courses.

Codes Library Find thousands of code examples available in the ProRealTime™ library.

Download Codes

Please find below the list of available solutions. If you don't find your solution, please contact us directly. Contact Page.

Library Find thousands of free codes examples available in the ProRealTime™ library.

ProRealCode Marketplace Hundreds of automated trading strategies, indicators and more proposed by professionals and the community.

Trading Help

Please find below the list of available solutions. If you don't find your solution, please contact us directly. Contact Page.

Learning Find courses about trading in our online learning content.

Groups Join trading groups and get help from the community.

Videos Find videos about trading in our online learning content.

Tutorials Find tutorials about trading in our online learning content.

ProRealTime Information

Please find below the list of available solutions. If you don't find your solution, please contact us directly. Contact Page.

ProRealTime™ Official Visit the official ProRealTime website for all information about the platform.

ProRealTime™ Help Page Visit the official ProRealTime help page for any help about the platform.

Account Assistance

Please find below the list of available solutions. If you don't find your solution, please contact us directly. Contact Page.

ProRealTime Contact Page A team of financial experts, engineers, and customer support representatives at your service!

Paid Programming Help

Please find below the list of available solutions. If you don't find your solution, please contact us directly. Contact Page.

The ProRealCode Programming Services Get your own custom-made indicators, strategies, and more for ProRealTime™.
We can also help you with your own code.
Since 2015, we have been helping thousands of traders and developers with their ProRealTime™ projects!

Do you like cookies? 🍪 We use cookies to ensure you get the best experience on our website. (Learn more)

About
Contact
Terms & Conditions
Privacy Policy
Moderation Rules

How to format Date[N] in screener results

Stuck on this ProBuilder code?

How to format Date[N] in screener results ProScreener: Market Scanners & Detection

Author

Summary

Topic Details

How to format Date[N] in screener results

ProScreener: Market Scanners & Detection