Plus, he's posting videos that are supposed to help people so why not helps someone asking for help? What a douche!Īnyway, thanks so much for your help. I asked in the comment section if he could please copy and paste his equation so we could do our own spreadsheets and he said "you have to go out and scrape the data from Big Charts" - like it wouldn't take him two seconds to help someone out. However, he never clicked on his price change cell so I couldn't see what formula he had.
Big charts market watch full#
I could see when he clicked on his share price cell, the formula was visible, so I went into full screen and copied it. I guess, I'll keep mine since I'm kinda proud that I was put it together and these days, I like to remember my accomplishments, as minor as they might be.Īctually, this all started when I watched a YouTube video with a "stock guru" who kept referring to his spreadsheet and I wanted to make one for myself. Yours is of course proper and more elegant and mine is something I slapped together with some glue and duct tape - but it gets the job done.
Big charts market watch code#
Incidentally, your code works with IFERROR as well: I tested it and, low and behold, it works great!!
#VALUE! So if it can do that why not UNCH, right? I figured it was your job as a coder to figure out what your error was and to fix it, not have an error actual result in something.īut if you think about it, an error already produces something. I knew my equation was producing an error and trying to figure out how an error could produce a result but I never imagined that developers would have a rule for what an equation should do if an error occurs. I feel like one of those physicists theorizing the existence of a quark. IFERROR is exactly the kind of "IF/THEN" thing I was looking.
Big charts market watch how to#
If you know how to fix the last piece of the puzzle, then you are truly a genius! I'd prefer not muddying up my spreadsheet will number just there to reference a further result in the cells I want to be populated if you see what I'm saying. I was thinking a fix might be some kind of IF THEN but IF THENs usually reference the result of another cell and in this case the scrape info and the IF THEN would all have to happen in the same cell. I would be fine with the cell just having UNCH show up when that happens, but the formula, receiving text, comes back with an error. Big Charts, instead of sending something numeric, sends out text saying "UNCH." For example, if you look at stock symbol JWS.WT on Big Charts you can see it ended the day unchanged, and if you put that symbol in the A1 reference cell, you can see what happens – the formula produces a #VALUE! error in the cell. There is a rare instance when at the end of the day, a stock didn't go up or down and ends unchanged. There is one last piece of the puzzle and perhaps you might know how to fix it. Of course, as a novice, I don't understand exactly how it works. I think your Substitute / "Change:" did the same thing. Oddly, at first, this formula gave me a cell that was double the height for some reason but when I added the +0 at the end, I believe it became a true formula instead of just a scrape and the cell then became a single height with the "carriage return" effect. I came up with one myself in collaboration with another redditor and some creative noodling around with the two numbers (8,9) after ,3,2. Thanks! Yes, that certainly works and is no doubt proper coding.
0 kommentar(er)
