Click here to Login





                                                   Error in formula

  0

0
Bryan Pettitt
2011-02-04 23:47:47


I have imported data from an external program into a database. I can plot the data in the charts. I am now trying to set up a neural network using
inputs from the database field. The neural network will work when I run it with only inputs from QUOTES. When I add one of the inputs from my data,
the neural network sets up , but when I try to train it I get the following error box.

Info Dialog Box:
Error in formula:
Syntax error on "_", state 1324, expecting: IDENT
Error while compiling formula.

The field I am trying to use is a binary indicator with a range of 0 to 1. In the neural network, I have a Database field selected named 'predictedneuralindex'
with a WS of 1 and a scaling from 0 to 1. I have tried all three parameter options of 'LastData', Zero, and NA.

I am on a trial of Quantshare and while I like a lot of the features, importing csv data into a database and using it in a neural network is a requirement.
Any suggestions?



QuantShare
2011-02-05 05:29:22

  0

Best Answer
Hello Bryan,

Sorry about that, we will fix this in the next release.

There is another solution to use databases data:
- In Inputs control and under the "Type" column, select "Formula" instead of "Database Field".
- Click on "Select"
- Type the following formula: GetData("database name", "field name")

Don't forget to replace "database name" by the name of your database and "field name" by the name of your database field.



Bryan Pettitt
2011-02-05 15:53:04

  0

Thanks, the work-around will let me continue...


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
Standard Error of the Estimate of a Regression Line
Black-Scholes Option Pricing Model formula
Standard Error Bands
PREV - Previous value of the same formula
Formula & Symbol Switcher

How-to Lessons
How to create a formula
How to change volume bar colors when the price closes down
How to dynamically update the settings of an indicator
How to create a moving average of an indicator
How to add a trading indicator to a chart

Related Forum Threads
Error in formula
Rules Analyzer - Error in Formula
Formula Error Update canceled
Chande trendscore error formula
<Help> Unable to decipher error in the following formula

Blog Posts
Working with the formula editor
Custom Indicator: Accumulation Distribution Line
Let me Show You How to Create Hundreds of Profitable Trading Syst...
Troubleshooting a Trading System
Download Trading Data using the Pre-Script









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.