I would like to monitor my stock portfolio automatically.
I read it's possible using Google sheets + Google finance, but it doesn't have all the ETFs.
Does anyone know about an alternative always using Google sheet?
I read about using =importxml but I couldn't manage to understand how to do it.

Thanks in advance to those buddies who'd like to help!

like
Posting as :
works at
You are currently posting as works at

1 - How much delay are you ok to have?
2 - US stock? Major exchanges or penny stocks?
3 - basic track?

If your portfolio is only made from S&P stocks for example, you can pull the information directly from excel (and you just want price/basic information).

I'd use S&P Capital IQ add-in, but that depends on you having it

Related Posts

How many of y'all have trust funds? What'd you do with the $$$?

like

Personal finance book recommendations?

like

Mutual funds you have your eye on right now?

like

Hey, I am looking for an Angel investor to invest in our idea. Can someone help me to connect with the person.

like

When do you predict the dip? I've been waiting for so long, but don't want to buy now. VTI seems inflated.

likefunny

Is there a way to get closer to the 58000 total contribution limits in a 401k after initial contributions up the 19500 limit? My employer match isn’t great but I’ve maxed out my contributions this year and they’ve only added an additional 1500 so I’ll be at 21k total in the account for the year. How can I get more in there to bridge that 37k gap? Or can I?

like

What are the benefits of a trust in estate planning for a single person with assets around $2m?

like
like

I am curious how Onesource Income tax stacks up against it's competition.

I have an idea for an investment-type thing but am trying to figure out what price point would be attractive to your “everyday” affluent but not 1%er family (I’m talking the 3%ers like myself). If you fit that demographic and were offered a solid investment opportunity with a guaranteed annual yield of 8% and an appreciation of the underlying asset of at 3%, how much would you be willing to invest in it without stressing too much? 10k? 25k? To be clear, not seeking investors here.

like

Hi! Does anyone have a recommendation on a realtor? Looking for a condo in DC

like

Pre-tax 401(k) or after-tax...thoughts?

like

Anyone holding Hyln for long term ? What did you buy it for and what is your price target ?

like

For those with corporate banking expertise, how do you typically go about calculating debt capacity for a company?

like

Can anyone here explain the taxes on RSUs. A yearly xxxxx usd on being converted to some amount after selling is fetching a lot less. Feel almost a loooot is getting cut in taxes way more than 30%

like

Is it just me or does anyone else know or have an inclination that their employer committed fraud after receiving PPP loans during COVID pandemic?

like

I want more money

likefunny

Question for Sales leaders who’ve said “I did an analysis and concluded we just need more at bats”.

Does it feel like you’re saying something useful? Or are you also writing a book titled “In order to get rich you just need more money”?

likefunny

Difference between Variable Life vs Variable Universal Life?

Looking for advice to safely invest Escrow portion of my mortgage, since I was able to stop paying from Escrowz starting this month.

As you know, this cannot be risk in stock market, what are safe options

like

More Posts

Anyone else just absolutely despise Kryterion and their service reps? They are so rude and I just can’t stand it

likefunny

CMAAS Senior Associate interview questions?

like

Those who moved from MBB to Strategy& , why did you do it? Pros and cons?

like

I might need a freelance PM w/ creative resource experience or just a creative resources manager. Mid to senior level. Fully remote but must work CA hours.

If you might be right, DM me your LinkedIn link?

like

Hi need a referral at Bank of America for data engineer profile

My manager asked me to help sprint this proposal. I’m out in 6 weeks. How do I kindly tell him to GTFO

like

Just moved to Chicago and looking to make new friends.

Age 26, if that matters

like

I’m interviewing for a job and am in the third and final round. I have to develop a strategy based off of a case study and then do a 30 minute presentation to a panel of people. I haven’t ever done this before. Does anyone have any advice or best practices for this?

like

Hello, I am seeking for resume assistance. I have my resume updated but would like for someone's expertise in adjusting where needed and condesed into 1 page vs. 2. TIA

like

I gave interview (Manager round) last Friday at Deloitte India. Haven't heart back tried calling hr but no luck. When can I expect result or feedback, is this a dead end for me? Deloitte @deloitteindia.

like

Is it mandatory to pass Barclays GSC test after completing people screening and joining after 2 weeks? I got the email now.

like

How is everyone’s workload? I was insanely busy the last month but the past week or so has slowed significantly.

like

Has anyone here left their job due to burnout?

If yes, what are you doing now or what do you plan to do? How has the experience been?

like

Your secret weapon to deal with stress at the office?

like

What should be the Salary ask be for Sr. Consultant @ EY India Tech Risk practise?
Relevant YOE - 5 years.

like

The accuracy 😂😅

Post Photo
likefunny

 I heard a commercial on the radio for Verizon that said something to the effect that parents are now learning how to lesson plan. Are any of you off the hook for lesson planning? Just wondering because I’m over here busting my butt!

funnylikehelpful

How does a panel interview feel like? Is there anything that I should be prepare for it? Any tips?

like

Does anyone have question suggestions for a final interview with skip level boss? Big picture, vision for the role + team, growth strategy type questions! Thanks :)

like

Additional Posts in Excel Genius

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Would anyone be willing to teach me vlookup?

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal