hi... thinking of subscribing to finviz.com

anyone a subscriber?

i have 2 questions:

1) is there a limit to the number of companies you can easily download to microsoft excel? i know there was a recent legal decision on data dumping. no idea whether finviz uses its own data or if it has some really expensive master licence?

2) can you sort on companies on state?

have searched on both.... my recollections on #1 are mixed.... #2 i have had no success.

for #2 better yet would be full contact info.... basically street address, city, state, postal code etc in different columns in microsoft excel.

thanks in advance!

#2 must exist out there, but maybe not on finviz...

I subscribe to finviz and do not think they have what you are looking for.

quandl Zach's fundamental B has it
https://www.quandl.com/data/ZFB/docu...ion/indicators

but its 1800/year and I can't personally justify paying that much.
May I ask what sort of strategies are you researching on? Feel free to PM if you don't want to post publicly.

You need to a) pay a lot of money or b) get a custom written scraper if you want to have this kind of data to play with. There might even be one floating around that's open source.

no problem.... i'm interested in a smaller amount of information on thousands of companies, so very wide but not very deep. and can use in microsoft excel .......... my interest is more in analyzing the universe superficially and perhaps marketing to the some of the companies than than in really doing "direct investment analysis".....

as per data, i mentioned the basic company info. also, and of course the more wide the data (without paying much more) the better......... i do know that to a certain degree that once you start adding one more data item (annual, quarterly, historical) that it's like eating potato chips. eventually you want 80% of the data so now you want it wide and deep.

end of day, i'd be happy with basic company info, price, market cap, t12 revenue and net income...... next level would probably be different time frame rates of price change.

thanks for the quandl suggestion...

i love that site... and what i really like about it is it seemed to have a wide range of quality/price options.......


say you want wheat prices, you can get a bunch of free ones (like imf, us government etc.) that are just generally very general spot type prices or you can pay alot of money (like $500 per month) and get a service with pristine data (from which you could build a semi-real trading model). and options in-between....

FYI, NOT what i'm looking for but interesting nonetheless (and gets me closer to my goal)

here are the top 15 states for publicly traded companies:

California 17% 17%
New York 10% 27%
Texas 9% 36%
Florida 7% 43%
Massachus 5% 47%
Illinois 5% 52%
New Jers 4% 56%
Pennsylvan 3% 59%
Nevada 3% 62%
Colorado 3% 65%
Georgia 3% 68%
Virginia 2% 70%
Ohio 2% 73%
Washington 2% 75%

number of publicly traded companies, NOT cap weighted..... nothing too surprising. maybe michigan not being on list and ohio being so low.