Archive for Maret 2016
[amibroker] Exploration: Show unique list of companies

[amibroker] Exploration: Show unique list of companies

Coolman 22.22 Add Comment
 

When i run exploration, i see ticker and date column added and the same company names repeated as many dates are there.


Sometimes, i jsut want to output a unique list of Ticker Full names only.


How to do this?    


setoption("NoDefaultColumns" True);


Will remove only ticker and date but how to get uniqe FullNames,  not repeated for each dates.

 

__._,_.___
Posted by: meanomalist@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
**** 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/


.

__,_._,___
[amibroker] Re: Using Double Quotes in odbcGetValueSQL

[amibroker] Re: Using Double Quotes in odbcGetValueSQL

Coolman 22.16 Add Comment
 

Thank you Tomasz.

I want to pass a keyword in SQL statement:    "Processing Shrimps"   (Along with the Double Quotes)


So, i am writing it with \"  

fts_keyword = "  +\"Processing Shrimps\" +export  ";

1) But how to pass the variable   fts_keyword in below SQL statement?

score = odbcGetValueSQL("select MATCH(var1, var2, var3) AGAINST ( ' fts_keyword ' IN BOOLEAN MODE) as score from mytable where isin='"+Name()+"' ");

If we pass it the way I did above, it's not working. I also did  '+fts_keyword+'  that also does not work.

How to fix it?

2) Another qts is I want to define the fts_keyword through paramstring as below:


fts_keyword = ParamStr( ''keyword', ''default'' );

When the Parameter Popup windows comes: what should i enter for the Parameter keyword:

Should i enter:   +\"Processing Shrimps\" +export

Or should i enter like:  " +\"Processing Shrimps\" +export "

Which will be same as

fts_keyword = "  +\"Processing Shrimps\" +export  ";

as in qts 1) above?


THe Objective of qts 2) is I want to pass the variable fts_keyword to the SQL statement through a parameter.





__._,_.___
Posted by: meanomalist@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
**** 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/


.

__,_._,___
Re: [amibroker] Adding a Logo (.jpg) to a chart

Re: [amibroker] Adding a Logo (.jpg) to a chart

Coolman 18.26 Add Comment
 

I understand.  It was just a thought.
I thought of the watermark also but couldn't find such in Preferences or Help.

Regards,
Alan

On 3/31/2016 7:00 PM, 'Tavenui(AUS)' tavenui@hotmail.com [amibroker] wrote:
 

Thanks Alan,

 

I am looking for something a little classier.

 

I want the logo insert or as a watermark.

 

Regards

 

Paul

 

From: Alan alan@thenorthams.us [amibroker] [mailto:amibroker@yahoogroups.com]
Sent: Thursday, 31 March 2016 11:20 PM
To: amibroker@yahoogroups.com
Subject: Re: [amibroker] Adding a Logo (.jpg) to a chart

 

 

You can always easily add text to the title line i.e., "TRAINING ONLY".
Just a thought!

Regards,
Alan

On 3/31/2016 6:40 AM, tavenui@googlemail.com [amibroker] wrote:

  < o>

Hi,

I want to use this for training, and want to add my logo, most likely a .jpg but could be another to a chart.

Assuming this has can be done.

Can someone point me in the right direction please?

Regards

Paul

 

 


__._,_.___
Posted by: Alan <alan@thenorthams.us>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (6)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
**** 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/


.

__,_._,___
RE: [amibroker] Adding a Logo (.jpg) to a chart

RE: [amibroker] Adding a Logo (.jpg) to a chart

Coolman 17.10 Add Comment
 

Why don't you experiment with this, just replace Name() with whatever text you want.  I think it would be nice if we could sort of white label AB by being able to change the title bar and title bar graphic.

 

 

 

InfoTextFontName                                         = ParamStr( "Font Name", "Arial" );

InfoTextFontSize                                             = Param( "Font Size", 0.15, 0.1, 1.0 , .05 );

OnOff                                                                   = ParamToggle( "Sym In Chart OnOff ", "OFF|ON", 1 );

TextColor                                                            = ParamColor( "Text Color", ColorRGB( 221, 221, 221 ) );

