Sort array alphabetically - educational

14 Jan 2023

🔶   OVERVIEW


    • This educational script will sort an array of tickers alphabetically and place these values in an table, together with the according current price value next to each ticker.


🔶   SORT ALPHABETICALLY


🔹   I. We make a User Defined Type (UDT) obj, with:

        ·  ticker - the string name of the ticker
        ·  price - the current price (close)

    • From this UDT we make an object obj.new() for each ticker


🔹   II. 2 array's are made:

    • array of objects aObj, containing obj type obj.new() for every ticker
    • array of strings sort, the ticker part of each object obj.new()


🔹   III. Now we make an object of each ticker with the createObject(sym ) function

Pine Script®

    • the object object_1 consists off:
        ·  ticker -> "TICKER"
        ·  price -> current Daily close through request.security("TICKER") (non-repainting)
    • object_1 will be added to the aObj array
    • "TICKER" (string ticker part of object) will be added to the sort array


🔹   IV. The latter array is sorted alphabetically by using array.sort_indices()

EXAMPLE

Pine Script®

IMPORTANT

Alphabetically sorting is case sensitive, just like Java compareTo(String anotherString)!
    • The comparison is based on the Unicode value of each character in the string, the lowest "Dec" values are sorted first in line.
    • Comparing the "Dec" values at unicodelookup explains why default CAPITAL lettres will be sorted first,
    • Default you would get this (A= 65, B= 66, a= 97, b= 98)

Pine Script®

    • Adding str.lower(string) in the toLowerCase() function will result to the following:

Pine Script®

   • (A= 65 is transformed to a= 97, ...)

   • As a side note, should you write "AMZN" as "ÀMZN" this would be placed at the end, even after transforming to lower case the "Dec" values are higher (À= 192, à= 224).

    • You can toggle "To Lower Case" to verify.


🔹   V. Values are placed in a table, using these sorted indices.

    • With the usage of UDTs and objects, the current price has the same index in the aObj as their ticker,
                  giving the advantage it is fairly easy to place every value correctly next to each other.
    • The same can be done by make 2 separate arrays, 1 for the current price, the other for "TICKER".


🔶   OTHER TECHNIQUES USED


    • Alternative technique for adding comment

        Instead of

Pine Script®

        You can also do this:

Pine Script®

    • Alternate colour

        ·  During a loop, alternate colour when i is even or odd, using the modulo operation (%).
        ·  This is the remainder when dividing.

       EXAMPLE

        ·  3 % 2 = 1 -> 3 / 2 -> 1 * 2, 1 left (remainder)
        ·  4 % 2 = 0 -> 4 / 2 -> 2 * 2, 0 left (remainder)
        ·  5 % 2 = 1 -> 5 / 2 -> 2 * 2, 1 left (remainder)

Pine Script®

    • Adjust colour in script by using colour picker



Cheers!

14 Jan 2023

Nota Keluaran

Added "ignore_invalid_symbol= true" in "request.security()" function