[smf_addin] Digest Number 3617

EXCEL Stock Market Functions Add-in Group

2 Messages

Digest #3617

1a

Excel Cell Reference using RCHGetTableCell() by ztripp2000

1b

Re: Excel Cell Reference using RCHGetTableCell() by ztripp2000

Messages

1a

Excel Cell Reference using RCHGetTableCell()

Mon Jan 25, 2016 6:52 am (PST) . Posted by:

ztripp2000

I have an execl list of stocks that I want to use with RCHGetTable().


How do I use a cell reference in the URL for yahoo?


For example, cell A1 contains: MMM


RCHGetTableCell("http://finance.yahoo.com/q/ks?s=A1",1,"Market Cap (intraday)")





Thanks! Zach.

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Excel Cell Reference using RCHGetTableCell()

Mon Jan 25, 2016 7:57 am (PST) . Posted by:

ztripp2000

Never mind, I see I have asked this before! It did not come up in the search before I posted. I can find the old reply now, thanks Randy.

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 20

• Privacy • Unsubscribe • Terms of Use