4 Messages
Digest #4487
Messages
Fri Feb 22, 2019 10:20 am (PST) . Posted by:
"Rhonda Federman" rhonda.federman@gmail.com
Is it possible to pull the data into smfGetYahooPortfolioView that used to
be available on smfGetBarchartPortfolioView? Specifically,
- 5 year dividend growth rate
- 5 year earnings growth rate
- relative strength 14 day
- industry
Or is there another way to pull this data into Excel?
Thanks,
Rhonda Federman
be available on smfGetBarchartPortf
- 5 year dividend growth rate
- 5 year earnings growth rate
- relative strength 14 day
- industry
Or is there another way to pull this data into Excel?
Thanks,
Rhonda Federman
Fri Feb 22, 2019 11:06 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The best method depends entirely on what you're trying to do. If you're
doing some sort of screening, I would suggest just using BarChart's stock
screener and exporting the results.
If you want the data on a ticker by ticker basis for a number of stocks,
it's going to be a lot of processing to get the data, since I'm not aware
of a source that has all of those data items on a single page that is
available to the add-in.
On Fri, Feb 22, 2019 at 11:21 AM Rhonda Federman rhonda.federman@... wrote:
>
> Is it possible to pull the data into smfGetYahooPortfolioView that used to
> be available on smfGetBarchartPortfolioView? Specifically,
> - 5 year dividend growth rate
> - 5 year earnings growth rate
> - relative strength 14 day
> - industry
>
> Or is there another way to pull this data into Excel?
>
>
doing some sort of screening, I would suggest just using BarChart'
screener and exporting the results.
If you want the data on a ticker by ticker basis for a number of stocks,
it's going to be a lot of processing to get the data, since I'm not aware
of a source that has all of those data items on a single page that is
available to the add-in.
On Fri, Feb 22, 2019 at 11:21 AM Rhonda Federman rhonda.federman@
>
> Is it possible to pull the data into smfGetYahooPortfoli
> be available on smfGetBarchartPortf
> - 5 year dividend growth rate
> - 5 year earnings growth rate
> - relative strength 14 day
> - industry
>
> Or is there another way to pull this data into Excel?
>
>
Fri Feb 22, 2019 11:01 pm (PST) . Posted by:
gz_cp
I am looking for a way to use SMF to download US Census data through its API such as
https://api.census.gov/data/2017/acs/acs5?get=B00001_001E,NAME&for=zip%20code%20tabulation%20area:* https://api.census.gov/data/2017/acs/acs5?get=B00001_001E,NAME&for=zip%20code%20tabulation%20area:*
or
https://api.census.gov/data/2017/acs/acs5?get=B00001_001E,NAME&for=metropolitan%20statistical%20area/micropolitan%20statistical%20area:* https://api.census.gov/data/2017/acs/acs5?get=B00001_001E,NAME&for=metropolitan%20statistical%20area/micropolitan%20statistical%20area:*
I want the results to go to cells.
Is it possible?
Thank you.
Tony
https://api.census.gov/data/2017/acs/acs5?get=B00001_001E,NAME&for=zip%20code%20tabulation%20area:* https://api.census.gov/data/2017/acs/acs5?get=B00001_001E,NAME&for=zip%20code%20tabulation%20area:*
or
https://api.census.gov/data/2017/acs/acs5?get=B00001_001E,NAME&for=metropolitan%20statistical%20area/micropolitan%20statistical%20area:* https://api.census.gov/data/2017/acs/acs5?get=B00001_001E,NAME&for=metropolitan%20statistical%20area/micropolitan%20statistical%20area:*
I want the results to go to cells.
Is it possible?
Thank you.
Tony
Fri Feb 22, 2019 11:36 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You'd need to do a cascading find. For example, open up
the SMF-Quick-Webpage-Examination.xls template and go to the "By Cascading
Value" worksheet. Put your URL in cell D7 and "[" in cell D8. Then you
should see each "[...]" as the first item of each line. Then, it's just a
matter of parsing the three items out of each line.
For example, to parse out the items on line 13:
=smfWord($D13,2,"""")
=smfWord($D13,4,"""")
=smfWord($D13,6,"""")
1234 ZCTA5 00601 00601
2009 ZCTA5 00602 00602
3603 ZCTA5 00603 00603
470 ZCTA5 00606 00606
1531 ZCTA5 00610 00610
3489 ZCTA5 00612 00612
536 ZCTA5 00616 00616
I do this kind of stuff all the time. :)
On Sat, Feb 23, 2019 at 12:03 AM gz_cp@... wrote:
> I am looking for a way to use SMF to download US Census data through its
> API such as
>
>
> https://api.census.gov/data/2017/acs/acs5?get=B00001_001E,NAME&for=zip%20code%20tabulation%20area:*
>
> or
>
>
> https://api.census.gov/data/2017/acs/acs5?get=B00001_001E,NAME&for=metropolitan%20statistical%20area/micropolitan%20statistical%20area:*
>
> I want the results to go to cells.
>
> Is it possible?
>
>
>
the SMF-Quick-Webpage-Examination.xls template and go to the "By Cascading
Value" worksheet. Put your URL in cell D7 and "[" in cell D8. Then you
should see each "[...]" as the first item of each line. Then, it's just a
matter of parsing the three items out of each line.
For example, to parse out the items on line 13:
=smfWord($D13,2,"""")
=smfWord($D13,4,"""")
=smfWord($D13,6,"""")
1234 ZCTA5 00601 00601
2009 ZCTA5 00602 00602
3603 ZCTA5 00603 00603
470 ZCTA5 00606 00606
1531 ZCTA5 00610 00610
3489 ZCTA5 00612 00612
536 ZCTA5 00616 00616
I do this kind of stuff all the time. :)
On Sat, Feb 23, 2019 at 12:03 AM gz_cp@... wrote:
> I am looking for a way to use SMF to download US Census data through its
> API such as
>
>
> https://api.census.gov/data/2017/acs/acs5?get=B00001_001E,NAME&for=zip%20code%20tabulation%20area:*
>
> or
>
>
> https://api.census.gov/data/2017/acs/acs5?get=B00001_001E,NAME&for=metropolitan%20statistical%20area/micropolitan%20statistical%20area:*
>
> I want the results to go to cells.
>
> Is it possible?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar