Re: [amibroker-ts] Is anyone using Amibroker to trade Forex using Automatic Trade execution?
Sorry... I mean excellent for trading currency (not futures) pairs - Original Message - From: cstrader To: amibroker-ts@yahoogroups.com Sent: Monday, April 02, 2007 7:50 AM Subject: Re: [amibroker-ts] Is anyone using Amibroker to trade Forex using Automatic Trade execution? But you can trade the pairs too.. in fact IB is excellent for trading futures pairs. What kinds of programs are you looking for? - Original Message - From: Ara Kaloustian To: amibroker-ts@yahoogroups.com Sent: Sunday, April 01, 2007 8:02 PM Subject: Re: [amibroker-ts] Is anyone using Amibroker to trade Forex using Automatic Trade execution? How about currency futures with Interactive Brokers. Amibroker autoexecute is comatible with IB - Original Message - From: Padhu [EMAIL PROTECTED] To: amibroker-ts@yahoogroups.com; amibroker-afl@yahoogroups.com Sent: Sunday, April 01, 2007 4:56 PM Subject: [amibroker-ts] Is anyone using Amibroker to trade Forex using Automatic Trade execution? Hello, I would like to know if anyone is using amibroker to autotrade Forex?. I haven't seen any clear answers. Worstcase is anyone aware of any FX platforms that integrate well with Amibroker for autoexecution. Finally are there individuals willing to code the automatic execution logic for a fee if integration capability exists in Amibroker?. Thanks. Cheers,Padhu [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[amibroker-ts] Help having problems with barssince
I am trying to get Amibroker to count the number of days since the last lowest level for the value ewosc in the last 60 days. The following code will post todays value and it will give me the highest and the lowest but it will not calculate the number of bars since the lowest value occured prior to today, it will only return a count of 0.00 any Ideas on how to get this to generate barssince would be greatly appreciated. Cond1 = Close 1.00 AND Close 10.00; tod = EMA(Close,5); tod1 = EMA(Close,35); today = tod-tod1; Hv = HHV(today,60); Lv = LLV(today,60); lbar = BarsSince(Lv); filter = buy; buy = cond1; addcolumn(close,close); addcolumn(volume, volume); addcolumn(hv,Hv); addcolumn(lv,Lv); addcolumn(lbar,lbar);
[amibroker-ts] Re: System optimization philosophy?
Hello Brian Siddha, Since money management seems to have more statistical importance for making profits than buy/sell signals. Don't you believe it! In the beginning was the signal. On the first day, God said,*Let's evaluate* and saw that it was good. On the second day, God looked in his/her wallet/purse and said,*Now how much shall I put on?* etc. MeBrianB2 O:-) --- In amibroker-ts@yahoogroups.com, Brian [EMAIL PROTECTED] wrote: Interesting replies. Thanks! Since money management seems to have more statistical importance for making profits than buy/sell signals, does it then make sense that the optimization focus should be primarily on money management? And then (secondarily) optimizing the remainder of the system around the money management (stops, scaling in/out, etc.) portion of the system? For example, I first develop a mildly optimized basic buy/sell system. I then integrate money management into the system and then optimize the money management portion. Only after that do I then optimize the remainder of the system. Does this make sense in your experience, from a statistical analysis standpoint? Or is this a matter of simply using something like IO (which I am still learning how to use -- does more comprehensive documentation exist somewhere??) since it tests all dynamic variables at one time? Since I am not yet up and running with IO, these questions may have more importance to me than otherwise. My main problem with IO right now is how to get it to use all symbols, and not just a single symbol, for testing. No matter how I set things, it seems, it always seems to default to the current symbol. Is there a solution? Thanks again, in advance! ~Bman --- In amibroker-ts@yahoogroups.com, schubie728 schubie@ wrote: Emotion is a big factor in trading, but I think you're more likely to weather the mental storms with the anchor of a well-tested and thought-through system than allowing yourself to be buffetted by the psychological winds driven by CNBC. Livermore was plainly more of a plunger than a disciplined speculator. Good money management will prevent absolute financial destruction. He needed to implement stop losses and 'invest' only a portion of his bankroll at a time. - Sean
[amibroker-ts] Re: Is anyone using Amibroker to trade Forex using Automatic Trade execution?
Hi Padhu, i haven't yet got there but i'm in the process, through Interactive Brokers. You should be able to trade on IB's IdealPro platform. Minimum trade amount is 20,000. From what I can see up to now (been a week in development) Amibroker is recognising a trade done through IdealPro as a regular position, so I can't see any problems up to now. Best regards, Claude --- In amibroker-ts@yahoogroups.com, Padhu [EMAIL PROTECTED] wrote: Hello, I would like to know if anyone is using amibroker to autotrade Forex?. I haven't seen any clear answers. Worstcase is anyone aware of any FX platforms that integrate well with Amibroker for autoexecution. Finally are there individuals willing to code the automatic execution logic for a fee if integration capability exists in Amibroker?. Thanks. Cheers,Padhu [Non-text portions of this message have been removed]
Re: [amibroker-ts] Help having problems with barssince
You have to specify a true condition for the array: BarsSince(Lv == today); Bill - Original Message - From: rtoutaint To: amibroker-ts@yahoogroups.com Sent: Monday, April 02, 2007 1:18 PM Subject: [amibroker-ts] Help having problems with barssince I am trying to get Amibroker to count the number of days since the last lowest level for the value ewosc in the last 60 days. The following code will post todays value and it will give me the highest and the lowest but it will not calculate the number of bars since the lowest value occured prior to today, it will only return a count of 0.00 any Ideas on how to get this to generate barssince would be greatly appreciated. Cond1 = Close 1.00 AND Close 10.00; tod = EMA(Close,5); tod1 = EMA(Close,35); today = tod-tod1; Hv = HHV(today,60); Lv = LLV(today,60); lbar = BarsSince(Lv); filter = buy; buy = cond1; addcolumn(close,close); addcolumn(volume, volume); addcolumn(hv,Hv); addcolumn(lv,Lv); addcolumn(lbar,lbar); -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.18/734 - Release Date: 3/26/2007 2:31 PM [Non-text portions of this message have been removed]
Re: [amibroker-ts] Help having problems with barssince
The code looks OK, but you are using Buy before it is defined. You should be getting an error for that - Original Message - From: rtoutaint [EMAIL PROTECTED] To: amibroker-ts@yahoogroups.com Sent: Monday, March 26, 2007 10:18 AM Subject: [amibroker-ts] Help having problems with barssince I am trying to get Amibroker to count the number of days since the last lowest level for the value ewosc in the last 60 days. The following code will post todays value and it will give me the highest and the lowest but it will not calculate the number of bars since the lowest value occured prior to today, it will only return a count of 0.00 any Ideas on how to get this to generate barssince would be greatly appreciated. Cond1 = Close 1.00 AND Close 10.00; tod = EMA(Close,5); tod1 = EMA(Close,35); today = tod-tod1; Hv = HHV(today,60); Lv = LLV(today,60); lbar = BarsSince(Lv); filter = buy; buy = cond1; addcolumn(close,close); addcolumn(volume, volume); addcolumn(hv,Hv); addcolumn(lv,Lv); addcolumn(lbar,lbar); Yahoo! Groups Links
Re: Possible virus - beware, was: Re: [amibroker] My heart aches, and a drowsy numbness pains
That was my first impression also. But after checking for Virus Alert I got nothing. So ... Ton. - Original Message - From: Tomasz Janeczko To: amibroker@yahoogroups.com Sent: Sunday, April 01, 2007 5:52 PM Subject: Possible virus - beware, was: Re: [amibroker] My heart aches, and a drowsy numbness pains Possible virus - beware. - Original Message - From: Gerard Carey [EMAIL PROTECTED] To: AB Yahoo group amibroker@yahoogroups.com Sent: Sunday, April 01, 2007 4:21 PM Subject: [amibroker] My heart aches, and a drowsy numbness pains My heart aches, and a drowsy numbness pains My sense, as though of hemlock I had drunk Not only that, but she in whose company I spent last evening, in enjoyment of food, wine, dance, good company and friendly laughter, today seems barely able to stand my presence. Life shouldn't be like this. I'll away to my screen and forage amongst prior posts for gems of original thought. To spare the uninterested I'll continue on in the attachment - and stick it into the 'Files' area for those who can't access attachments. Regds everyone and good trading, Gerard pologies to Keats -- http://www.fastmail.fm - Access all of your messages and folders wherever you are 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ For other support material please check also: http://www.amibroker.com/support.html Yahoo! Groups Links
[amibroker] Re: Vector-based (variable) interest rate
This is simple enough to do already by switching to a money market fund on sells / covers. As far as constant dollar or inflation related results go this can be dealt with if desired using the available CPI data which are available back at least as far as the 1800's. --- In amibroker@yahoogroups.com, whitneybroach [EMAIL PROTECTED] wrote: Your feedback is welcome about this suggestion for a vector-based interest rate feature in AFL: http://www.amibroker.com/feedback/view_bug.php?bug_id=944. The longer the backtest or the more cash a system holds, the more pertinent the difference in interest payments. The suggestion doesn't mention this, but a related feature might be an inflation vector as well for reporting real (vs nominal) test results. Best regards, Whitney
RE: [amibroker] Referencing an indicator in a foreign chart?
You need to use SetForeign(^DJI); -Original Message- From: amibroker@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of blakerandy Sent: Sunday, April 01, 2007 7:38 PM To: amibroker@yahoogroups.com Subject: [amibroker] Referencing an indicator in a foreign chart? Hi all, I'm trying to use the value of an indicator (DMI value for Dow Jones Industrials)in a system formula for confirmation of market direction. I know I need to use the foreign function but I can't seem to get it to reference the DMI value. Any suggestions? Code: EMALong=EMA(Close,21); EMAShort=EMA(Close,8); TSA=ATR(14); PS=ROC(Close,14); ADXOk =ADX()20 AND ADX()50; OKVol = Volume10 ; PriceOK = Close =10; DMI=PDI(10)-MDI(10); MarketUp = DMI=Foreign(^DJI,close); MarketDn = DMI=Foreign(^DJI,close); SetUpL = Cross(EMAShort ,EMALong) AND C= EMAShort AND MarketUp0; SetUpS = Cross(EMALong,EMAShort) AND C=EMAShort AND MarketDn 0; Thanks, Randy 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ For other support material please check also: http://www.amibroker.com/support.html Yahoo! Groups Links
[amibroker] Re: HELP! Save Quotetracker data in AB local database
I'm having a similar problem, although I'm using the IB plugin for backfill: I have created a database with local data storage enabled. Adding a symbol to the database, I set the plugin to get 30 day 1-min backfill. So, after having pulled down the 30 days of data this should be stored locally. Save database and close AB. Load up AB again, but change the plugin backfill to 1 day. Then, when selecting the symbol only 1 day of data is shown - backfilled from IB. Shouldn't this be pulled from the locally stored database? Best Regards, Henning --- In amibroker@yahoogroups.com, Tomasz Janeczko [EMAIL PROTECTED] wrote: File-Database Settings: Local data storage : ENABLED Best regards, Tomasz Janeczko amibroker.com - Original Message - From: w_hau [EMAIL PROTECTED] To: amibroker@yahoogroups.com Sent: Saturday, March 24, 2007 12:30 PM Subject: [amibroker] HELP! Save Quotetracker data in AB local database Hi, I'm Amibroker and Quotetracker registered User. I've setup AB to use with QT. Backfilled around 600 Symbols for 10 days, all loaded up correctly in AB. The problem is when i closed Quotetracker, many of AB symbols data would be gone. How can I save these symbols data into AB local database so that I can view them without running QuoteTracker? If i select one symbol in AB while running QT. Press save, it would save that symbol data into AB database. But how can I save all the symbols data into AB database? I've tried Save Database, Save All, that doesn't work. Is that a setting or trick to save the data? HELP HELP HELP Please! William 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ For other support material please check also: http://www.amibroker.com/support.html Yahoo! Groups Links
[amibroker] Large Correlation Matrix
I'm trying to find top 100 positive/negative correlation pairs out of 3000 x 3000 correlation matrix. How do I change the script to produce 9 million rows of ( ticker1, ticker2, correlation ) so that I can just click to sort in AA result window ? WatchlistNum = 32; SetOption( NoDefaultColumns, True ); Filter = Status( LastBarInTest ); list = GetCategorySymbols( categoryWatchlist, WatchlistNum ); AddTextColumn( Name(), Correlation, 1.0 ); Ticker1= Name(); for( Col=0; ( Ticker2 = StrExtract( List, Col ) ) != ; Col++ ) { Var2 = Foreign( Ticker2, Close ); Corr = Correlation( Close, Var2, 20 ); AddColumn( Corr, Ticker2, 1.6 ); }
[amibroker] create custom weighted index
Hi, hope you could help me in creating my own custom index. I have 8 stocks that I would like to include in the index, and each of the stocks have their own weighting in the index; O= (Open of A * 42) + (Open of B * 60) + (Open of C * 231 ETC...) H= (High of A * 42) + (High of B * 60) + (High of C * 231 ETC...) L= (Low of A * 42) + (Low of B * 60) + (Low of C * 231 ETC...) C= (Close of A * 42) + (Close of B * 60) + (Close of C * 231 ETC...) V= Volume added together Is there any smooth way to create this with the weightings? I have found the following info: A sample formula could look like this: Code: AddToComposite(C,~myindex, C); AddToComposite(H,~myindex, H); AddToComposite(L,~myindex, L); AddToComposite(O,~myindex, O); AddToComposite(V,~myindex, V); You would need to copy this formula into Automatic Analysis window. Click on Filter - choose appropriate category you want to calculate index from, then click OK. Now click SCAN. Then choose View-Refresh All menu. In the ticker tree you will see ~myindex ticker.
[amibroker] Re: AIQ Data files
Do all maintenance in AIQ (splits, symbol changes, etc.) and then import Everything to AB, so that the changes will get overwritten. AB Importer is very fast, probably much faster than DTU (I haven't used AIQ for a while so I don't really know). Even if you have a few thousand tickers it will just take a few minutes each evening. --- In amibroker@yahoogroups.com, tipequity [EMAIL PROTECTED] wrote: I was hoping for a way of directly accessing AIQ's data files. So I won't have to maintain two sets of databases. --- In amibroker@yahoogroups.com, Lester Vanhoff ebsn247lsm@ wrote: The only way I see it is to use AIQ's DTU to export data to ASCii file (s) and then import that to AB using the Importer: http://www.amibroker.com/guide/d_ascii.html Lester --- In amibroker@yahoogroups.com, tipequity l3456@ wrote: Does anybody use AIQ's data files with Amibroker? If so how?
[amibroker] Re: AIQ Data files
I forgot to add that the only maintenance needed in AB (once a week, month, etc.) would be to run a script to delete non-trading tickers. Script example can be found in Scripts folder: Cleanup.js Lester --- In amibroker@yahoogroups.com, Lester Vanhoff [EMAIL PROTECTED] wrote: Do all maintenance in AIQ (splits, symbol changes, etc.) and then import Everything to AB, so that the changes will get overwritten. AB Importer is very fast, probably much faster than DTU (I haven't used AIQ for a while so I don't really know). Even if you have a few thousand tickers it will just take a few minutes each evening.
[amibroker] Re: IB Controller - getting order info
Hi Herman, My apologies if this was off-topic on this list. Happy to move it to the amibroker-at list. Best regards, Claude
Re: [amibroker] Re: data tooltips help
Never found a way. Checkout http://www.amibroker.com/feedback/view_bug.php?bug_id=104 Lester Vanhoff wrote: Use ToolTip reserved variable. I don't know if there is a way to remove default Date and Value from ToolTip: /*** START ***/ Title = \\c25+Name()+ \\c11 +Interval(2)+ +Date()+ \\c34 +FullName()+ \\c-1 O=+O+ H=+H+ L=+L+ C=+C+ V=+V; t_t =ToolTip=O = +O+ \n+ToolTip=H = +H+ \n+ToolTip=L = +L+ \n+ToolTip=C = +C+ \n\n+ToolTip=V = +NumToStr(V,1.0); Plot(C, t_t, 26, 64); SetChartOptions(0, chartShowDates); /*** END ***/ --- In amibroker@yahoogroups.com, James [EMAIL PROTECTED] wrote: I have the same price chart in sheet 1 and sheet 2. (Different indicators and systems, but same price chart and volume.) In the first sheet, tooltips window gives me Date Time, Value:, Open:, High:, Low:, Close:, Volume:, Open Int:., Colse =, Volume() = Second sheet gives me Date Time, Value:, Close:, EMA(Close,30) Cannot see any indication how to control this within the formula. How do I control what is displyed in the tooltips window? TIA, James 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ For other support material please check also: http://www.amibroker.com/support.html Yahoo! Groups Links
[amibroker] OT: Need technical advice with a Web page
Can someone explain to me exactly how they have (below) encoded a requirement for me to communicate with their computer to simply perform a copy operation from my clipboard to my application? Is there any way around this? At the following link: (if you have a Japanese capable browser) http://www.tse.or.jp/market/STATISTICS/06.html you can find the 33 TSE industry groups, how they closed both the morning and afternoon sessions. For years, I have been quickly copying and pasting this data into a .csv file that I then import to AB. I copy all four columns, then paste into Excel, then copy only the closing value column from inside Excel, and paste it over the other three columns. (Something about the table prevents copying of individual columns, but I easily put up with the tiny extra bit of work.) This gives me a line chart in AB by the way, because OHLC are then the same. Over the weekend, however, they have apparently revamped this site. I can copy just like I used to, but when I paste, I am alerted by my firewall that my computer wants to connect, repeatedly, to some TSE computer (as well as to localhost). Since I never had to do this before, I tried blocking it via the firewall, but it just freezes Excel if I do that. Finally, I allowed it, and it works *almost* like before. I even tried e-mailing myself a copy of the page, but even though it's being opened as a temp file by my mail client, I still get the pop ups from the firewall when I try to paste the data into Excel. I have never had this experience before. Very annoying. Yuki
[amibroker] Re: OT: Need technical advice with a Web page
It usually do this by saving the webpage (HTML only) and then open the .htm file in excel. Works well also with your page, but you need some cleaning up (row/column delete etc), you could run a simple macro for that. -treliff --- In amibroker@yahoogroups.com, Yuki Taga [EMAIL PROTECTED] wrote: Can someone explain to me exactly how they have (below) encoded a requirement for me to communicate with their computer to simply perform a copy operation from my clipboard to my application? Is there any way around this? At the following link: (if you have a Japanese capable browser) http://www.tse.or.jp/market/STATISTICS/06.html you can find the 33 TSE industry groups, how they closed both the morning and afternoon sessions. For years, I have been quickly copying and pasting this data into a .csv file that I then import to AB. I copy all four columns, then paste into Excel, then copy only the closing value column from inside Excel, and paste it over the other three columns. (Something about the table prevents copying of individual columns, but I easily put up with the tiny extra bit of work.) This gives me a line chart in AB by the way, because OHLC are then the same. Over the weekend, however, they have apparently revamped this site. I can copy just like I used to, but when I paste, I am alerted by my firewall that my computer wants to connect, repeatedly, to some TSE computer (as well as to localhost). Since I never had to do this before, I tried blocking it via the firewall, but it just freezes Excel if I do that. Finally, I allowed it, and it works *almost* like before. I even tried e-mailing myself a copy of the page, but even though it's being opened as a temp file by my mail client, I still get the pop ups from the firewall when I try to paste the data into Excel. I have never had this experience before. Very annoying. Yuki
Re: [amibroker] OT: Need technical advice with a Web page
Hi Yuki -- I can copy those four columns, select a cell in Excel, paste the data using the Paste Special - Text command, and the data is ready to use in Excel. It sounds like there is a new firewall complaining. Did something change in your computer? Or in the Internet Service Provider? Or do I not understand the problem? Thanks, Howard On 02 Apr 2007 04:02:09 -0700, Yuki Taga [EMAIL PROTECTED] wrote: Can someone explain to me exactly how they have (below) encoded a requirement for me to communicate with their computer to simply perform a copy operation from my clipboard to my application? Is there any way around this? At the following link: (if you have a Japanese capable browser) http://www.tse.or.jp/market/STATISTICS/06.html you can find the 33 TSE industry groups, how they closed both the morning and afternoon sessions. For years, I have been quickly copying and pasting this data into a .csv file that I then import to AB. I copy all four columns, then paste into Excel, then copy only the closing value column from inside Excel, and paste it over the other three columns. (Something about the table prevents copying of individual columns, but I easily put up with the tiny extra bit of work.) This gives me a line chart in AB by the way, because OHLC are then the same. Over the weekend, however, they have apparently revamped this site. I can copy just like I used to, but when I paste, I am alerted by my firewall that my computer wants to connect, repeatedly, to some TSE computer (as well as to localhost). Since I never had to do this before, I tried blocking it via the firewall, but it just freezes Excel if I do that. Finally, I allowed it, and it works *almost* like before. I even tried e-mailing myself a copy of the page, but even though it's being opened as a temp file by my mail client, I still get the pop ups from the firewall when I try to paste the data into Excel. I have never had this experience before. Very annoying. Yuki
Re: [amibroker] Re: OT: Need technical advice with a Web page
That works, thanks. Do you get a warning box after the file-open request complaining about two missing .css files? I do, but the file opens anyway, and I'm able to copy the one single column I want anyway to the clipbord, and paste it with no problems. Disadvantage: The old way, I could paste directly into the target .csv file, then copy one column and paste it to four columns. But with this method (from one htm file to the target .csv file) I cannot paste all four columns at once, but first have to do one, then paste over the others. I still want to know why my clipboard is calling www.tse.or.jp for a paste command into an Excel .csv file. I've been doing this with various sites for years, including sites where I had to use the Paste Special - Text operation. I've never had an outbound connection alert on something like this -- ever. Best, Yuki Monday, April 2, 2007, 9:20:34 PM, you wrote: t It usually do this by saving the webpage (HTML only) and then open t the .htm file in excel. Works well also with your page, but you need t some cleaning up (row/column delete etc), you could run a simple t macro for that. t -treliff t --- In amibroker@yahoogroups.com, Yuki Taga [EMAIL PROTECTED] wrote: Can someone explain to me exactly how they have (below) encoded a requirement for me to communicate with their computer to simply perform a copy operation from my clipboard to my application? Is there any way around this? At the following link: (if you have a Japanese capable browser) http://www.tse.or.jp/market/STATISTICS/06.html you can find the 33 TSE industry groups, how they closed both the morning and afternoon sessions. For years, I have been quickly copying and pasting this data into a .csv file that I then import to AB. I copy all four columns, then paste into Excel, then copy only the closing value column from t inside Excel, and paste it over the other three columns. (Something about the table prevents copying of individual columns, but I easily put t up with the tiny extra bit of work.) This gives me a line chart in AB by the way, because OHLC are then the same. Over the weekend, however, they have apparently revamped this site. t I can copy just like I used to, but when I paste, I am alerted by my firewall that my computer wants to connect, repeatedly, to some TSE computer (as well as to localhost). Since I never had to do this before, I tried blocking it via the firewall, but it just freezes Excel if I do that. Finally, I t allowed it, and it works *almost* like before. I even tried e-mailing myself a copy of the page, but even though it's being opened as a temp file by my mail client, I still get the pop ups from the firewall when I try to paste the data into Excel. t I have never had this experience before. Very annoying. Yuki Best, Yuki
[amibroker] OT: Esignal no longer offers the Basic Subscription
I got this info from Esignal. Although they will continue with existing basic subscriptions. that means new subscribers will need to subscribe to the Premier plan which is $30 more a month for not really much more. (I think its 500 symbols) as compared to the 200 limit. but AB does very well with 200. Anybody knows Whats happening there?
Re: [amibroker] OT: Need technical advice with a Web page
Hi Howard, The fiscal year ended in Japan (for most companies) on March 31. So there are a lot of changes that usually surprise us on April 1. ^_^ For years, I have had no trouble copying this data and pasting it, selecting a single cell in the file I want to copy to, getting a four-column-wide copy, which I then quickly adjust to suit. No problems, until today. But the TSE site was extensively redone over the weekend. Tonight, I cannot do as you say you can do (which baffles me, for sure). I did try the Paste-Special - Text before posting my first note. I get all the rows that way, but no columns -- all four fields come out as a single column, which then makes separation of the numerical data (all I want) all but impossible. Absolutely nothing new on the box. This is a working box, not a toy, so I don't tinker with anything unless I absolutely have to, and of course I have a backup ready at all times in that case. When I try the regular Paste command, that gets the job done, but apparently it is calling the TSE for a .css file that puts some special formatting in the Excel file, formatting that I discard anyway, because I save as .csv, which will not accept certain types of special formatting. There are something in the neighborhood of TEN or ELEVEN connection requests going out. The first and third are definitely identified by the firewall (Kerio Personal latest) as www.tse.or.jp. They are both HTTP (Port 80). The rest are all localhost requests to okay port 1657. And Kerio pretty much stuffs my machine if I reject the connection requests. I have never, ever, come across anything like this before. I have found a workaround however ... and that is simply to disable all traffic via the firewall, before pasting. There is a delay of a very few seconds, which I never had to put up with before, but nothing hangs, as it does if I try to refuse each connection request as it comes up from the firewall. But I find it extremely strange that you can apparently do this without needing to fight anything. I suppose I could make a permanent rule for these, but I'm wondering what the heck is going on. Best, Yuki Monday, April 2, 2007, 9:24:13 PM, you wrote: HB Hi Yuki -- HB I can copy those four columns, select a cell in Excel, paste the data using HB the Paste Special - Text command, and the data is ready to use in Excel. HB It sounds like there is a new firewall complaining. HB Did something change in your computer? Or in the Internet Service Provider? HB Or do I not understand the problem? HB Thanks, HB Howard HB On 02 Apr 2007 04:02:09 -0700, Yuki Taga [EMAIL PROTECTED] wrote: Can someone explain to me exactly how they have (below) encoded a requirement for me to communicate with their computer to simply perform a copy operation from my clipboard to my application? Is there any way around this? At the following link: (if you have a Japanese capable browser) http://www.tse.or.jp/market/STATISTICS/06.html you can find the 33 TSE industry groups, how they closed both the morning and afternoon sessions. For years, I have been quickly copying and pasting this data into a .csv file that I then import to AB. I copy all four columns, then paste into Excel, then copy only the closing value column from inside Excel, and paste it over the other three columns. (Something about the table prevents copying of individual columns, but I easily put up with the tiny extra bit of work.) This gives me a line chart in AB by the way, because OHLC are then the same. Over the weekend, however, they have apparently revamped this site. I can copy just like I used to, but when I paste, I am alerted by my firewall that my computer wants to connect, repeatedly, to some TSE computer (as well as to localhost). Since I never had to do this before, I tried blocking it via the firewall, but it just freezes Excel if I do that. Finally, I allowed it, and it works *almost* like before. I even tried e-mailing myself a copy of the page, but even though it's being opened as a temp file by my mail client, I still get the pop ups from the firewall when I try to paste the data into Excel. I have never had this experience before. Very annoying.
[amibroker] Re: OT: Need technical advice with a Web page
Yes, you can safely ignore the warning box (click OK). Can't help you re. the firewall. I do get the same firewall notice and when I deny connection it still pastes indeed. If you can write some VBA you could automate and speed up all your copy/paste activities. Tha's what I do with various web data I collect: - save the webpage - open in XL - run my one-click macro to process/copy/paste anything anywhere I want in the blink of an eye. You can also suppress any warning boxes etc. In case you're not familiar you can start with Tools - Macro - Record New Macro to record your routine and work from there. If these are daily routines then that's definitely worth looking into. -treliff --- In amibroker@yahoogroups.com, Yuki Taga [EMAIL PROTECTED] wrote: That works, thanks. Do you get a warning box after the file-open request complaining about two missing .css files? I do, but the file opens anyway, and I'm able to copy the one single column I want anyway to the clipbord, and paste it with no problems. Disadvantage: The old way, I could paste directly into the target .csv file, then copy one column and paste it to four columns. But with this method (from one htm file to the target .csv file) I cannot paste all four columns at once, but first have to do one, then paste over the others. I still want to know why my clipboard is calling www.tse.or.jp for a paste command into an Excel .csv file. I've been doing this with various sites for years, including sites where I had to use the Paste Special - Text operation. I've never had an outbound connection alert on something like this -- ever. Best, Yuki Monday, April 2, 2007, 9:20:34 PM, you wrote: t It usually do this by saving the webpage (HTML only) and then open t the .htm file in excel. Works well also with your page, but you need t some cleaning up (row/column delete etc), you could run a simple t macro for that. t -treliff t --- In amibroker@yahoogroups.com, Yuki Taga yukitaga@ wrote: Can someone explain to me exactly how they have (below) encoded a requirement for me to communicate with their computer to simply perform a copy operation from my clipboard to my application? Is there any way around this? At the following link: (if you have a Japanese capable browser) http://www.tse.or.jp/market/STATISTICS/06.html you can find the 33 TSE industry groups, how they closed both the morning and afternoon sessions. For years, I have been quickly copying and pasting this data into a .csv file that I then import to AB. I copy all four columns, then paste into Excel, then copy only the closing value column from t inside Excel, and paste it over the other three columns. (Something about the table prevents copying of individual columns, but I easily put t up with the tiny extra bit of work.) This gives me a line chart in AB by the way, because OHLC are then the same. Over the weekend, however, they have apparently revamped this site. t I can copy just like I used to, but when I paste, I am alerted by my firewall that my computer wants to connect, repeatedly, to some TSE computer (as well as to localhost). Since I never had to do this before, I tried blocking it via the firewall, but it just freezes Excel if I do that. Finally, I t allowed it, and it works *almost* like before. I even tried e-mailing myself a copy of the page, but even though it's being opened as a temp file by my mail client, I still get the pop ups from the firewall when I try to paste the data into Excel. t I have never had this experience before. Very annoying. Yuki Best, Yuki
Re: [amibroker] OT: Need technical advice with a Web page
I have a free open-source add-in that can grab that information for you. The add-in, documentation on its functions, and sample templates can be found in the files area of this Yahoo group: http://finance.groups.yahoo.com/group/smf_addin/ For example, one function allows you to grab table cells on a webpage. I used this formula on the English version of that page to grab each element of the table: =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html ,G$12,bt_print.gif$F13) ...where G$12 is a cell I was referring to to tell it which column of the table to pick up and $F13 is a cell I was referring to to tell it which row of the table to pick up. The bt_print.gif is just a string it searches for on the page to position itself before it starts looking for the nth table row on the page. The end result, using row numbers from 1 to 34 and columns numbers from 1 to 4 for each row, was: IndustryIndexChange Fishery, Agriculture Forestry444.57-5.56-1.2% Mining 760.42-11.67-1.5% Construction783.39-18.74-2.3% Foods1176.344.50.4% Textiles Apparels779.08-15.86-2.0% Pulp Paper603.31-11.01-1.8% Chemicals1331.15- 28.12-2.1% Pharmaceutical2194.61-21.49-1.0% Oil Coal Products1695.65-36.23 -2.1% Rubber Products1926.38-18.37-0.9% Glass Ceramics Products1532.06- 29.47-1.9% Iron Steel1507.31-68.93-4.4% Nonferrous Metals1460.79-53.42- 3.5% Metal Products1259.51-35.12-2.7% Machinery1458.77-41.78-2.8% Electric Appliances2266.92-30.03-1.3% Transportation Equipments2918.27-44.25-1.5% Precision Instruments4237.37-22.02-0.5% Other Products2308.51-18.67-0.8% Electric Power Gas1073.11-25.66-2.3% Land Transportation1662.61-47.96-2.8% Marine Transportation1261.05-46.93-3.6% Air Transportation613.28-14.85-2.4% Warehousing Harbor Transportation Services1922.35-49.39-2.5% Information Communication2139.74-26.22-1.2% Wholesale Trade1304.46-44.48-3.3% Retail Trade862.03-9.65-1.1% Banks378.7-5.31-1.4% Securities Commodity Futures 1012.61-15.68-1.5% Insurance1267.2-21.75-1.7% Other Financing Business989.71 -12.65-1.3% Real Estate2201.35-80.11-3.5% Services1113.76-7.75-0.7% On 4/2/07, Yuki Taga [EMAIL PROTECTED] wrote: At the following link: (if you have a Japanese capable browser) http://www.tse.or.jp/market/STATISTICS/06.html you can find the 33 TSE industry groups, how they closed both the morning and afternoon sessions. For years, I have been quickly copying and pasting this data into a .csv file that I then import to AB. I copy all four columns, then paste into Excel, then copy only the closing value column from inside Excel, and paste it over the other three columns. (Something about the table prevents copying of individual columns, but I easily put up with the tiny extra bit of work.) This gives me a line chart in AB by the way, because OHLC are then the same. Over the weekend, however, they have apparently revamped this site. I can copy just like I used to, but when I paste, I am alerted by my firewall that my computer wants to connect, repeatedly, to some TSE computer (as well as to localhost).
[amibroker] Yahoo Fundamental data issue
When I download Yahoo fundamental data the forward PE ratio is showing up as N/A. I did npt have problems with this beforeIs anyone else having this problem?
Re: [amibroker] OT: Need technical advice with a Web page
Hi Randy, Two questions please: 1) Which of the many add-ins is the one you used? 2) How can I identify cells? (For example, I don't want the headers, in fact I actually want the final price column, and that's it.) Best, Yuki Tuesday, April 3, 2007, 12:55:19 AM, you wrote: RH I have a free open-source add-in that can grab that information for RH you. The add-in, documentation on its functions, and sample templates can RH be found in the files area of this Yahoo group: RH http://finance.groups.yahoo.com/group/smf_addin/ RH For example, one function allows you to grab table cells on a webpage. I RH used this formula on the English version of that page to grab each element RH of the table: RH =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html RH ,G$12,bt_print.gif$F13) RH ...where G$12 is a cell I was referring to to tell it which column of the RH table to pick up and $F13 is a cell I was referring to to tell it which row RH of the table to pick up. The bt_print.gif is just a string it searches RH for on the page to position itself before it starts looking for the nth RH table row on the page. The end result, using row numbers from 1 to 34 and RH columns numbers from 1 to 4 for each row, was: RH IndustryIndexChange Fishery, Agriculture Forestry444.57-5.56-1.2% Mining RH 760.42-11.67-1.5% Construction783.39-18.74-2.3% Foods1176.344.50.4% Textiles RH Apparels779.08-15.86-2.0% Pulp Paper603.31-11.01-1.8% Chemicals1331.15- RH 28.12-2.1% Pharmaceutical2194.61-21.49-1.0% Oil Coal Products1695.65-36.23 RH -2.1% Rubber Products1926.38-18.37-0.9% Glass Ceramics Products1532.06- RH 29.47-1.9% Iron Steel1507.31-68.93-4.4% Nonferrous Metals1460.79-53.42- RH 3.5% Metal Products1259.51-35.12-2.7% RH Machinery1458.77-41.78-2.8% Electric RH Appliances2266.92-30.03-1.3% Transportation RH Equipments2918.27-44.25-1.5% Precision RH Instruments4237.37-22.02-0.5% Other Products2308.51-18.67-0.8% Electric RH Power Gas1073.11-25.66-2.3% Land RH Transportation1662.61-47.96-2.8% Marine RH Transportation1261.05-46.93-3.6% Air Transportation613.28-14.85-2.4% RH Warehousing RH Harbor Transportation Services1922.35-49.39-2.5% Information RH Communication2139.74-26.22-1.2% Wholesale Trade1304.46-44.48-3.3% Retail RH Trade862.03-9.65-1.1% Banks378.7-5.31-1.4% Securities Commodity Futures RH 1012.61-15.68-1.5% Insurance1267.2-21.75-1.7% Other Financing Business989.71 RH -12.65-1.3% Real Estate2201.35-80.11-3.5% Services1113.76-7.75-0.7% RH On 4/2/07, Yuki Taga [EMAIL PROTECTED] wrote: At the following link: (if you have a Japanese capable browser) http://www.tse.or.jp/market/STATISTICS/06.html you can find the 33 TSE industry groups, how they closed both the morning and afternoon sessions. For years, I have been quickly copying and pasting this data into a .csv file that I then import to AB. I copy all four columns, then paste into Excel, then copy only the closing value column from inside Excel, and paste it over the other three columns. (Something about the table prevents copying of individual columns, but I easily put up with the tiny extra bit of work.) This gives me a line chart in AB by the way, because OHLC are then the same. Over the weekend, however, they have apparently revamped this site. I can copy just like I used to, but when I paste, I am alerted by my firewall that my computer wants to connect, repeatedly, to some TSE computer (as well as to localhost).
Re: [amibroker] OT: Need technical advice with a Web page
On 4/2/07, Yuki Taga [EMAIL PROTECTED] wrote: Two questions please: 1) Which of the many add-ins is the one you used? The one that indicates it is the current version (last one in the add-ins directory). 2) How can I identify cells? (For example, I don't want the headers, in fact I actually want the final price column, and that's it.) =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html,2,bt_print.gif2) =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html,2,bt_print.gif3) =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html,2,bt_print.gif4) ...and so forth. The above three formula will pick up the 2nd column of the 2nd, 3rd, and 4th rows of the table (the first row is the headers you don't want). The last row of the table is the 34th row, and could be picked up like this: =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html,2,bt_print.gif34)
Re: [amibroker] OT: Need technical advice with a Web page
Can't explain what's going on but, if you use Firefox, there are a few addons to help grab tabular data (TableTools, Table2Clipboard). Have a look at https://addons.mozilla.org/en-US/firefox/search?q=tablestatus=4 GRANT Yuki Taga wrote: Can someone explain to me exactly how they have (below) encoded a requirement for me to communicate with their computer to simply perform a copy operation from my clipboard to my application? Is there any way around this? At the following link: (if you have a Japanese capable browser) http://www.tse.or.jp/market/STATISTICS/06.html you can find the 33 TSE industry groups, how they closed both the morning and afternoon sessions. For years, I have been quickly copying and pasting this data into a .csv file that I then import to AB. I copy all four columns, then paste into Excel, then copy only the closing value column from inside Excel, and paste it over the other three columns. (Something about the table prevents copying of individual columns, but I easily put up with the tiny extra bit of work.) This gives me a line chart in AB by the way, because OHLC are then the same. Over the weekend, however, they have apparently revamped this site. I can copy just like I used to, but when I paste, I am alerted by my firewall that my computer wants to connect, repeatedly, to some TSE computer (as well as to localhost). Since I never had to do this before, I tried blocking it via the firewall, but it just freezes Excel if I do that. Finally, I allowed it, and it works *almost* like before. I even tried e-mailing myself a copy of the page, but even though it's being opened as a temp file by my mail client, I still get the pop ups from the firewall when I try to paste the data into Excel. I have never had this experience before. Very annoying. Yuki 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ For other support material please check also: http://www.amibroker.com/support.html Yahoo! Groups Links
Re: [amibroker] Re: Backtesting using historical fundamentals in AB?
Brian -- I've looked for both ODBCPLugin.doc and FundamentalDataProviders.xls in the files section and can't find either. Are they posted? If so, where? Thanks. -- Keith brian.z123 wrote: Joe PS...always good to see you around the forum. PS...thanks for your efforts with AB/database/fdata accessibility over the years. Top effort. Re stats etc - I haven't read that big book yet but I am working privately on the Quant leads given late last year and have had some satisfying results come out of it. David, I have posted a running sheet in the root of the group files that contains clips from a good cross section of archival posts on using fdata with AB via various paths including ODBC plug in. It is well worth a read for any aspiring AB Fundamentalists. ODBCPLugin.doc (the file will come down in a few days). My *hunch* is we can do things with these methods that other retail software can't e.g. there are so many different types of fdata available and also different user requirements that only the flexible approach of AB can handle this. I now have to put my office hours where my mouth is and have a go at it myself. Some good people are using this approach or have tried it. From the talk it seems to have it's problems or are we making it harder than it needs to be? Re Comments, tips, wisdom etc (you have to be careful what you ask for!) Of course Fundamental analysis and Techno-Fundamental analysis work, along with Mechanical System Trading, Arbitrage Trading, Option Trading etc etc, but only in the hands of the few. *** To trade well we have to be in our Psychological comfort zone. This involves a three step process: 1. BUILD BELIEF preferably by experiencing acutal trading success or In lieu of that by getting so close to it that we can taste it: personal contact with a successful trader or mentor, reading about them (e.g Jack Scwhaeger), looking at the winning results from trading competitions (e.g Larry Williams) and through our own efforts experiencing successful virtual trading, backtesting, papertrading etc. In every case the success exemplars must have unequivocal objective evidence to support the record. 2. CHOOSE AN INVESTMENT STYLE TO MATCH YOUR TEMPERAMENT/CIRCUMSTANCES 3. MASTER THAT STYLE If you are not enjoying the trading success you would like one or more of those steps needs to be re-thought. Brian *:-) --- In amibroker@yahoogroups.com mailto:amibroker%40yahoogroups.com, dwrowley_2000 [EMAIL PROTECTED] wrote: I traded for about a year using AB based on various TA strategies, and generated some returns, but then I got the 'fundamentals' religion and moved over to Portfolio123.com However, I always really liked AB, the support, the continual improvement, etc. - and now I see that AB supports fundamental data! A couple of questions: - What data sources provide historical fundamental data? What are people using? (The matrix lists QuotePlus as a source of fundamental data, but it isn't clear if they provide HISTORICAL fundamental data that I can use for backtesting) - Are people actually doing this? Anyone have good success? I've been asking the P123 guys to add more TA functions, but they don't really seem to put a high priority on it. I think AB + access to the same historical fundamental data that P123 uses (Reuters, I believe) would be excellent. Comments, tip, wisdom appreciated! Thanks, David
Re: [amibroker] OT: Esignal no longer offers the Basic Subscription
Hello, There will be new plan eSignal DATA that will come with data only (no e-signal charting program) and pricing will be as follows: Base Fee: $60 per month Service Options*: Stocks: $15/mo Futures: $25/mo Options: $50/mo Forex: $50/mo Market Depth: $20/mo * Exchange fees apply Best regards, Tomasz Janeczko amibroker.com - Original Message - From: Paul Ho To: amibroker@yahoogroups.com Sent: Monday, April 02, 2007 3:35 PM Subject: [amibroker] OT: Esignal no longer offers the Basic Subscription I got this info from Esignal. Although they will continue with existing basic subscriptions. that means new subscribers will need to subscribe to the Premier plan which is $30 more a month for not really much more. (I think its 500 symbols) as compared to the 200 limit. but AB does very well with 200. Anybody knows Whats happening there?
[amibroker] Exit base on time and profit
Hello, Can someone please point me in the direction of how I would go about coding this? Exit Rules -- I would like to exit 5 bars after entry if open profit is 5% gain. Thank you for your help.
Re: [amibroker] OT: Need technical advice with a Web page
Hi Randy, This seems to work just fine, thanks. But ... it doesn't solve the outbound connection attempts. It seems that lifting *anything* from that TSE page prompts an outbound connection. Best, Yuki Tuesday, April 3, 2007, 7:09:19 AM, you wrote: RH On 4/2/07, Yuki Taga [EMAIL PROTECTED] wrote: Two questions please: 1) Which of the many add-ins is the one you used? RH The one that indicates it is the current version (last one in the RH add-ins directory). 2) How can I identify cells? (For example, I don't want the headers, in fact I actually want the final price column, and that's it.) RH =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html,2,bt_print.gif2) RH =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html,2,bt_print.gif3) RH =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html,2,bt_print.gif4) RH ...and so forth. The above three formula will pick up the 2nd column RH of the 2nd, 3rd, and 4th rows of the table (the first row is the RH headers you don't want). The last row of the table is the 34th row, RH and could be picked up like this: RH =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html,2,bt_print.gif34)
[amibroker] TICKER DATA
I want to have a column in my exploration where % difference between Nifty close % difference for the particular stock's close will be shown in a new column. How to write it in my exploration for AddColumn? gakkhar 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ 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/ * 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:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[amibroker] EXPOLORATION TO CHART
How to write the formula for shwing figures from a particular column of an exploration to be plotted in a chart? gakkhar 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ 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/ * 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:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[amibroker] BLANK ROWS
I want to add a few blank columns to my exploration where the columns will have headings as given by me but data cells will be blank, to be filled up by me in the csv file to be created by me when I export the exploration data to csv. What to write in the exploration to create such columns? gakkhar 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ 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/ * 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:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[amibroker] MFI, RSI DATA
The figures that I get for MFI (14) RSI (14) through exploration through formula are different. How to rectify this problem? gakkhar 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ 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/ * 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:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[amibroker] SP Website (.xls constituants list)
I have noticed the SP website has changed. Now SP appears to only have the data in web pages now, and I am unable to download the ASX SP 200 (etc) in .xls format. Anyone know if SP lists can still be downloaded in .xls format from the SP website?? KR Michael. ** Special Note (AS OF 3/4/07) ** I have also noticed within the SP a NEW GICS sector code of [65 Financial-x-Property Trusts] LINK http://www2.standardandpoors.com/portal/site/sp/en/au/page.topic/indices_asx200/2,3,2,8,0,0,0,0,0,0,3,0,0,0,0,0.html However, both the GICS map and ASX listed companies fail to show this new GICS sector yet. LINK http://www2.standardandpoors.com/portal/site/sp/en/au/page.topic/indices_gics/2,3,1,7,0,0,0,0,0,0,0,0,0,0,0,0.html LINK http://www.asx.com.au/research/companies/index.htm No doubt a new GICS map will be released sometime this month and changes to ASX listed companies will follow suite.
Re: [amibroker] BLANK ROWS
Try AddTextColumn( ,Your Heading); - Original Message - From: Vinay Gakkhar. [EMAIL PROTECTED] To: amibroker@yahoogroups.com Sent: Monday, April 02, 2007 4:30 PM Subject: [amibroker] BLANK ROWS I want to add a few blank columns to my exploration where the columns will have headings as given by me but data cells will be blank, to be filled up by me in the csv file to be created by me when I export the exploration data to csv. What to write in the exploration to create such columns? gakkhar 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ 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/ * 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:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [amibroker] EXPOLORATION TO CHART
Hello, Use Plot syntax instead of Addcolumn. Also specify the chart color and style. Cheers Prashanth - Original Message - From: Vinay Gakkhar. [EMAIL PROTECTED] To: amibroker@yahoogroups.com Sent: Tuesday, April 03, 2007 5:10 AM Subject: [amibroker] EXPOLORATION TO CHART How to write the formula for shwing figures from a particular column of an exploration to be plotted in a chart? gakkhar 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ 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/ * 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:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [amibroker] OT: Need technical advice with a Web page
Yuki, No problems here in copy/paste data from that website. (Copy from Firefox, Paste to OpenOffice spreadsheet) Do you have automatic updates switched on for windows? Are you using Firefox or Internet Explorer? (Has IE been updated at all?) Because when I try and copy/paste with Internet Explorer - It FAILS. When I paste as unformatted - EVERYTHING goes to the 1st column. When I paste as formatted - EVERYTHING goes to the 1st cell. When I paste as HTML I get some extra cruft about document source (The website address) pasted in the top cell and the rest of the cells are pasted ok (ie 4 columns). Suggest you try Firefox before anything else. KR Michael. Yuki Taga wrote: Hi Randy, This seems to work just fine, thanks. But ... it doesn't solve the outbound connection attempts. It seems that lifting *anything* from that TSE page prompts an outbound connection. Best, Yuki Tuesday, April 3, 2007, 7:09:19 AM, you wrote: RH On 4/2/07, Yuki Taga [EMAIL PROTECTED] mailto:yukitaga%40tkh.att.ne.jp wrote: Two questions please: 1) Which of the many add-ins is the one you used? RH The one that indicates it is the current version (last one in the RH add-ins directory). 2) How can I identify cells? (For example, I don't want the headers, in fact I actually want the final price column, and that's it.) RH =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html http://www.tse.or.jp/english/market/STATISTICS/e06.html,2,bt_print.gif2) RH =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html http://www.tse.or.jp/english/market/STATISTICS/e06.html,2,bt_print.gif3) RH =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html http://www.tse.or.jp/english/market/STATISTICS/e06.html,2,bt_print.gif4) RH ...and so forth. The above three formula will pick up the 2nd column RH of the 2nd, 3rd, and 4th rows of the table (the first row is the RH headers you don't want). The last row of the table is the 34th row, RH and could be picked up like this: RH =RCHGetTableCell(http://www.tse.or.jp/english/market/STATISTICS/e06.html http://www.tse.or.jp/english/market/STATISTICS/e06.html,2,bt_print.gif34)
Re: [amibroker] Exit base on time and profit
Greetings -- See if this helps. Note I've changed the 5% to 2% -- there are not many 5% gains in 5 days. Thanks, Howard www.quantitativetradingsystems.com //- //ExitAfterFiveDays.afl // //Put trade entry logic here. MA1 = MA(C,3); MA2 = MA(C,20); Buy = Cross(MA1,MA2); //Put trade exit logic here, but call the exit SellSystem SellSystem = Cross(MA2,MA1); //Set a profit target stop at 2%, exit intraday ApplyStop(stopTypeProfit,stopModePercent,2,1); // Combine the SellSystem with a timed exit after 5 days. // If the profit target was reached, it would have taken the trade out first. Sell = SellSystem OR (BarsSince(Buy)=5); // Remove the extra arrow. Buy = ExRem(Buy,Sell); Sell= ExRem(Sell,Buy); // Plot everything Plot(C,C,colorBlack,styleCandle); Plot(MA1,MA1,colorGreen,styleLine); Plot(MA2,MA2,colorBlue,styleLine); PlotShapes(Buy*shapeUpArrow+Sell*shapeDownArrow, IIf(Buy,colorGreen,colorRed)); On 4/2/07, chwinc2000 [EMAIL PROTECTED] wrote: Hello, Can someone please point me in the direction of how I would go about coding this? Exit Rules -- I would like to exit 5 bars after entry if open profit is 5% gain. Thank you for your help.
[amibroker] Re: create custom weighted index
The sample code did not work. Nothing happened when I tried to run it like that, so I don't know how to continue from here... --- In amibroker@yahoogroups.com, carlacash26 [EMAIL PROTECTED] wrote: Hi, hope you could help me in creating my own custom index. I have 8 stocks that I would like to include in the index, and each of the stocks have their own weighting in the index; O= (Open of A * 42) + (Open of B * 60) + (Open of C * 231 ETC...) H= (High of A * 42) + (High of B * 60) + (High of C * 231 ETC...) L= (Low of A * 42) + (Low of B * 60) + (Low of C * 231 ETC...) C= (Close of A * 42) + (Close of B * 60) + (Close of C * 231 ETC...) V= Volume added together Is there any smooth way to create this with the weightings? I have found the following info: A sample formula could look like this: Code: AddToComposite(C,~myindex, C); AddToComposite(H,~myindex, H); AddToComposite(L,~myindex, L); AddToComposite(O,~myindex, O); AddToComposite(V,~myindex, V); You would need to copy this formula into Automatic Analysis window. Click on Filter - choose appropriate category you want to calculate index from, then click OK. Now click SCAN. Then choose View- Refresh All menu. In the ticker tree you will see ~myindex ticker.