Hot answers tagged

7

Use =INDEX(GoogleFinance("GOOG", "PRICE", "3/3/2000");2;2). Maybe you will need to close date between parenthesis.


1

If you did not insist on array-based formula, then sumifs(C:C, A:A, A2, B:B, "<="&B2) entered in D2 and copied around the D column, would do the job. I don't think that an arrayformula-based solution exists, because arrayformula runs through an array once, performing some element-wise operations. You want to compare each element with all others, ...


1

try Pibi https://www.pibiapp.com/ , its HTML5 and works on the desktop, tablets and mobile phone, you can also customize the categories and enter everything by hand.


1

I found a hack that works here as well. Use =min(GoogleFinance("Goog", "PRICE", "3/3/2000")).


1

I feel your pain... as well as the websites you've tried, I've also played with Xpensr and Buxfer (both free) but couldn't get the alleged QIF or CSV import functionality to work - maybe you'll have more luck. In fact, I think Buxfer is dying a death, so I'd avoid. Some sites that make you pay for this feature include ClearCheckbook, Cashoo, Mvelopes and ...


1

The QIF format is easily parse-able, and you can convert it to CSV or OFX or any other foramt. I don't think the format limits your choices.



Only top voted, non community-wiki answers of a minimum length are eligible