|
PureBytes Links
Trading Reference Links
|
Hi - almost working, if I force the "return" to be a number (4) and I added IndustryID... to the filter, it works. I started fiddling with StrToNum, thinking I had to convert, but no luck. Below is the complete code.
1) My csv file is a text file that the numbers 1 through 10 are each in a new row with no commas.
2) Oddly, printf will display either all the even or all the odd numbers depending where it is in the code
3) Scan and Explore output data but are not restricted by IndustryID ( that's why I started to try and use StrToNum)
Thanks greatly
_SECTION_BEGIN("ReadingCSV Function");
Title = "ReadingCSV Function";
id = 0;
Found = "";
item = 0;
function IncludeIndustry( id )
{
local ids;
local fh;
ids = ",";
fh = fopen( "C:\\AmiBroker CSV\\ABTest.csv", "r" );
if ( fh )
{
while ( !feof( fh ) )
{
// printf( fgets( fh ) ); // printf displays only odd numbers ???
ids += fgets( fh );
ids += ",";
printf( fgets( fh ) ); // printf displays only even numbers ???
}
fclose( fh );
}
return StrFind( "," + id + "," , ids ); // original code
/* Found = StrFind( "," + id + "," , ids ); // trying StrToNum ???
Item = StrToNum( "Found" ); // Syntax error ???
Item = StrToNum( "4" ); // this works fine
Item = 4; // forcing return to be 4
return Item;
*/
}
Filter = IndustryID() == IncludeIndustry( IndustryID() );
Buy = Close > 0;
Sell = Close = 0;
AddColumn ( Buy,"Buy" );
AddColumn ( Sell,"Sell" );
AddColumn ( Close,"Close" );
AddTextColumn( FullName(),"FullName" );
AddColumn( id, "Id" );
//AddColumn( Found, "Found" );
AddColumn( Item, "item" );
_SECTION_END();
--- In amibroker@xxxxxxxxxxxxxxx, "Mike" <sfclimbers@xxx> wrote:
>
> Forgot to add the fclose. As always, double check everything given in a forum ;)
>
> Mike
>
> --- In amibroker@xxxxxxxxxxxxxxx, "Mike" <sfclimbers@> wrote:
> >
> > Ideally, you would use static variables to read the file only once and hang on to the list. That can be your next iteration in the evolution of your code.
> >
> > For now, assuming that the file contains one or more lines of one or more comma separated values (without any blank spaces between values and without blank lines), the path you are following would probably look something like this (untested, going from memory based on an earlier posting by someone else that I can't find right now):
> >
> > function IncludeIndustry(id) {
> > local ids;
> > local fh;
> >
> > ids = ",";
> > fh = fopen("C:\\AmiBroker CSV\\ABTest.csv","r");
> >
> > if (fh) {
> > while(!feof(fh)) {
> > ids += fgets(fh);
> > ids += ",";
> > }
> > }
> >
> > return StrFind("," + id + ",", ids);
> > }
> >
> > Filter = IncludeIndustry(IndustryID());
> >
> > Mike
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@> wrote:
> > >
> > > Ok - here is what I have but can't quite get it to work.
> > > I have the code to fget and the code that I want to replace.
> > > How do I put a loop inside the "New Method" to fget to read the csv file in place of each "OR" I have in the "Old Method"?
> > >
> > > ****New Method****
> > > _SECTION_BEGIN("ReadingCSV");
> > > Title = "Reading CSV";
> > > fh = fopen("C:\\AmiBroker CSV\\ABTest.csv","r");
> > > if (fh)
> > > {
> > > while(!feof(fh))
> > > {
> > > Numbers = fgets( fh ); // What I need to do is use this list to slim down the IndustryID to be used
> > > //IndustryID() == Numbers; // This might work, but how to implement ?
> > > }
> > > }
> > > else
> > > {
> > > printf("ERROR: file can not be found (does not exist)");
> > > }
> > > fclose(fh);
> > > _SECTION_END();
> > >
> > >
> > > **** Old method ****
> > > if ( RIDon == 1 ) // RIDon is restrict to these Industrys
> > > Filter = Filter AND (
> > > IndustryID() == 2
> > > OR IndustryID() == 3
> > > OR IndustryID() == 4
> > > OR IndustryID() == 5
> > > OR IndustryID() == 7
> > > OR IndustryID() == 15
> > > );
> > >
> > > > > Does anyone have simple snippet of code that takes a csv file (could be
> > > > > comma delimited or carrage returned) that then can be the input for going
> > > > > through a list.
> > > > >
> > > > > Example: text.csv contains a list of numbers that would be used to
> > > > > "restrict" or "slim down" the IndustryID that is being used for a "display"
> > > > > or "explore".
> > > > >
> > > > > Thanks
> > > > >
> > >
> >
>
------------------------------------
**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/amibroker/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:amibroker-digest@xxxxxxxxxxxxxxx
mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|