Sabtu, 11 Juni 2016

[smf_addin] Digest Number 3727

5 Messages

Digest #3727

Messages

Fri Jun 10, 2016 7:54 pm (PDT) . Posted by:

mark.boogaers

Randy,


Thanks. Made the report to Yahoo and got the function =RCHGetHTMLTable("https://finance.yahoo.com/quotes/ALC.MC,AZK.MC,DIA.MC,A3M.MC,AMS.MC,PRM.MC https://finance.yahoo.com/quotes/ALC.MC,AZK.MC,DIA.MC,A3M.MC,AMS.MC,PRM.MC","Mkt Cap") working you but I can not figure out how to only get the price column and without the header.

With the website address I tried using an array, but that does not seem to work so I combine all the tickers I want in a separate cell as a string like ="https://finance.yahoo.co.jp/quotes/"&D108&","&D109&","&D110&","&D111&","&D112&","&D113&","&D114&","&D115&","&D116&","&D117&","&D118&","&D119&","&D120&","&D121&","&D122
There must be a better way, but it works.


Thanks for your help.


Mark







Mark

Fri Jun 10, 2016 8:58 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The add-in does have a utility function for all those concatenations. You
should just be able to do this:

smfJoin(D108:D122,",")

...and it should concatenate that range of cells together, putting the
comma between each cell value. I'm shocked there isn't a native function
for that in EXCEL. I've had a version of it in my personal add-in for a
long time.

I think the best option would be to grab the Yahoo table on a different
worksheet, then VLOOKUP() the results in the worksheet where you need the
data.

On Fri, Jun 10, 2016 at 7:53 PM, mark.boogaers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks. Made the report to Yahoo and got the function =RCHGetHTMLTable("
> https://finance.yahoo.com/quotes/ALC.MC,AZK.MC,DIA.MC,A3M.MC,AMS.MC,PRM.MC","Mkt
> Cap") working you but I can not figure out how to only get the price
> column and without the header.
>
> With the website address I tried using an array, but that does not seem to
> work so I combine all the tickers I want in a separate cell as a string
> like ="https://finance.yahoo.co.jp/quotes/
> "&D108&","&D109&&quot;,"&D110&","&D111&&quot;,"&D112&","&D113&&quot;,"&D114&","&D115&&quot;,"&D116&","&D117&&quot;,"&D118&","&D119&&quot;,"&D120&","&D121&&quot;,"&D122
> There must be a better way, but it works.
>
>
>

Fri Jun 10, 2016 8:06 pm (PDT) . Posted by:

ethanbond911

Hello everyone:
question, if I had a program that was propriety for options analysis and I wanna sell the program is there a way to make Excel Hack Proof. Let's say I wanted this program which was issued a key to go to a certain server and verify the key and then unlock on one computer? if anyone has the answer please help. Thank you in advance.
Ethan

Fri Jun 10, 2016 9:11 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

As far as I know, they can all be hacked in some way...but I only have a
little knowledge on that aspect of EXCEL.

On Fri, Jun 10, 2016 at 8:06 PM, ethanbond911@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Hello everyone:
>
> question, if I had a program that was propriety
> for options analysis and I wanna sell the program is there a way to make
> Excel Hack Proof. Let's say I wanted this program which was issued a key to
> go to a certain server and verify the key and then unlock on one computer?
> if anyone has the answer please help. Thank you in advance.
>
> Ethan
>
> ​​

Fri Jun 10, 2016 10:57 pm (PDT) . Posted by:

"Andy Chan" andy_c_chan

Hi Randy, do you know of another source/feed of closing price that I can use the SMF get quote or get element to obtain? Doesn't seem like Google has closing price availability other than getting it from the web, and Morningstar doesn't work anymore for international stocks (they're undergoing migration from new beta site and the current production site lost all historical and financial statement info with the CSV Ajax function. I am particularly looking for Japanese stock closing price. Thanks, Andy

Sent from my iPad

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

Tidak ada komentar:

Posting Komentar