Kamis, 21 April 2016

[smf_addin] Digest Number 3681

8 Messages

Digest #3681

Messages

Wed Apr 20, 2016 10:44 am (PDT) . Posted by:

gobi5

Trying to use RCHGetTableCell to get the "OPTION VOLUME" value here:


http://www.optionistics.com/quotes/stock-quotes/NTGR http://www.optionistics.com/quotes/stock-quotes/NTGR



Having trouble getting it to work. Any ideas?


Wed Apr 20, 2016 1:11 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Either of these seem to work:

=RCHGetTableCell("http://www.optionistics.com/quotes/stock-quotes/NTGR",1,">
Option volume")

=RCHGetTableCell("http://www.optionistics.com/quotes/stock-quotes/NTGR",1,">
Option volume")

On Wed, Apr 20, 2016 at 10:44 AM, cmaxmagee@
​....wrote:

> Trying to use RCHGetTableCell to get the "OPTION VOLUME" value here:
>
> http://www.optionistics.com/quotes/stock-quotes/NTGR
>
> Having trouble getting it to work. Any ideas?
>
>

Wed Apr 20, 2016 1:01 pm (PDT) . Posted by:

ethanbond911

Hi everyone, I was wondering if anyone has been able to connect RiskDoctor's, Risk Illustrator to Tos, Esignal or any platform?
Regards,
Ethan.

Wed Apr 20, 2016 1:42 pm (PDT) . Posted by:

hashky

Randy -

Thanks. Is there documentation anywhere to help me determine the JSON file? How do you find the URL?

Is there an easier way to do the following?

I got the spreadsheet going. Below are the typical equations for text and value fields. As I looked at the data, it seems that "{" and "}" designated a change database records. So I did a string extract (smfStrExtr) to limit the returns to text between the brackets. This way I am assured that I have the information is for the right Ticker.

Typical Ticker VMO
Text
=(smfStrExtr(smfStrExtr(RCHGetWebData("http://www.cefconnect.com/api/v3/DailyPricing?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip/","""Ticker"":"""&B93&"""",400,-1),"{","}"),"""Name"":",","))

Values
=smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData("http://www.cefconnect.com/api/v3/DailyPricing?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip/","""Ticker"":"""&B93&"""",400,-1),"{","}"),"""DistributionRatePrice";":",","))

There is probably very little interest in the group in closed end funds. They have more risk than open end funds. If anyone wants a copy I will post.

Ron Spruell

Wed Apr 20, 2016 2:17 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You need a tool that traces web traffic.

I use a FireFox add-on -- HttpFox.It monitors and analyzes all incoming and
outgoing HTTP traffic between the browser and the web servers.

On Wed, Apr 20, 2016 at 1:42 PM, hashky@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks. Is there documentation anywhere to help me determine the JSON
> file? How do you find the URL?
>
>

Wed Apr 20, 2016 2:28 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

There are so many ways to go about it, that it depends so much on what
you're trying to extract and how you're planning to use it. For example,
try this:

1. Open the SMF-Quick-Webpage-Examination.xls template.
2. Go to the "By Cascading Value" worksheet
3. Enter your URL in the "Web Page" entry cell
4. Enter "{" into the "String" entry cell

The result should be the entire file broken up line by line. I see 553
different lines.

Then, you could add columns for each field you want to extract, using the
column header to do the extraction from that column of data, using the
smfStrExtr() function.

Depends on whether you want to build a table, or do it ticker by ticker.
However, if you do build the table, you can always use VLOOKUP() to find
the individual pieces of data you're interested in.

On Wed, Apr 20, 2016 at 1:42 PM, hashky@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is there an easier way to do the following?
>
> I got the spreadsheet going. Below are the typical equations for text and
> value fields. As I looked at the data, it seems that "{" and "}"
> designated a change database records. So I did a string extract
> (smfStrExtr) to limit the returns to text between the brackets. This way I
> am assured that I have the information is for the right Ticker.
>
> Typical Ticker VMO
> Text
> =(smfStrExtr(smfStrExtr(RCHGetWebData("
> http://www.cefconnect.com/api/v3/DailyPricing?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip/
> ","""Ticker"":"""&B93&"""",400,-1),"{","}"),"""Name"":",","))
>
> Values
> =smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData("
> http://www.cefconnect.com/api/v3/DailyPricing?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip/
> ","""Ticker"":"""&B93&"""",400,-1),"{","}"),"""DistributionRatePrice";":",","))
>
> There is probably very little interest in the group in closed end funds.
> They have more risk than open end funds. If anyone wants a copy I will
> post.
>
>

Wed Apr 20, 2016 5:12 pm (PDT) . Posted by:

"Gus Vega" gavega

> Randy,

I am building an investment portfolio. I have tried Yahoo Finance, Google Finance, and MSN Finance but non of them offers the feature of dividend reinvestment option. I'd appreciate your help on this matter.

Thanks,

Gavega

Wed Apr 20, 2016 7:27 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I don't use any of the portfolio features of the online
services...

On Wed, Apr 20, 2016 at 5:12 PM, Gus Vega gavega@
​...wrote:

>
> I am building an investment portfolio. I have tried Yahoo Finance, Google
> Finance, and MSN Finance but non of them offers the feature of dividend
> reinvestment option. I'd appreciate your help on this matter.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar