[jawsscripts] Re: automating commands to extract info from web site?
- From: "Ann Marie Medlar" <amedlar1@xxxxxxxxx>
- To: <jawsscripts@xxxxxxxxxxxxx>
- Date: Wed, 2 Mar 2011 14:56:40 -0500
Thanks I'll do that.
Thanks I think I got it somewhat figured out.
After launching this excel file
I Press button that Enables data to be refreshed
go to c6
enter stock symbol
go to b11 for company name enter
I get a stock quote.
Now I'll use the alt+F5 key to refresh
There are many links on this page as well. It is easier navigating site
using this work book.
I can go to MSNMoney.com and other links directly from spreadsheet.
If I enter on print report I get a list of check boxes for information I
want on report.
I could check all but I'll experiment as to what data is more useful.
I might use alt+controll+k to be able to go directly to list of check boxes
on site. I think that is the key stroke.
Then I press generate report button.
I will work on this automation another day because unsure what I want to
automate.
Thanks to all for your help. I am not done but I am getting closer.
Ann
----- Original Message -----
From: "Don Marang" <donald.marang@xxxxxxxxx>
To: <jawsscripts@xxxxxxxxxxxxx>
Sent: Wednesday, March 02, 2011 1:52 PM
Subject: [jawsscripts] Re: automating commands to extract info from web
site?
> Pressing Alt + F5 is a shortcut to update all external data. Give it a
> try.
>
> 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: Wednesday, March 02, 2011 7:08 AM
> To: <jawsscripts@xxxxxxxxxxxxx>
> Subject: [jawsscripts] Re: automating commands to extract info from web
> site?
>
>> 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
>>>>>>>> http://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
>>>>>>>> http://www.freelists.org/list/jawsscripts
>>>>>>>>
>>>>>>>
>>>>>>> __________�
>>>>>>>
>>>>>>> View the list's information and change your settings at
>>>>>>> http://www.freelists.org/list/jawsscripts
>>>>>>>
>>>>>>>
>>>>>> __________�
>>>>>>
>>>>>> View the list's information and change your settings at
>>>>>> http://www.freelists.org/list/jawsscripts
>>>>>>
>>>>>
>>>>> __________�
>>>>>
>>>>> View the list's information and change your settings at
>>>>> http://www.freelists.org/list/jawsscripts
>>>>>
>>>>>
>>>> __________�
>>>>
>>>> View the list's information and change your settings at
>>>> http://www.freelists.org/list/jawsscripts
>>>>
>>>>
>>>
>>> __________�
>>>
>>> View the list's information and change your settings at
>>> http://www.freelists.org/list/jawsscripts
>>>
>>> __________�
>>>
>>> View the list's information and change your settings at
>>> http://www.freelists.org/list/jawsscripts
>>>
>>
>> __________�
>>
>> View the list's information and change your settings at
>> http://www.freelists.org/list/jawsscripts
>>
>>
> __________�
>
> View the list's information and change your settings at
> http://www.freelists.org/list/jawsscripts
>
__________�
View the list's information and change your settings at
http://www.freelists.org/list/jawsscripts
Other related posts: