[jawsscripts] Re: automating commands to extract info from web site?
- From: "Don Marang" <donald.marang@xxxxxxxxx>
- To: <jawsscripts@xxxxxxxxxxxxx>
- Date: Tue, 1 Mar 2011 20:06:36 -0500
Try hitting F1 in Excel for help and typing something similar to "web data"
in the search box. I have Office 2007, so I do not know if all of the great
features are available in 2003. What you want is some type of web query. I
attempted to follow the directions in the help, but not all of the steps in
the help were easily accessible. You should be able to select a table on
the webpage and Excel helps you create a new web query. In Excel 2007, You
can also create a web query through the ribbon: Data > Web Source >
(probably available in the 2003 menus).
It may be easier to copy one of the examples of web queries that come with
Excel. Some of them are also to look up stock quotes. Then you can edit
the query and change it's properties. In the properties, there are
interesting features such as determining when the data is refreshed or
continually updated. I think Alt + F5 will manually ask if you want to
update the external sources.
If I give you any more help, you will need to provide me a percentage of
everything you make on the market (not the losses)! <grin>
Don Marang
Vinux Software Development Coordinator (vinux.org.uk)
There is just so much stuff in the world that, to me, is devoid of any real
substance, value, and content that I just try to make sure that I am working
on things that matter.
Dean Kamen
--------------------------------------------------
From: "Ann Marie Medlar" <amedlar1@xxxxxxxxx>
Sent: Tuesday, March 01, 2011 7:35 PM
To: <jawsscripts@xxxxxxxxxxxxx>
Subject: [jawsscripts] Re: automating commands to extract info from web
site?
> Hi all,
> Well I have Excel 2003 and I googled macro programming and a tutorial is
> available for excel so I think I'll try it in the morning. Thanks for all
> your help.
> Someone recommended macro express but it costs $$ and I rather try the
> free
> stuff first.
>
> ----- Original Message -----
> From: "Don Marang" <donald.marang@xxxxxxxxx>
> To: <jawsscripts@xxxxxxxxxxxxx>
> Sent: Tuesday, March 01, 2011 4:48 PM
> Subject: [jawsscripts] Re: automating commands to extract info from web
> site?
>
>
>> JAWS scripts gets a little more complicated in this scenario since it is
>> not for a single application. Therefore, it probably would needed to be
>> added to your default scripts. This can easily screw up JAWS if you even
>> get a simple compile error due to a mistyped character. I would not
>> recommend beginners write default scripts.
>>
>> Freedom Scientific now has some documentation on their website to write
>> rule
>> and query files for ResearchIt. It uses some open language built around
>> SQL
>> type code to generate text in the virtual buffer. You would need to copy
>> all then paste the results even after writing the rules file.
>>
>> I think using Microsoft's tools built into Excel would be your best bet.
>> This may include specifying an external data source, internal functions,
>> macros and edit it's own Visual Basic that the macros can generate.
>>
>> One thing to check that might make any automation easier is to check if
>> the
>> stock symbol, like ARMH, shows up somewhere in the address bar after you
>> type in the signal and hit enter on the Go button. If so, you can bypass
>> the edit box and go directly to the results page. Copy the entire URL in
>> the address bar. I am not familiar with Excel's syntax for grabbing data
>> from websites, but this URL will be critical. You can most likely
>> replace
>> the symbol text typed into the edit box with a cell coordinate to work
>> with
>> any symbol. I would attempt to place each piece of information you
>> currently append to clipboard to separate cells or areas of cells.
>>
>> Don Marang
>> Vinux Software Development Coordinator (vinux.org.uk)
>>
>> There is just so much stuff in the world that, to me, is devoid of any
>> real
>> substance, value, and content that I just try to make sure that I am
>> working
>> on things that matter.
>> Dean Kamen
>>
>>
>> --------------------------------------------------
>> From: "Ann Marie Medlar" <amedlar1@xxxxxxxxx>
>> Sent: Tuesday, March 01, 2011 1:32 PM
>> To: <jawsscripts@xxxxxxxxxxxxx>
>> Subject: [jawsscripts] Re: automating commands to extract info from web
>> site?
>>
>>> Hi James and all:
>>> I typed my keystrokes below after my note that I need to automate. My
>>> problem is that I know how to find the info in terms of Jaws but not in
>>> terms in a web language. So if you or anyone knows what the web
>>> language
>>> is for heading, table, copy and append to clipboard,
>>> F8 key please let me know so I know what to look for to automate using
>>> this
>>> utility. I just began reading the documentation. I was a mainframe
>>> computer programmer but don't know any PC languages. Any help
>>> appreciated.
>>> Thanks,
>>> Ann
>>> Keystrokes:
>>> Open site:
>>> http://www.barChart.com
>>> Note: edit box is part of a table
>>> type e for edit and enter ticker symbol
>>> I type ARMH for Arm Holdings
>>> tab to go and enter
>>> type h for heading for company name
>>> control+c to copy heading containing company name
>>> type t for table containing Stock price info
>>> up arrow once
>>> press f8 to select all table info
>>> windows+c to append table info
>>> type t for table
>>> up arrow
>>> F8 to highlight table info containing 2nd Resistance Point
>>> windows+c to append table info
>>> Find heading containing Today's Opinion which is a link and enter
>>> Literals from web site:
>>> Detailed Opinion Show Signal Strength and Direction
>>> table has 4 columns and 34 rows
>>> F8 to highlight table containing todays opinion
>>> windows+c to append
>>> alt+F4 to exit site
>>> alt+control+N for NotePad
>>> Control+v to paste
>>> Control+s to save
>>> Prompt user for file name
>>>
>>>
>>>
>>>
>>>
>>> http://barchart.com/opinions/stocks/ARMH
>>> ----- Original Message -----
>>> From: "Homme, James" <james.homme@xxxxxxxxxxxx>
>>> To: <jawsscripts@xxxxxxxxxxxxx>
>>> Sent: Tuesday, March 01, 2011 12:38 PM
>>> Subject: [jawsscripts] Re: automating commands to extract info from web
>>> site?
>>>
>>>
>>>> Hi Ann,
>>>> To be honest with you, it's going to be difficult unless you absolutely
>>>> know you will be putting in the same exact command sequence. If you
>>>> want
>>>> to do it through scripting, you could do it, but if I were you, I would
>>>> look into this free tool. http://seleniumhq.org/
>>>>
>>>> Jim
>>>> -----Original Message-----
>>>> From: jawsscripts-bounce@xxxxxxxxxxxxx
>>>> [mailto:jawsscripts-bounce@xxxxxxxxxxxxx] On Behalf Of Ann Marie Medlar
>>>> Sent: Tuesday, March 01, 2011 12:18 PM
>>>> To: jawsscripts@xxxxxxxxxxxxx
>>>> Subject: [jawsscripts] Re: automating commands to extract info from web
>>>> site?
>>>>
>>>> Hi all,
>>>> If I write out a series of windows and jaws commands sequentially to go
>>>> to
>>>> web, prompt to enter info in edit box, use Jaws to navigate info, copy
>>>> and
>>>> append info then alt+control+N for NotePad and then paste info and save
>>>> text
>>>> file.
>>>> could some of you give me guidance to script?
>>>> I would love to automate this processs because it would save me so much
>>>> time.
>>>> thanks for any feedback.
>>>> I use Jaws 11 or 12 and xP Media.
>>>> Thank you so much.
>>>> Ann
>>>>
>>>> __________�
>>>>
>>>> View the list's information and change your settings at
>>>> //www.freelists.org/list/jawsscripts
>>>>
>>>>
>>>> This e-mail and any attachments to it are confidential and are intended
>>>> solely for use of the individual or entity to whom they are addressed.
>>>> If
>>>> you have received this e-mail in error, please notify the sender
>>>> immediately and then delete it. If you are not the intended recipient,
>>>> you must not keep, use, disclose, copy or distribute this e-mail
>>>> without
>>>> the author's prior permission. The views expressed in this e-mail
>>>> message
>>>> do not necessarily represent the views of Highmark Inc., its
>>>> subsidiaries,
>>>> or affiliates.
>>>> __________�
>>>>
>>>> View the list's information and change your settings at
>>>> //www.freelists.org/list/jawsscripts
>>>>
>>>
>>> __________�
>>>
>>> View the list's information and change your settings at
>>> //www.freelists.org/list/jawsscripts
>>>
>>>
>> __________�
>>
>> View the list's information and change your settings at
>> //www.freelists.org/list/jawsscripts
>>
>
> __________�
>
> View the list's information and change your settings at
> //www.freelists.org/list/jawsscripts
>
>
__________�
View the list's information and change your settings at
//www.freelists.org/list/jawsscripts
Other related posts:
