[jawsscripts] Re: automating commands to extract info from web site?
- From: "Ann Marie Medlar" <amedlar1@xxxxxxxxx>
- To: <jawsscripts@xxxxxxxxxxxxx>
- Date: Wed, 2 Mar 2011 07:08:07 -0500
Hi all,
Well I downloaded the following spreadsheet:
StockQuoteTemplate.xls
I go to data, import data, web query
but web quiry is only new and edit web query is unavailable. Has anyone
used this spreadsheet to gather stock info?
I thought this spreadsheet was ready to use but when I go to data menu,
import from external, I crash.
----- Original Message -----
From: "Reed Poynter" <Reed.Poynter@xxxxxxxxx>
To: <jawsscripts@xxxxxxxxxxxxx>
Sent: Wednesday, March 02, 2011 1:00 AM
Subject: [jawsscripts] Re: automating commands to extract info from web
site?
> It sounds to me that you could really use the Web Query facility in Excel
> 2003. It is found under data, import data, web query.
> If you Google "excel 2003 web query", you will find several sites that
> show
> you how to use it.
>
> Quite often, I will use the record a macro facility to capture the steps
> taken to create an import. Then I will edit the recorded macro to
> customize
> it and/or to edit the data imported.
>
> I have found Excel's record a macro feature to be invaluable in learning
> to
> use macros. If I want to find out how to do something in a macro, I will
> start recording, walk through the steps required to do that something on
> the
> keyboard, stop recording and go look at the macro created. This process
> has
> saved me from many hours of frustration.
>
> Good luck.
>
> Reed
>
> -----Original Message-----
> From: jawsscripts-bounce@xxxxxxxxxxxxx
> [mailto:jawsscripts-bounce@xxxxxxxxxxxxx] On Behalf Of Ann Marie Medlar
> Sent: March-01-11 6:43 PM
> To: jawsscripts@xxxxxxxxxxxxx
> Subject: [jawsscripts] Re: automating commands to extract info from web
> site?
>
> Hi Don,
> Thanks for all your help so far. No money yet but maybe after I get my
> procedure automated. LOL
> Anyway here is link for a tutorial. I did lesson 1 and hope I can follow
> directions without the pictures. I really should learn some Visual Basic.
> http://www.excel-vba.com/excel-macros-beginners.htm
>
> ----- Original Message -----
> From: "Don Marang" <donald.marang@xxxxxxxxx>
> To: <jawsscripts@xxxxxxxxxxxxx>
> Sent: Tuesday, March 01, 2011 8:06 PM
> Subject: [jawsscripts] Re: automating commands to extract info from web
> site?
>
>
>> 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
>>
>>
>
> __________�
>
> 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:
