[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: Ticker COLUMN display in OTHER than Alphabetical order?



PureBytes Links

Trading Reference Links

Hello,

I am using a Relational Database   to store my exploration results 
and fundamental data.    I am using two powerful Database 
languages   SQL and OLAP for further analysis. 
These languages provide me with the tools to sort or color code the 
exploration  results  any way I like.

It would be very helpful if a relational database structure 
compatible with Access or MySQL could be transparently added to 
AmiBroker. Bidirectional Data transfer between Amibroker `s core 
file structure  and the Database could be done through com 
interfaces. 

This would take away the hassle to export and to re-import data 
manually from one application to the other, in addition it will 
expand the data-storage for fundamental data, watchlists, 
explorations etc.


Regards
Guno 




--- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <amibroker@xxxx> 
wrote:
> Hello,
> 
> I have read this thread and will think about some solution.
> 
> Best regards,
> Tomasz Janeczko
> amibroker.com
>   ----- Original Message ----- 
>   From: mrdavis9 
>   To: amibroker@xxxxxxxxxxxxxxx 
>   Sent: Thursday, August 25, 2005 7:31 PM
>   Subject: Re: [amibroker] Ticker COLUMN display in OTHER than 
Alphabetical order?
> 
> 
>   Dan said>>Taken to its extreme, we don't even need AmiBroker - 
we can do everything AB does with a pencil and paper.
> 
> 
>   Dan, I hope that TJ reads this  post of yours which  so 
accurately describes  some of the limitations we face in using 
watchlists.  
> 
>   I beg to differ with you about using a pencil and paper in lieu 
of Amibroker.  My smoothing codes are so CPU intensive that I will 
be old and dead before I could manually compute even one bar.  
However, your  pencil and paper comment is a great attention 
grabber.    Ron D ('~')
>     ----- Original Message ----- 
>     From: Dan Clark 
>     To: amibroker@xxxxxxxxxxxxxxx 
>     Sent: Thursday, August 25, 2005 11:23 AM
>     Subject: RE: [amibroker] Ticker COLUMN display in OTHER than 
Alphabetical order?
> 
> 
>     Tomasz,
> 
>      
> 
>     This is an AB enhancement that I would like to see - enhanced 
Watchlist (and Exploration) functionality.   
> 
>      
> 
>     The problem is that exporting data to another application 
reduces or eliminates AB's added-value.  Data in another app is just 
dumb data.   You have to build analysis tools in that app to crunch 
the data further.  In many cases, you then need to import the data 
back into AB.   At minimum, this is a major pain.   Many times, it 
is not logistically feasible.
> 
>      
> 
>     Exploration or Scan data in AB has massive added value.   
Color coding and sorting Exploration results provide meaning and 
highlight key points in the raw data.   That's great, but there is 
no place to store the data!  
> 
>      
> 
>     Loading Exploration data to a Watchlist eliminates almost all 
of its meaning.  Exporting data to another app like Excel allows you 
to sort it.  To analyze further, you have to create Excel 
formulas.   And what happens when you want to see details such as a 
symbol's chart or the symbol sector's chart?    You have to manually 
enter the symbol in AB or import data back into AB.  Yes, you CAN do 
it.  But the process is a hassle and you quickly stop.   (I've been 
there, done that!)    
> 
>      
> 
>     Taken to its extreme, we don't even need AmiBroker - we can do 
everything AB does with a pencil and paper.  So why use AB?  
Obviously because it's way easier and faster! 
> 
>      
> 
>     IMO, AB is the most advanced financial analysis/charting 
system available.  Its analytical engine is second to none - fast, 
powerful and extensible.  But.  
> 
>      
> 
>     AB's analytical engine has outstripped AB's ability to display 
and manage result data.  External tools can be developed, but this 
is core functionality.  We need the native ability to display, sort 
and save Exploration results to a more usable "data bucket". 
> 
>      
> 
>     My guess is that enhancing Watchlists (or creating a new 
structure) would require modifying data structures and would be a 
major effort.  However, for many of us this is a critical 
enhancement.
> 
>      
> 
>     Thanks and regards,
> 
>      
> 
>     Dan.
> 
>      
> 
> 
> -------------------------------------------------------------------
---------
> 
>     From: amibroker@xxxxxxxxxxxxxxx 
[mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Tomasz Janeczko
>     Sent: Wednesday, August 24, 2005 11:48 PM
>     To: amibroker@xxxxxxxxxxxxxxx
>     Subject: Re: [amibroker] Ticker COLUMN display in OTHER than 
Alphabetical order?
> 
>      
> 
>     Click on the OTHER column's header and press "EXPORT" button - 
this way
>     you can create text file with other order.
>     Internally in AB all lists are inherently sorted (becaue watch 
lists are
>     just bits/flags in always-sorted symbol record table) and you 
can't change his.
> 
>     Best regards,
>     Tomasz Janeczko
>     amibroker.com
>     ----- Original Message ----- 
>     From: "Hal Brehe" <hcbre@xxxx>
>     To: <amibroker@xxxxxxxxxxxxxxx>
>     Sent: Thursday, August 25, 2005 7:15 AM
>     Subject: [amibroker] Ticker COLUMN display in OTHER than 
Alphabetical order?
> 
> 
>     >
>     > Hi All,
>     >
>     > Is ANYONE aware of a method, sequence or process that would 
allow one to
>     > place TICKERS into a Watch List in anything other than their 
Alphabetical
>     > order.
>     >
>     > I would like to copy results from Automatic Analysis 
according to a column
>     > OTHER than the Ticker Column.
>     > This would allow one to sort on a column whose rank in the 
sort made it
>     > the  "Best Performer", and carry the order of that sort 
intact over to a
>     > watch list.
>     >
>     > Any work-around that would result in retaining that same 
sequence into a
>     > watch list, would be appreciated.
>     >
>     > Regards,
>     >
>     > Hal
>     >
>     >
>     > -- 
>     > No virus found in this outgoing message.
>     > Checked by AVG Anti-Virus.
>     > Version: 7.0.344 / Virus Database: 267.10.15/80 - Release 
Date: 08/23/2005
>     >
>     >
>     >
>     >
>     >
>     > Please note that this group is for discussion between users 
only.
>     >
>     > To get support from AmiBroker please send an e-mail directly 
to
>     > SUPPORT {at} amibroker.com
>     >
>     > For other support material please check also:
>     > http://www.amibroker.com/support.html
>     >
>     >
>     > Yahoo! Groups Links
>     >
>     >
>     >
>     >
>     >
>     >
>     > 
> 
> 
> 
> 
> 
> 
>   Please note that this group is for discussion between users only.
> 
>   To get support from AmiBroker please send an e-mail directly to 
>   SUPPORT {at} amibroker.com
> 
>   For other support material please check also:
>   http://www.amibroker.com/support.html
> 
> 
> 
> 
> 
>   SPONSORED LINKS Investment management software  Investment 
property software  Investment software  
>         Investment tracking software  Return on investment 
software  Stock investment software  
> 
> 
> -------------------------------------------------------------------
-----------
>   YAHOO! GROUPS LINKS 
> 
>     a..  Visit your group "amibroker" on the web.
>       
>     b..  To unsubscribe from this group, send an email to:
>      amibroker-unsubscribe@xxxxxxxxxxxxxxx
>       
>     c..  Your use of Yahoo! Groups is subject to the Yahoo! Terms 
of Service. 
> 
> 
> -------------------------------------------------------------------
-----------





------------------------ Yahoo! Groups Sponsor --------------------~--> 
<font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h5ivobp/M=362131.6882500.7825259.1493532/D=groups/S=1705632198:TM/Y=YAHOO/EXP=1125017426/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~-> 

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For other support material please check also:
http://www.amibroker.com/support.html

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> 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/