[jawsscripts] Re: automating commands to extract info from web site?
- From: "Don Marang" <donald.marang@xxxxxxxxx>
- To: <jawsscripts@xxxxxxxxxxxxx>
- Date: Wed, 2 Mar 2011 11:53:02 -0500
With these Visual Basics you could not only retrieve information from the
Web, you can manipulate it and analyze it as well. If you start dreaming of
'inventing' a new Day Trader Automated System, these macros will not be
enough. They are written in very tight assembler to make trades uncannily
quick and break the market!
For simple retrieval, that can fill in individual cells and write normal
Excel calculations, I think the Web Query or Web external data features
would best fit your needs and be the simplest.
PS I took the time to look this up because it is a very powerful feature of
Excel. I use Excel a lot, but never investigated this feature.
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 9: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
Other related posts: