[jawsscripts] Re: Excel Web Query for Stock analysis
- From: "Don Marang" <donald.marang@xxxxxxxxx>
- To: <jawsscripts@xxxxxxxxxxxxx>
- Date: Thu, 3 Mar 2011 16:13:42 -0500
Thanks for the notes. Sorry this thread got so off topic. I even forgot
which list I was responding to. I could bring this back to JAWS scripting
by attempting to figure out how to retrieve this data by navigating through
a webpage DOM. It is much easier with JAWS 12. However, scripting is
obviously not the right solution in this case.
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: Thursday, March 03, 2011 3:12 PM
To: <jawsscripts@xxxxxxxxxxxxx>
Subject: [jawsscripts] Re: Excel Web Query for Stock analysis
> Well Don I am not as smart as I thought I was. I got the company report
> to
> generate but I do it manually once on web site. However upon further
> reading there is an advanced way to generate the company report right from
> the Excel spreadsheet. I use Excel 2003 so code may vary among versions.
> But if I figure it out I will gladly share with list.
> I just posted how I generate report manually.
> Instructions:
> Download link for
>
> Excel spreadsheet with a web Query for stock quotes called
>
> StockQuoteTemplate.xls
>
> You may Need to copy and paste link into your browser because link name is
> too long.
>
>
>
> http://webcache.googleusercontent.com/search?q=cache:FS7e8sn8rlQJ:www.vertex42.com/ExcelTemplates/excel-stock-quotes.html+Link+StockQuoteTemplate.xls&hl=en&gl=us&strip=1
>
> Enter on text only version and read page until download link
>
> or Type "H" twice for download
>
> After downloading and opening Excel spreadsheet called
> StockQuoteTemplate.xls
>
> 2 buttons appear
>
> Press button that Enables data to be refreshed
>
> press control +G for GoTo Excel command
>
> type c6 and enter
>
> Type any stock symbol and enter
>
> go to b11 right and left arrow for company stock quotes
>
> On B11 enter on stock symbol to link to web
>
> to get company report use Jaws+f7 enter on print report The print will not
> go to your printer.
>
> type x and check company report or other desired check boxes
>
> type b for button enter on generate report new browser window opens
>
> company report displayed on screen which looks like a PDF
>
> If I press control+p to print and select Freedom for OpenBook it does not
> scan report into any format.
>
> I called FS; FS states OpenBook does not work from Web.
>
> I can save files in PIF or xPs formats.
>
>
>
>
>
>
>
>
>
>
>
> Press alt+F5 key to refresh
>
> There are many links on this page as well. It is easier navigating site
>
> using this work book.
>
> Microsoft link for Excel Web Queries:
>
> http://msdn.microsoft.com/en-us/library/aa203721(v=office.11).aspx#odc_xlwebquery_introduction
>
> ----- Original Message -----
> From: "Don Marang" <donald.marang@xxxxxxxxx>
> To: <jawsscripts@xxxxxxxxxxxxx>
> Sent: Thursday, March 03, 2011 2:50 PM
> Subject: [jawsscripts] Re: Excel Web Query for Stock analysis
>
>
>>I think that is a powerful feature of Excel that few or none of us have
>> mastered. I certainly would appreciate your collected, organized notes
>> on
>> how to use it!
>>
>> 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: Thursday, March 03, 2011 11:41 AM
>> To: <jawsscripts@xxxxxxxxxxxxx>
>> Subject: [jawsscripts] Re: Excel Web Query for Stock analysis
>>
>>> Hi all,
>>> Thank you for directing me with Excel. It is unbelievable how easy it
>>> is
>>> now that I know how. I don't even need to automate reports to read
>>> because
>>> using web query only gives essentials and does not load up all the junk
>>> on
>>> site. It takes me seconds to generate a company report for a given
>>> stock.
>>> If anyone is interested I wrote up procedures and directions. Let me
>>> know
>>> if anyone would want this info.
>>> thanks again for all your help. Well I did not need to write a script
>>> after
>>> all.
>>> Ann
>>>
>>>
>>>
>>> __________�
>>>
>>> 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:
