General market lab and commentary Message Board

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : General market lab and commentary

SPY 670.97

+0.1%

Nov 7 4:00 PM EST

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next

To: Robohogs who wrote (443)	5/26/2016 8:29:52 AM
From: Robohogs	of 668

Please note that the spreadsheet tracker I built for IBB and XBI now includes the ETF's ownership (as listed on its web site) in each component and then uses Google Finance data as reported to Google Sheets to show the percentage ownership. If folks here want me to add the smaller ETFs to additional pages in the workbook, please let me know. I am also open to suggestions to create a more complete biotech list in one place. If folks have suggestions for lists, please let me know. A new project that just came to me is that I will add the SI Contest List of Stocks to a new page and it will show big movers. I WILL NOT link it to front sheet. I would show YTD moves for each stock but formatting to pull the data is means getting the list horizontally vs. vertically and leaving 1 space for date on each ticker so call it 400 columns (200 stocks with 2 columns each). Setting up sheet will be too time-consuming. I may later and capture MA data too. As of now, I note that Google Sheets cannot pull data for IBB hold CNCE in real time, nor can it pull HZNP or MYL historically for some reason. As I implement a few of my ideas into the current workbook (or a new one to keep from crashing each other), I am going to have to ignore these data errors - I am trying to automate as much of the basic charting/basic analysis as I can so I can just run scans and historical studies of certain events. Jon

Report TOU Violation

Share This Post

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next