ArrowsToBarYPixelSpacing                          = Param( "Arrow To Bar Y-Axis Spacing", 60, 20, 200, 5 );  //  Distance in Pixels of Plot Arrow from price bar

 

 

 

GfxSetOverlayMode(1);

GfxSelectFont("InfoTextFontName", Status("pxheight")/2 * InfoTextFontSize );

GfxSetTextAlign( 6 );// center alignment

GfxSetTextColor( TextColor );    //

GfxSetBkMode(1); // transparent

GfxTextOut( Name(), (Status("pxwidth")/2) * InfoTextFontSize, (Status("pxheight")/12) * InfoTextFontSize );

 

 

From: amibroker@yahoogroups.com [mailto:amibroker@yahoogroups.com]
Sent: Thursday, March 31, 2016 8:01 PM
To: amibroker@yahoogroups.com
Subject: RE: [amibroker] Adding a Logo (.jpg) to a chart

 

 

Thanks Alan,

 

I am looking for something a little classier.

 

I want the logo insert or as a watermark.

 

Regards

 

Paul

 

From: Alan alan@thenorthams.us [amibroker] [mailto:amibroker@yahoogroups.com]
Sent: Thursday, 31 March 2016 11:20 PM
To: amibroker@yahoogroups.com
Subject: Re: [amibroker] Adding a Logo (.jpg) to a chart

 

 

You can always easily add text to the title line i.e., "TRAINING ONLY".
Just a thought!

Regards,
Alan

On 3/31/2016 6:40 AM, tavenui@googlemail.com [amibroker] wrote:

 

Hi,

I want to use this for training, and want to add my logo, most likely a .jpg but could be another to a chart.

Assuming this has can be done.

Can someone point me in the right direction please?

Regards

Paul

 

 

__._,_.___
Posted by: "Sean ONeill" <ONeillSeanP@verizon.net>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (5)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
**** 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/


.

__,_._,___
RE: [amibroker] Re: Alternatives for Inputting Parameters and Displaying Calculation Output

RE: [amibroker] Re: Alternatives for Inputting Parameters and Displaying Calculation Output

Coolman 17.05 Add Comment
 

Thanks João,

 

That points me in the right direction.

 

Regards

 

Paul

 

From: amibroker@yahoogroups.com [mailto:amibroker@yahoogroups.com]
Sent: Friday, 1 April 2016 9:47 AM
To: amibroker@yahoogroups.com
Subject: Re: [amibroker] Re: Alternatives for Inputting Parameters and Displaying Calculation Output

 

 

I am doing something like this example right now. 

That is my current project but I I got little time and it is taking forever.

 

I never found a complete code but I have learned a lot from the following one.

It has simple functions to draw the buttons.

After that, the code tests if there was a mouse click on the button but this test can also be put inside the function.

So, drawing and testing if it was clicked would get automized by the same function.

 

 

And, there are these other codes from Amibroker.org

 

Search for "Real-Time Control-Panels": http://www.amibroker.org/userkb/

You will find several examples.

 

The ones I liked the most: 

 

 

 

 

2016-03-31 14:20 GMT-03:00 rottor12@yahoo.com [amibroker] <amibroker@yahoogroups.com>:

 

here you have an example of parameters being set via an overlayed panel (which can be minimized/hidden) in Amibroker

 

you can change parameters by arrows and clicking on specific buttons

 

http://www.smartinwestor.pl/wp-content/uploads/2013/04/geometria-ekran-1-%C5%9Brednie.png

 



 

--

Agradeço antecipadamente,

 

----------------------------------------------------------

João Flávio Machado Derzi

+55 (31) 9 9731-4469

 

__._,_.___
Posted by: "Tavenui(AUS)" <tavenui@hotmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (6)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
**** 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/


.

__,_._,___
RE: [amibroker] Adding a Logo (.jpg) to a chart

RE: [amibroker] Adding a Logo (.jpg) to a chart

Coolman 17.00 Add Comment
 

Thanks Alan,

 

I am looking for something a little classier.

 

I want the logo insert or as a watermark.

 

Regards

 

Paul

 

