Messages

1a

Mon Jan 18, 2016 2:25 am (PST) . Posted by:

Hi, I am trying to get some data from AdvFN, but there is one issue I have no idea how to cross it. I downloaded the template of AdvFN from: http://ogres-crypt.com/SMF/Templates/smfGetAdvFNElement-Template-All-Line-Items.xls http://ogres-crypt.com/SMF/Templates/smfGetAdvFNElement-Template-All-Line-Items.xls As I am non-US, so my prefix is asia, I tried some quotes like "AAPL", "KO", "MMM" and "V", above of them are working well, I can get / see data in excel cells, but while I am trying to get the quote of "HAS" it is nothing just "--". I can see something if I directly open the link: Hasbro Inc Company Financial Information http://asia.advfn.com/stock-market/NASDAQ/HAS/financials?btn=annual_reports

1b

Mon Jan 18, 2016 12:35 pm (PST) . Posted by:

I think if you want to access those companies, you need to use the exchange prefix. For example, if you're in the browser and just enter the ticker symbol "HAS", you actually get sent to this web page:

http://asia.advfn.com/stock-market/london/HAS/financials

...and it has no financial statements. What you want is:

http://asia.advfn.com/stock-market/NASDAQ/HAS/financials

...and that is a ticker symbol of NASDAQ:HAS on your regional website, not HAS.

I'm hoping the extended ticker symbol will work. I had to put some special programming in for it, but I have no way to test it myself. I wrote the add-in for my own use, and am just sharing it. But my uses are very narrow -- mostly large cap U.S. stocks and index ETFs. I don't do anything with individual mutual funds, bonds, or foreign stocks.

2a

Mon Jan 18, 2016 7:41 am (PST) . Posted by:

Hi all, just in the last week I am having a problem with my spreadsheet that pulls from Yahoo. The formulas are working and we are seeing prices but then they are deleting themselves leaving the formula cell blank.

2 hours later it may work or it may not. This issue is becoming really frustrating. Does anyone have any ideas what it is doing or how to fix this issue?

2b

Mon Jan 18, 2016 12:22 pm (PST) . Posted by:

The last few months, others have also been having issues with RCHGetYahooQuotes(). For all of them, my suggested work-around was to combine all their individual function invocations into an array-entered function, so all of the data could be collected in a single Internet access. That would speed up recalculation time significantly. Plus, if you do happen to get an empty response from Yahoo, it's easily rectified by just running smfForceRecalculation again. On Mon, Jan 18, 2016 at 8:41 AM, corinne4157@... wrote:

> > Hi all, just in the last week I am having a problem with my spreadsheet > that pulls from Yahoo. The formulas are working and we are seeing prices > but then they are deleting themselves leaving the formula cell blank. > > 2 hours later it may work or it may not. This issue is becoming really > frustrating. Does anyone have any ideas what it is doing or how to fix this > issue? >