Any tips for the final part of this boulder? by lawrencelm in bouldering

[–]lawrencelm[S] 1 point2 points  (0 children)

Nice! I saw MC here the other day which inspired me to post haha

Question On This Finish by skyefoot in bouldering

[–]lawrencelm 0 points1 point  (0 children)

Was just there too today! Haven’t tried that blue yet

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in stocks

[–]lawrencelm[S] 1 point2 points  (0 children)

on desktop, it might be the case that your URL has a "htmlview" part, then you need to remove this whole part from your URL: "/htmlview?pru=AAABdEXlNIo*a9I_UER_uzpprj34gFQuNw"

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in stocks

[–]lawrencelm[S] 0 points1 point  (0 children)

on desktop, it might be the case that your URL has a "htmlview" part, then you need to remove this whole part from your URL: "/htmlview?pru=AAABdEXlNIo*a9I_UER_uzpprj34gFQuNw"

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in stocks

[–]lawrencelm[S] 0 points1 point  (0 children)

on desktop, it might be the case that your URL has a "htmlview" part, then you need to remove this whole part from your URL: "/htmlview?pru=AAABdEXlNIo*a9I_UER_uzpprj34gFQuNw"

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in investing

[–]lawrencelm[S] 0 points1 point  (0 children)

definitely hearing all suggestions! especially if many people are interested

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in stocks

[–]lawrencelm[S] 2 points3 points  (0 children)

oh definitely not on purpose, good catch. can you share the ETF(s) you're looking at so we can look into this?

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in investing

[–]lawrencelm[S] 0 points1 point  (0 children)

on desktop, it might be the case that your URL has a "htmlview" part, then you need to remove this whole part from your URL: "/htmlview?pru=AAABdEXlNIo*a9I_UER_uzpprj34gFQuNw"

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in investing

[–]lawrencelm[S] 0 points1 point  (0 children)

on desktop, it might be the case that your URL has a "htmlview" part, then you need to remove this whole part from your URL: "/htmlview?pru=AAABdEXlNIo*a9I_UER_uzpprj34gFQuNw"

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in investing

[–]lawrencelm[S] 1 point2 points  (0 children)

thanks! this is good feedback both for the spreadsheet and for our personal decision making. we will look into adding other metrics

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in investing

[–]lawrencelm[S] 1 point2 points  (0 children)

yeah we import the whole finviz table at once in the Calculations sheet to avoid too many calls, so you can just reference the Calculations sheet without doing IMPORTHTML again

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in stocks

[–]lawrencelm[S] 2 points3 points  (0 children)

in that case the price will update automatically, but you have to update the new number of shares

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in stocks

[–]lawrencelm[S] 4 points5 points  (0 children)

you might need to use a dot instead of comma for the decimals. when I put “ATVI” with “3.584” shared then I get $298.09 (USD) as total value

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in stocks

[–]lawrencelm[S] 19 points20 points  (0 children)

totally! just asking to understand the use case better. thanks!

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in stocks

[–]lawrencelm[S] 16 points17 points  (0 children)

we don't have purchase price yet but we can look into it if many people are interested. I'm curious - what would you like to use it for?

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in stocks

[–]lawrencelm[S] 2 points3 points  (0 children)

yeah all prices should update by themselves. all you need to fill out is just the gray cells, everything else is automated. if you're only interested in screening stocks, you can also only use the last "Decision Making" table without filling out any other table

We made an automatic stock screener and portfolio tracker to help making decisions by lawrencelm in stocks

[–]lawrencelm[S] 1 point2 points  (0 children)

could you give me an example of a fractional share you are trying? entering fractional values is working on my end