8 Messages
Digest #3681
4b
Re: Are you aware of a site that allows you to keep track of dividen by "Randy Harmelink" rharmelink
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?
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?
>
>
=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.
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
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/","
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?
>
>
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.
>
>
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/
> ","
>
> 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
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.
>
>
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