Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 23:16:56 +0000



Fisher

View Count: 197

[2024-04-30 15:20:29]
User411320 - Posts: 289
Hello,

I'm using the function FISHER and tried =FISHER(E3) and FISHER(E3:12), with column E being close prices but it's returning #VALUE!

What am I doing wrong?
[2024-04-30 17:04:30]
John - SC Support - Posts: 36238
The FISHER function takes a single number value for an argument, so the following should be fine:
=FISHER(E3)

As long as E3 is a value between -1 and 1. Refer to the following:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#FISHER_Function
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-04-30 18:27:33]
User411320 - Posts: 289
I apologize I misread the documentation and thought it would return -1 and 1. I'm using close prices

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account