From: Alan alan@thenorthams.us [amibroker] [mailto:amibroker@yahoogroups.com]
Sent: Thursday, 31 March 2016 11:20 PM
To: amibroker@yahoogroups.com
Subject: Re: [amibroker] Adding a Logo (.jpg) to a chart

 

 

You can always easily add text to the title line i.e., "TRAINING ONLY".
Just a thought!

Regards,
Alan

On 3/31/2016 6:40 AM, tavenui@googlemail.com [amibroker] wrote:

 

Hi,

I want to use this for training, and want to add my logo, most likely a .jpg but could be another to a chart.

Assuming this has can be done.

Can someone point me in the right direction please?

Regards

Paul

 

 

__._,_.___
Posted by: "Tavenui(AUS)" <tavenui@hotmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
**** 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/


.

__,_._,___
Re: [amibroker] Re: Alternatives for Inputting Parameters and Displaying Calculation Output

Re: [amibroker] Re: Alternatives for Inputting Parameters and Displaying Calculation Output

Coolman 16.47 Add Comment
 

I am doing something like this example right now. 
That is my current project but I I got little time and it is taking forever.

I never found a complete code but I have learned a lot from the following one.
It has simple functions to draw the buttons.
After that, the code tests if there was a mouse click on the button but this test can also be put inside the function.
So, drawing and testing if it was clicked would get automized by the same function.
http://www.wisestocktrader.com/indicators/3709-button-control-panel


And, there are these other codes from Amibroker.org

Search for "Real-Time Control-Panels": http://www.amibroker.org/userkb/
You will find several examples.

The ones I liked the most: 
http://www.amibroker.org/userkb/2008/03/07/a-basic-message-panel/
http://www.amibroker.org/userkb/2008/03/09/button-header-collapseexpand/




2016-03-31 14:20 GMT-03:00 rottor12@yahoo.com [amibroker] <amibroker@yahoogroups.com>:
 

here you have an example of parameters being set via an overlayed panel (which can be minimized/hidden) in Amibroker

you can change parameters by arrows and clicking on specific buttons

http://www.smartinwestor.pl/wp-content/uploads/2013/04/geometria-ekran-1-%C5%9Brednie.png

 




--
Agradeço antecipadamente,

----------------------------------------------------------
João Flávio Machado Derzi
+55 (31) 9 9731-4469

__._,_.___
Posted by: =?UTF-8?Q?Jo=C3=A3o_Fl=C3=A1vio_Machado_Derzi?= <joaoderzi@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (5)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
**** 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/


.

__,_._,___
Re: [amibroker] Using Double Quotes in odbcGetValueSQL

Re: [amibroker] Using Double Quotes in odbcGetValueSQL

Coolman 16.22 Add Comment
 

Hello,

Thank you very much for your e-mail.

You need to use \"  (backslash and double quote) to encode double quotes, like this:

printf("This is a text in \"double quotes\"");

Best regards,
Tomasz Janeczko
amibroker.com

On 2016-03-31 21:43, meanomalist@yahoo.com [amibroker] wrote:

I want to use the Double quotes in SQL SELECT statment using odbcGetValueSQL function.

query is like: odbcGetValueSQL(" SELECT me from mytable where isin='"+Name()+"'  AND me = ' "  abc  " '   " );


Problem is in WHERE statment    me = ' "  abc  " '

How to use double quotes in such situations?

__._,_.___
Posted by: Tomasz Janeczko <groups@amibroker.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
**** 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/


.

__,_._,___
[amibroker] Using Double Quotes in odbcGetValueSQL

[amibroker] Using Double Quotes in odbcGetValueSQL

Coolman 12.43 Add Comment
 


I want to use the Double quotes in SQL SELECT statment using odbcGetValueSQL function.

query is like: odbcGetValueSQL(" SELECT me from mytable where isin='"+Name()+"'  AND me = ' "  abc  " '   " );


Problem is in WHERE statment    me = ' "  abc  " '

How to use double quotes in such situations?

__._,_.___
Posted by: meanomalist@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
**** 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/


.

__,_._,___
Langganan: Postingan (Atom)

Kategori

Kategori