Click here to Login

Trading Software Trading objects Features How-to Blog Search


                                                   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
Black-Scholes Option Pricing Model formula
Standard Error Bands
PIPS conversion formula in Forex trading
Chande TrendScore By Symbol
TSP Sentiment Survey - Percentage of Bullish and Bearish Traders

How-to Lessons
How to create a formula
How to download and use U.S. stocks earnings data
How to drag & drop indicators in charts
How to create histogram charts
How to display two stocks on the same chart

Related Forum Threads
Error in formula
Formula Error Update canceled
bollinger band & rsi formula
BSignalLong Formula
Error Graph should automatically scale

Blog Posts
Working with the formula editor
Custom Indicator: Accumulation Distribution Line
Download Trading Data using the Pre-Script
3 ways to rank stocks in a trading system - Simulator and Potfoli...
Ranking stocks based on their correlation with the S&P 500 Index









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 © 2012 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items