5 Messages
Digest #4276
Messages
Tue Dec 26, 2017 9:49 pm (PST) . Posted by:
mff2805
ah yes. i started working on that the last hour or so. thanks for the suggestion.
one thing i notices is that you note that a table of VALUES results. on my other working spreadsheet i use this function call to get a company profile paragraph of info about the company.
=smfstrExtr(smfGetTagContent(G3,"div",1,"company_profile")&"|", " <p>", "</p>")
where G3 is the URL, such as https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?q=MMM&submit=submit&type=site https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?q=MMM&submit=submit&type=site
it seems that this function call is not working with the UpdateDownloadTable functionality. does this correct.
also, on one of the link, about thios UpdateDownload Table functionality, you describe how you assign the macro to crtl-chift-j.
In my own spreadsheet, i cannot find the smfUpdateDownloadTable() macro listed to assign to an item like a text box. all i see are macros in my own spreadsheets. is there something special i need to do to assign an item or a key combo to a macro in the add-in? or might i need to copy the macro code from the add-in, into my own spreadsheet?
thanks much,
Mike
one thing i notices is that you note that a table of VALUES results. on my other working spreadsheet i use this function call to get a company profile paragraph of info about the company.
=smfstrExtr(smfGetTagContent(G3,"div",1,"company_profile")&"|", " <p>", "</p>")
where G3 is the URL, such as https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?q=MMM&submit=submit&type=site https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?q=MMM&submit=submit&type=site
it seems that this function call is not working with the UpdateDownloadTable functionality. does this correct.
also, on one of the link, about thios UpdateDownload Table functionality, you describe how you assign the macro to crtl-chift-j.
In my own spreadsheet, i cannot find the smfUpdateDownloadTa
thanks much,
Mike
Wed Dec 27, 2017 1:46 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The smfUpdateDownloadTable uses the VBA Evauate() function. Unfortunately,
it errors out if the string being returned is longer than 255 characters.
So the best you could do using the macro is to return the profile in
255-byte chunks.
Alt+F8 only displays macros in open WORKBOOKS. It won't list any from an
add-in. But you can type in the macro name and then the grayed out boxes on
the right will become active. I have the macro assigned to a button on my
Quick Access Toolbar. It's also available on the SMF context menu options.
On Tue, Dec 26, 2017 at 10:49 PM, mff3429@
...
wrote:
>
> ah yes. i started working on that the last hour or so. thanks for the
> suggestion.
> one thing i notices is that you note that a table of VALUES results. on
> my other working spreadsheet i use this function call to get a company
> profile paragraph of info about the company.
> =smfstrExtr(smfGetTagContent(G3,"div",1,"company_profile")&"|", "
> <p>", "</p>")
> where G3 is the URL, such as https://navelliergrowth.
> investorplace.com/portfolio-grader/stock-report.html?q=
> MMM&submit=submit&type=site
> it seems that this function call is not working with the
> UpdateDownloadTable functionality. does this correct.
>
> also, on one of the link, about thios UpdateDownload Table functionality,
> you describe how you assign the macro to crtl-chift-j.
> In my own spreadsheet, i cannot find the smfUpdateDownloadTable() macro
> listed to assign to an item like a text box. all i see are macros in my
> own spreadsheets. is there something special i need to do to assign an
> item or a key combo to a macro in the add-in? or might i need to copy the
> macro code from the add-in, into my own spreadsheet?
>
>
it errors out if the string being returned is longer than 255 characters.
So the best you could do using the macro is to return the profile in
255-byte chunks.
Alt+F8 only displays macros in open WORKBOOKS. It won't list any from an
add-in. But you can type in the macro name and then the grayed out boxes on
the right will become active. I have the macro assigned to a button on my
Quick Access Toolbar. It's also available on the SMF context menu options.
On Tue, Dec 26, 2017 at 10:49 PM, mff3429@
...
wrote:
>
> ah yes. i started working on that the last hour or so. thanks for the
> suggestion.
> one thing i notices is that you note that a table of VALUES results. on
> my other working spreadsheet i use this function call to get a company
> profile paragraph of info about the company.
> =smfstrExtr(smfGetTagContent(G3,"div",1,"company_profile")&"|", "
> <p>", "</p>")
> where G3 is the URL, such as https://navelliergrowth.
> investorplace.
> MMM&submit=submit&t
> it seems that this function call is not working with the
> UpdateDownloadTable functionality. does this correct.
>
> also, on one of the link, about thios UpdateDownload Table functionality,
> you describe how you assign the macro to crtl-chift-j.
> In my own spreadsheet, i cannot find the smfUpdateDownloadTa
> listed to assign to an item like a text box. all i see are macros in my
> own spreadsheets. is there something special i need to do to assign an
> item or a key combo to a macro in the add-in? or might i need to copy the
> macro code from the add-in, into my own spreadsheet?
>
>
Wed Dec 27, 2017 5:04 pm (PST) . Posted by:
v4pnaah6cygf2nzx2356pl2ugoa3ti5fowi4gdzj
Thanks for your reply.
What I wanted to do was tabulate and plot portfolio performance Vs. date (daily closing price) taking into account dividends separately. I am only considering a short time period, so didn't want to include splits and/or dividends.
I guess what I can do is take the difference between my purchase price and the adjusted closing prices. This would give me performance including dividends and any splits.
Thanks for your insight.
Ron Johnson
What I wanted to do was tabulate and plot portfolio performance Vs. date (daily closing price) taking into account dividends separately. I am only considering a short time period, so didn't want to include splits and/or dividends.
I guess what I can do is take the difference between my purchase price and the adjusted closing prices. This would give me performance including dividends and any splits.
Thanks for your insight.
Ron Johnson
Wed Dec 27, 2017 5:42 pm (PST) . Posted by:
rogacox
Hi Randy, I am running into the same problem of not being able to grab data from nasdaq. For instance when I use the line code of RCHGetTableCell("www.nasdaq.com/symbol/~~~~~",1,"1 Year Target") I get an error message. I have tried variants replacing the "~~~~~" with a cell reference and get a #VALUE! error message. If I could grab a string from the web page and examine it, I could extract the numbers I need from the string. Any help is much appreciated. Also, some sited like Marketbeat.com display a stock's information using tabs all within the same url. I am trying to extract target price information - in this case from the Analyst Ratings tab. Since the url does not change, how do I access the information. Roger
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar