tag:blogger.com,1999:blog-4367144710140797723.post8827347851003186677..comments2015-01-12T09:17:45.565-08:00Comments on Just Spreadsheets: Stock Screening in ExcelJPhttp://www.blogger.com/profile/04056951295611398748noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-4367144710140797723.post-57442297205519366882013-05-02T17:25:26.914-07:002013-05-02T17:25:26.914-07:00Hi,
I have 2 queries:
(1) I would like to use th...Hi,<br /><br />I have 2 queries:<br /><br />(1) I would like to use the stock screener spreadsheet to get the same data from yahoo instead of Finviz site, how do I do this as I cannot see how to input the Stock Exchange, Indice or stock codes. Have these been input on a hidden sheet (eg setup or workbook), if so how can I access ?<br /><br />(2) As yahoo only allows ten yahoo tags per query, how did you overcome this to get data for all 80 plus yahoo tags and extract them to Excel ?Anonymoushttps://www.blogger.com/profile/16012052095353103441noreply@blogger.comtag:blogger.com,1999:blog-4367144710140797723.post-86324495545017259722012-09-08T13:44:12.654-07:002012-09-08T13:44:12.654-07:00Great work.
Noticed that the industry averages d...Great work. <br /><br />Noticed that the industry averages don't match up to the values you get when you manually calculate the average...Coryhttps://www.blogger.com/profile/06810365291334959281noreply@blogger.comtag:blogger.com,1999:blog-4367144710140797723.post-70036049309810557162011-08-14T18:21:43.912-07:002011-08-14T18:21:43.912-07:00I've been reviewing your excel sheets etc. The...I've been reviewing your excel sheets etc. They truly are impressive. I notice that its coming up to 2 years since your last post. It would be great to see the blog continue one!Clinthttps://www.blogger.com/profile/00005371951706046030noreply@blogger.comtag:blogger.com,1999:blog-4367144710140797723.post-3907238050818914262011-07-29T07:36:02.039-07:002011-07-29T07:36:02.039-07:00Hey JP,
Just downloaded the stock screener and fo...Hey JP,<br /><br />Just downloaded the stock screener and for some reason it's not getting any data only shows #NAME? in all fields... do you have any idea what might be wrong?Engineerhttps://www.blogger.com/profile/04760500691460811155noreply@blogger.comtag:blogger.com,1999:blog-4367144710140797723.post-1805647565262969492010-03-25T19:45:54.238-07:002010-03-25T19:45:54.238-07:00Thanks so much for putting all these together and ...Thanks so much for putting all these together and sharing! They are way awesome and helpful.Wixhttps://www.blogger.com/profile/08322657382865433486noreply@blogger.com