Jumat, 30 Mei 2014

[smf_addin] Digest Number 3079

8 Messages

Digest #3079

Messages

Thu May 29, 2014 6:17 am (PDT) . Posted by:

pragaon

Thanks Randy,

Now I have next challenge...


I have 2 portfolios and first one has say 50 stocks and second one has 50 stocks.
when download the second portfolio, it starts in the csv file at row 52. (first 51 rows has been used by portfolio1 for first row + 50 rows of data).


So if i have to import both portfolios in single sheet, how can i give multiple links? using AND did not worked.


= ( smfGetCSVFile("https://www.google.com/finance/portfolio?pid=2&output=csv") & smfGetCSVFile("https://www.google.com/finance/portfolio?pid=3&output=csv") )





for some reason, I do not want to create a single portfolio with 100 symbols..


thanks,
Prakash

Thu May 29, 2014 6:45 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You'll need to array-enter the two formulas over their own ranges.

That may cause an issue if you add or delete things from the first
portfolio.

On Thu, May 29, 2014 at 6:17 AM, pragaon@... wrote:

>
> Now I have next challenge...
>
> I have 2 portfolios and first one has say 50 stocks and second one has 50
> stocks.
> when download the second portfolio, it starts in the csv file at row 52.
> (first 51 rows has been used by portfolio1 for first row + 50 rows of
> data).
>
> So if i have to import both portfolios in single sheet, how can i give
> multiple links? using AND did not worked.
>
> = ( smfGetCSVFile("
> https://www.google.com/finance/portfolio?pid=2&output=csv") &
> smfGetCSVFile("https://www.google.com/finance/portfolio?pid=3&output=csv")
> )
>
> for some reason, I do not want to create a single portfolio with 100
> symbols..
>
>

Thu May 29, 2014 7:00 am (PDT) . Posted by:

pragaon

I thought so. Thanks for confirming.

How do i refresh the link for the array?
=smfGetCSVFile("https://www.google.com/finance/portfolio?pid=2&output=csv")



i tried refresh, f9 and even closing and opening the file. Nothing worked.




Thu May 29, 2014 7:05 am (PDT) . Posted by:

pragaon

i take that back...opening and closing the file will refresh. (after i saved it as .xlsm) but refresh button or f9 are still not working...

Thu May 29, 2014 7:27 am (PDT) . Posted by:

pragaon

found answer somewhere on web....

This often happens with very large and complex spreadsheets. Here are some workarounds you could try:
CTRL + ALT + SHIFT + F9 to recheck all formula dependencies and then recalculate all formulas.

Thanks Randy for your attention.

Thu May 29, 2014 7:56 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You need to run the smfForceRecalculation macro. See the "Tips and FAQs"
page for more info on it.

On Thu, May 29, 2014 at 7:00 AM, pragaon@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I thought so. Thanks for confirming.
>
> How do i refresh the link for the array?
> =smfGetCSVFile("https://www.google.com/finance/portfolio?pid=2&output=csv
> ")
>
> i tried refresh, f9 and even closing and opening the file. Nothing worked.
>
>
>

Thu May 29, 2014 4:13 pm (PDT) . Posted by:

markap42

Is there any function for an avg bid/ask ratio for an ETF?


-Thanks, Mark


Yahoo Groups https://groups.yahoo.com/neo/groups/smf_addin/conversations/newtopic Yahoo! Groups offers free mailing lists, photo & file sharing, group calendars and more. Discuss hot topics, share interests, join online communities.



View on groups.yahoo.com https://groups.yahoo.com/neo/groups/smf_addin/conversations/newtopic
Preview by Yahoo



Thu May 29, 2014 4:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I've never even seen such a data item. If you have a source, you might be
able to use RCHGetTableCell() or smfGetTagContent() to grab it.

On Thu, May 29, 2014 at 11:56 AM, markap42@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Is there any function for an avg bid/ask ratio for an ETF?
>
>
Diposting oleh EXCEL FEED LEARNING di 03.37

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)