How do you create those "Best" and "Worst" rows? Are you using AddRow function or AddSummaryRows?
I used AddRow , to create "Best" and "Worst" rows
1 Like
I often run exploration and cut&paste to Excel. If the result exceed 1M rows, then cut&paste to Excel is not possible. 1. Having filter capability in Exploration result, 2. Having relational database capability in Exploration result(just like Excel Pivot table).
But this 1 million rows is EXCEL limit, not AmiBroker. AmiBroker does not have any limits.
Filtering is done by means of Filter variable in AFL. Any GUI-filter would be slower not faster, because GUI is single threaded by limitations of Windows, while AFL is multi-threaded.
1 Like
One item that would be useful is the ability to use AFL code to add a ticker to the RT Window. Similar to the existing ability to add it to a watchlist
CategoryAddSymbol( "", categoryWatchlist, 14 );
For what it is worth, you CAN add symbols to RT window programmatically, by writing to broker.watch file (inside database directory). This file is simple text file. Real-time window contains multiple tabs and each tab has its own list, the format of broker.watch file is simple as follows:
***List 1
AAPL
GOOG
INTC
KO
***List 2
LVLT
MSFT
RSP
***List 3
QQQQ
SPY
And so on.. upto 20 lists. You can use AFL to write to any text file. A database reload is needed to read this file.
On the 3D Optimization chart viewer, can the values be displayed by clicking on the chart at any intersecting coordinates. Put simply, display the two values by clicking on the chart.
1 Like
Ideally, it would be great to be able to add/remove to RT window during intraday trading as signals are generated. This helps with options trading, especially as different strikes go in/out of the money. Reloading the database could be prohibitive
Good point!
I use AB in a QEMU VM and it has some default software emulated graphics card. In the 3D Optimization Chart I don't see the axis numbers at all most of the time and sometimrs just a few values show up at the end of the axis. The chart looks fine, rotates, zooms, etc.
Being able to click on it and have the values printed somewhere would be very good!
Please note that 3D optimization chart uses the most basic OpenGL functions (the oldest and widely supported API, so it should work EVERYWHERE). It does not use shaders or anything. Just the most baseline stuff that was available even in 1997.
In fact it works fine on some ancient notebook with 160MB of RAM (yes 0.16GB) WITHOUT graphic card running Windows 98.
If there is anything wrong with the 3D display, the culprit is GRAPHIC CARD (or its driver).
Unfortunately when you use EMULATOR, you are at the mercy of EMULATOR to properly emulate. Apparently in your case graphic card emulator is NOT working properly.
The only fix is to change the emulator to something that properly implements most basic OpenGL.
Also it is highly discouraged to use emulation at all for high-performance programs like AmiBroker as emulator can easily kill al least 50% of performance (if not more).
1 Like
Hello Dear Tomasz,
For fundamental estimations some users recommended me to use Ami powerful timedata and it worked great! The only thing is that I have to use 3 additional tickers apart from main trade data ticker like so:
each of them stores some basic fundamental data like revenue,net income, debt, assets etc.
It woud be great to have an extended datatype that could store they all in one or at least fundamental data. Currently we have only OHLCV,OI,Aux1,Aux2 that I use.
Thank you.
It would be great to be able to use different time of day filtering in each exploration, perhaps even set by AFL, so that I could run an exploration with different filter than I am using in the charts at the moment. This would also help ensure that the exploration is using the correct filter, e.g. if the code was specifically written to take a trade in the pre-market, AFL could force the filter for that particular exploration.
This may help, could a link to the definition, meaning and use, of the various statistics and titles in the reports be included. When viewing a report, a link to the subject matter would help.
Although I may think I understand "Max. Favorable Excursion %", some reference to how it helps us, what it means, like; 'what if there are many high percent excursions, or only a few, what distribution is favorable and how may it be used?'
The information is amazing and it was put there for a reason. A link to the reason and application could help us all understand how to interpret and best use all that AmiBroker does.
I am sure this information is somewhere, likely already in AmiBroker documentation. Having a link to it would help. Immediate feedback helps eliminate doubts and likely questions.
1 Like
Did you try to HOVER over report item? If you stop moving the mouse OVER the statistics page item like "Max. system drawdown" a TOOLTIP will appear after a second
explaining what the item is.
2 Likes
Hello Tomasz,
to work with floating windows it would be very helpful to increase the sensitivity of the frame border or the frame outer area so that with mouse over/grab on that frame a better handling results when i decide to resize any floating window. On 4K display it is hard to get the focus on that frame to initiate any resizing task...
1 Like
Yes, and that gives the basic function. I was looking for more in-depth information as each metric serves a different purpose.
Web sites like Investopedia? or better, book references, or other references you have used that fill in the gaps of why, an educational resource. You have a reason certain metrics are included in AmiBroker. The link would point to that more comprehensive information.
Most of us value the knowledge imbedded in AmiBroker. I know that knowledge was work, experience, and thought. The link could express the intent and thought behind the description of the pop up.
I believe AmiBroker is a learning experience as well as a tool. I believe you do a good job of separating fact from fiction. Why not have links so your users can also do this.
Perhaps some users here, myself included, would be willing to gather prospective links. It could help a project like this. If you lay the ground rules, I am sure we can help.
Dear Tomasz, my wish list is the following:
- "Individual Optimize Walkforward test", and the respective batch function IndividualOptimizeWalkforward.
I know this would probably be possible in a custom backtest procedure, but I'm not intelligent enough to code this.
- Option for "Non destructive price database". Like a JPEG saved many times, you gradually lose information about what a stock actually was trading for as more and more dividends and splits are added.
I suppose the perfect database would look something like this:
UnadjustedOpen,UnadjustedHigh,UnadjustedLow,UnadjustedClose,UnadjustedVolume,Dividend,Split,UnknownAdjustmentfactor,(TotalAdjustmentfactor or AdjClose), Ignore.
The "UnknownAdjustmentfactor" would be necessary when you import from e.g. Yahoo and don't know if the adjustment is due to a dividend or split. Later you can correct this in Quote Editor. The TotalAdjustmentfactor would be the "sum" of all factors, but AdjClose would be fine as well.
I checked out Tiingo yesterday, and a blend of unadjusted/adjusted data like that would be perfect.
You should be able to easily toggle between unadjusted/adjusted data with for example SetOption().
If this would make backtests etc much slower, you could run a function "Calculate Adjusted Data" or something first, perhaps making a second database.
The "Ignore" would be a toggle (1/0) where data is ignored from charts and tests because of some reason, for example wrong data, spikes.
-
In the Quote Editor, it would be useful to be able to sort on the columns. This would make it faster to remove spikes, data with 0 volume, negative numbers and so on.
-
In the quote editor, data with suspicios data should be color coded, for example data over/under the Detection Threshold in Database Purify compared to the data in the previous or next line. This would save a lot of time trying to find errenous data.
-
In the split-function, you should have the option to see the "greatest" split first, not the first. Sometimes you may have to go through hundres of "small splits" before you come to the big split you need to correct for.
-
More AUX-fields for storing fundamental information, as many as possible really.
Thanks for a great program!
1 Like
Can we have the following feature implemented for the next release. I'm waiting for this to upgrade :D.
Problem: "Sync chart on select" doesn't move chart to the date of scan (when doing historical scans). The date on the chart never changes to the date from the scan.
Proposed solution:
Create a new drop down below the current one in screenshot below titled "Sync chart and date on select"
Expected behaviour:
With this new option the chart updates to the new symbol and the chart shows the exact date of the buy signal. which should be in the middle of the screen so that user can both see historical and future price action.
The ability to save a keyboard shortcuts to more than 1 tool simultaneously. This will open up millions of user customizable configurations
E.g Ctrl+B could simultaneously draw a horizontal line and launch an external script.
So adding a ‘Keep Both’ button next to the reassign button.
A configurable keyboard shortcut for line comment.