Minggu, 12 Juni 2016

[smf_addin] Digest Number 3728

7 Messages

Digest #3728

Messages

Sat Jun 11, 2016 2:34 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry. I don't do anything with non-U.S. stocks, so I'm not up on the data
sources available.

On Fri, Jun 10, 2016 at 10:57 PM, Andy Chan andy_c_chan@
​...wrote:

> 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. you
> want the call to expire barely worthless (stock closing within a dime of
> it), and then have the shares continue to fly *right* afterwards
>

Sat Jun 11, 2016 3:22 am (PDT) . Posted by:

"Andy Chan" andy_c_chan

What about other closing price source for say US stocks?

Sent from my iPhone

> On 11 Jun 2016, at 5:34 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Sorry. I don't do anything with non-U.S. stocks, so I'm not up on the data sources available.
>
> On Fri, Jun 10, 2016 at 10:57 PM, Andy Chan andy_c_chan@
> ​...wrote:
>> 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. you want the call to expire barely worthless (stock closing within a dime of it), and then have the shares continue to fly right afterwards
>
>

Sat Jun 11, 2016 4:14 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Numerous sources, but I ignore them because it would normally take one web
page retrieval per ticker symbol. That means they take far too long for any
number of stocks.

I'd probably start looking at the portfolio options on each data source, to
see if they can be exported easily.

On Sat, Jun 11, 2016 at 3:22 AM, Andy Chan andy_c_chan@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
> What about other closing price source for say US stocks?
>
>

Sat Jun 11, 2016 9:05 am (PDT) . Posted by:

john_hoel

I am trying to change the following statement to make a symbolic reference to a worksheet cell for symbol, and not having any luck:

=RCHGetTableCell("http://bigcharts.marketwatch.com/historical/default.asp?symb=CTZ&closeDate="&TEXT(D74,"mm/dd/yyyy"),1,"Closing Price:")

I want to change 'CTZ' to whatever works for a cell reference. Can you help?

There should be some Excel documentation on this but I do not know where to look. I would like to learn all the rules.


Sat Jun 11, 2016 9:20 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

In your case, it's just an EXCEL concatenation of four items -- a string to
a cell reference to a string to a formula:

"http://bigcharts.marketwatch.com/historical/default.asp?symb="
C74
"&closeDate="
TEXT(D74,"mm/dd/yyyy")

Put them all together, with ampersands in between to indicate
concatenation, and you have:

=RCHGetTableCell("
http://bigcharts.marketwatch.com/historical/default.asp?symb=" & C74 &
"&closeDate=" & TEXT(D74,"mm/dd/yyyy"),1,"Closing Price:")

On Sat, Jun 11, 2016 at 9:05 AM, john@
​...wrote:

>
> I am trying to change the following statement to make a symbolic reference
> to a worksheet cell for symbol, and not having any luck:
>
> =
> ​​
> RCHGetTableCell("
> http://bigcharts.marketwatch.com/historical/default.asp?symb=CTZ&closeDate="&TEXT(D74,"mm/dd/yyyy"),1,"Closing
> Price:")
>
> I want to change 'CTZ' to whatever works for a cell reference. Can you
> help?
>
> There should be some Excel documentation on this but I do not know where
> to look. I would like to learn all the rules.
>
​​

Sat Jun 11, 2016 1:15 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

You can try password protection of your routines. There are programs available for also nothing that break your password protection.


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 10, 2016 11:07 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Not sure if it can done since i know nothing about excel


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

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

Tidak ada komentar:

Posting Komentar