|
PureBytes Links
Trading Reference Links
|
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 <yukitaga@xxxxxxxxxxxxx> 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.
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:amibroker-digest@xxxxxxxxxxxxxxx
mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|