{"id":2698,"date":"2022-10-10T09:27:18","date_gmt":"2022-10-10T09:27:18","guid":{"rendered":"https:\/\/www.overcharts.com\/en\/helpcenter\/?post_type=docs&p=2698"},"modified":"2023-06-16T09:51:05","modified_gmt":"2023-06-16T09:51:05","password":"","slug":"overbasic-other-functions","status":"publish","type":"docs","link":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-other-functions\/","title":{"rendered":"Overbasic – Other functions"},"content":{"rendered":"\n

My.Other<\/strong> category contains all built-in functions that do not belong to a specific category.<\/p>\n\n\n\n

<\/div>\n\n\n\n

IIFnumeric<\/strong><\/h2>\n\n\n\n

This function simulates the behavior of IF statement. To be used as an alternative to IF statement to assign a numeric value to a variable according to a specific condition.<\/p>\n\n\n\n

Result type<\/strong>: numeric<\/p>\n\n\n\n

Arguments<\/strong>:<\/p>\n\n\n\n

    \n
  • BOOLEAN ESPRESSION<\/strong>: any boolean expression.<\/li>\n\n\n\n
  • TRUE PART<\/strong>: numeric value the function should return when BOOLEAN EXPRESSION is TRUE.<\/li>\n\n\n\n
  • FALSE PART<\/strong>: numeric value the function should return when BOOLEAN EXPRESSION is FALSE.<\/li>\n<\/ul>\n\n\n\n
    <\/div>\n\n\n\n
    'i' will assume Close value if Close is greater than Open, otherwise Open.<\/mark>\nDim<\/mark><\/strong> i As<\/mark><\/strong> Numeric<\/strong><\/mark> = My.Other.IIFnumeric(Close > Open, Close, Open)<\/code><\/pre>\n\n\n\n
    <\/div>\n\n\n\n
    IIFstring<\/strong><\/h2>\n\n\n\n
    This function simulates the behavior of IF statement. To be used as an alternative to IF statement to assign a string value to a variable according to a specific condition.<\/p>\n\n\n\n
    Result type<\/strong>: string<\/p>\n\n\n\n
    Arguments<\/strong>:<\/p>\n\n\n\n
      \n
    • BOOLEAN ESPRESSION<\/strong>: any boolean expression.<\/li>\n\n\n\n
    • TRUE PART<\/strong>: string value the function should return when BOOLEAN EXPRESSION is TRUE.<\/li>\n\n\n\n
    • FALSE PART<\/strong>: string value the function should return when BOOLEAN EXPRESSION is FALSE.<\/li>\n<\/ul>\n\n\n\n
      <\/div>\n\n\n\n
      's' will assume 'HELLO' value if Close is greater than Open, otherwise 'WORLD'.<\/mark>\nDim<\/mark><\/strong> s As<\/mark><\/strong> String<\/strong><\/mark> = My.Other.IIFstring(Close > Open, \"HELLO\", \"WORLD\")<\/code><\/pre>\n\n\n\n
      <\/div>\n","protected":false},"excerpt":{"rendered":"
      My.Other category contains all built-in functions that do not belong to a specific category. IIFnumeric This function simulates the behavior of IF statement. To be used as an alternative to IF statement to assign a numeric value to a variable according to a specific condition. Result type: numeric Arguments: IIFstring This function simulates the behavior […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[18],"doc_tag":[],"class_list":["post-2698","docs","type-docs","status-publish","hentry","doc_category-built-in-funtions"],"year_month":"2026-10","word_count":195,"total_views":"1","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Overcharts Team","author_nicename":"overadmin","author_url":"https:\/\/www.overcharts.com\/en\/helpcenter\/author\/overadmin\/"},"doc_category_info":[{"term_name":"Built-In Funtions","term_url":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs-category\/built-in-funtions\/"}],"doc_tag_info":[],"yoast_head":"\r\nOverbasic - Other functions - Overcharts Help Center<\/title>\r\n<meta name=\"description\" content=\"My.Other category contains all built-in functions that do not belong to a specific category.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-other-functions\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Overbasic - Other functions - Overcharts Help Center\" \/>\r\n<meta property=\"og:description\" content=\"My.Other category contains all built-in functions that do not belong to a specific category.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-other-functions\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Overcharts Help Center\" \/>\r\n<meta property=\"article:modified_time\" content=\"2023-06-16T09:51:05+00:00\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-other-functions\\\/\",\"url\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-other-functions\\\/\",\"name\":\"Overbasic - Other functions - Overcharts Help Center\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/#website\"},\"datePublished\":\"2022-10-10T09:27:18+00:00\",\"dateModified\":\"2023-06-16T09:51:05+00:00\",\"description\":\"My.Other category contains all built-in functions that do not belong to a specific category.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-other-functions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-other-functions\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-other-functions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Overbasic – Other functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/#website\",\"url\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/\",\"name\":\"Overcharts Help Center\",\"description\":\"Trading Software & Technical Analysis\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Overbasic - Other functions - Overcharts Help Center","description":"My.Other category contains all built-in functions that do not belong to a specific category.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-other-functions\/","og_locale":"en_US","og_type":"article","og_title":"Overbasic - Other functions - Overcharts Help Center","og_description":"My.Other category contains all built-in functions that do not belong to a specific category.","og_url":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-other-functions\/","og_site_name":"Overcharts Help Center","article_modified_time":"2023-06-16T09:51:05+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-other-functions\/","url":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-other-functions\/","name":"Overbasic - Other functions - Overcharts Help Center","isPartOf":{"@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/#website"},"datePublished":"2022-10-10T09:27:18+00:00","dateModified":"2023-06-16T09:51:05+00:00","description":"My.Other category contains all built-in functions that do not belong to a specific category.","breadcrumb":{"@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-other-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-other-functions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-other-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.overcharts.com\/en\/helpcenter\/"},{"@type":"ListItem","position":2,"name":"Overbasic – Other functions"}]},{"@type":"WebSite","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/#website","url":"https:\/\/www.overcharts.com\/en\/helpcenter\/","name":"Overcharts Help Center","description":"Trading Software & Technical Analysis","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.overcharts.com\/en\/helpcenter\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs\/2698","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/comments?post=2698"}],"version-history":[{"count":3,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs\/2698\/revisions"}],"predecessor-version":[{"id":2701,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs\/2698\/revisions\/2701"}],"wp:attachment":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/media?parent=2698"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/doc_category?post=2698"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/doc_tag?post=2698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}